• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Flat file cross reference

adeel

VIP Member
Hello.
Is anyone knows which BSFN has flat file layout for time cards?
I matched the flat file layout with z table structure and it is not lining up. Any feedback will be helpful.
 

ShrinkMe

Member
Could you give a little more detail on what you are doing? Are you using a specific UBE to load your time card flat file?
 

adeel

VIP Member
Yes it is batch upload R47002c which import csv file in f060116z1.
It is s payroll process. Not know too much business side. Thanks Brain.
 

Kim Schmidt

Active Member
Hi, I think your problem is the size of the timecard file F06116Z1 = 4,879 characters. The business function B4700240 states the maximum length per line is 4,095. You could write your own table conversion to do the same thing or customize the business function to make its buffer larger.
 

adeel

VIP Member
Kim
I just want to know why our csv file fields does not match with table fo60611z1 structure (field by field) but it works when we run UBE.
The 1st field is "2" in csv which I believe represent detail but in table this does not even exists.
 

Kim Schmidt

Active Member
Hi, Are we possibly talking about two different tables? JDE Payroll has many tables with confusing similar names. For example, the time card Z table is F06116Z1 while the Employee Master Z table is F060116Z. If you want to verify table layouts, a good reference for details of JDE tables is jderef.com - it's a lot quicker than messing around with OMW tools.
 

Tom_Davidson

VIP Member
My guess is the 2, tells the z program which z file the line goes in. so the 2 is now defined implicitly by which table you are talking about.

Tom
 

adeel

VIP Member
The table F06116Z1 we setup in p47002 and csv layout is below but if you look the table structure with field by field it does not match with the file layout below.

"2","ADEELA"," "," ","10"," ","1"," "," ","03/01/19","R"," ","0","A","1","010314"," "," ","1234"," "," "," "," "," "," "," ","1222000 "," "," "," "," "," "," "," "," "," "," "," "," ","7.00"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ","1"," "," "," "," "," "," "," "," "," "," "," ","17/02/19"," "," "," "," ","0"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "

Thanks in advance
 
Top