• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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

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

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.
 
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

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.
 
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.
 
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

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