Results 1 to 8 of 8

Thread: Flat file cross reference

  1. #1

    Flat file cross reference

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

    E9.1.2
    T9.1.2.3

  2. #2
    New Member
    Join Date
    Jan 2005
    Posts
    15
    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?
    Brian Satterlee
    Satterlee Group, Inc.
    1-847-494-5465
    brian@satterleegroup.com
    http://satterleegroup.com

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

  4. #4
    New Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    42
    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.
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

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

  6. #6
    New Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    42
    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.
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

  7. #7
    Member Tom_Davidson's Avatar
    Join Date
    Nov 2000
    Location
    Wisconsin, USA
    Posts
    744
    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
    Cleindori Consulting
    8.12/8.98.4.14, 9.1/9.1.5.3, 9.2/9.2.0.5/6
    IBM i, WebLogic on Windows, DBCS, Global installations.

  8. #8
    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
    Ad

    E9.1.2
    T9.1.2.3

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.