| Field | Long Name | Description | Type | Len,Dec | Column Headings | Ref File |
|---|---|---|---|---|---|---|
| CMPUNQ | CMPUNQ | Company Unique Number | Zoned Decimal | 5,0 | CMPUNQ// | / |
| CMPNME | CMPNME | Company Name | Alpha | 40 | CMPNME// | / |
| EMPUNQ | EMPUNQ | Employee Unique Number | Zoned Decimal | 5,0 | EMPUNQ// | / |
| EMPNBR | EMPNBR | Employee Visible Number | Zoned Decimal | 8,0 | EMPNBR// | / |
| EMPNME | EMPNME | Employee Name | Alpha | 40 | EMPNME// | / |
| EMPDPT | EMPDPT | Employee Dept | Zoned Decimal | 6,0 | EMPDPT// | / |
| PRJUNQ | PRJUNQ | Project Unique Number | Zoned Decimal | 5,0 | PRJUNQ// | / |
| PRJNME | PRJNME | Project Description | Alpha | 40 | PRJNME// | / |
| CSTUNQ | CSTUNQ | Cost Center Unique Number | Zoned Decimal | 5,0 | CSTUNQ// | / |
| CSTNME | CSTNME | Cost Center Description | Alpha | 40 | CSTNME// | / |
| EXPUNQ | EXPUNQ | Expense Unique Number | Zoned Decimal | 5,0 | EXPUNQ// | / |
| EXPCDE | EXPCDE | Expense Sort Code | Zoned Decimal | 3,0 | EXPCDE// | / |
| EXPTYP | EXPTYP | Expense Type | Alpha | 20 | EXPTYP// | / |
| EXPMLT | EXPMLT | Expense Multiplier | Zoned Decimal | 4,2 | EXPMLT// | / |
| EXPADV | EXPADV | Expense Cash Advance Flag | Alpha | 1 | EXPADV// | / |
| EXPLIN | EXPLIN | Expense Extended To Code | Zoned Decimal | 3,0 | EXPLIN// | / |
| TRNUNQ | TRNUNQ | Transaction Unique Number | Zoned Decimal | 5,0 | TRNUNQ// | / |
| TRNDTE | TRNDTE | Transaction Date | Zoned Decimal | 8,0 | TRNDTE// | / |
| TRNAMT | TRNAMT | Transaction Amount/Quantity | Zoned Decimal | 8,2 | TRNAMT// | / |
| TRNLC1 | TRNLC1 | Transaction From Location | Alpha | 9 | TRNLC1// | / |
| TRNLC2 | TRNLC2 | Transaction To Location | Alpha | 9 | TRNLC2// | / |
| TRNDET | TRNDET | Transaction Details | Alpha | 60 | TRNDET// | / |
| Logical File | Description | Library | Member | Access Path Keys |
|---|---|---|---|---|
| IS929L2 | Transactions by Company, Unq Emp Nbr, Trans Date | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EMPUNQ - Employee Unique Number Zoned Decimal 5,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L4 | Transactions by Company, Project, Expense Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC PRJUNQ - Project Unique Number Zoned Decimal 5,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L5 | Transactions by Company, Cost Center, Exp Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC CSTUNQ - Cost Center Unique Number Zoned Decimal 5,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L6 | Transactions by Company, Dept, Exp Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EMPDPT - Employee Dept Zoned Decimal 6,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L7 | Transactions by Company, Employee, Exp Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EMPNBR - Employee Number Zoned Decimal 8,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L8 | Transactions by Company, Employee, Exp Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EMPNME - Employee Name Alpha 40 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L1 | Transactions by Company, Emp Nbr, Trans Date | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EMPNBR - Employee Number Zoned Decimal 8,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L3 | Transactions by Company, Date, Unique Number | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC TRNDTE - Transaction Date Zoned Decimal 8,0 ASC TRNUNQ - Transaction Unique Number Zoned Decimal 5,0 ASC |
|
| IS929L9 | Transactions by Company, Exp Code | FASTBREED | CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC EXPCDE - Expense Code Zoned Decimal 3,0 ASC |