| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | PKFETP | Fee Type | String | UDC (15 FY) | 3 | 0 | Allow NULL? |
| 2 | PKDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | PKAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 4 | PKMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | PKGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 6 | PKAGSN | Auto Generation Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | PKLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 8 | PK74UBKCD | Bank Code | String | UDC (74U BC) | 3 | 0 | Allow NULL? |
| 9 | PK74UCRCD | Lease Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | PKCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 11 | PKACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | PKCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | PK74ULICR | Last Date Interest Calculation Run | Date | Generic Edit | 6 | 0 | |
| 14 | PKURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 15 | PKURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | PKURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 17 | PKUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | PKPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | PKUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 20 | PKUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 21 | PKJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |