| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F004201 | Prepayment Transaction Table | 8 | PT | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP03: Accounts Receivable |
| 2 | F03012 | Customer Master by Line of Business | 17 | AI | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 3 | F03012Z1 | Customer Master LOB-Batch File | 30 | VO | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 4 | F03B11 | Customer Ledger | 99 | RP | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 5 | F03B11P | Customer Ledger Purge File | 99 | RP | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 6 | F03B11Z1 | Invoice Transactions - Batch File | 115 | VJ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 7 | F03B11Z2 | F03B11 Interoperability Table | 112 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 8 | F03B13 | Receipts Header File | 39 | RY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 9 | F03B13P | Receipts Header Purge File | 39 | RY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 10 | F03B13Z2 | F03B13 Interoperability Table | 52 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 11 | F03B575 | Auto Debit Invoice Select and Build | 108 | RD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 12 | F03B672 | Draft Remittance Work File - One World Only | 38 | RD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP17: Customer Service Management |
| 13 | F1720 | Contract Header | 32 | CH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 14 | F1721 | Contract Detail | 96 | CD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 15 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 71 | WQ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP17C: Call Management |
| 16 | F1755 | Customer Call Master | 205 | ZA | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 17 | F1760 | Time Entry | 84 | ZB | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 18 | F4001Z | Batch Receiver File - Order Headings | 54 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 19 | F4011Z | Batch Receiver File - Order Details | 104 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 20 | F40301 | Preference Profile - Payment Terms | 13 | PT | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 21 | F40301R | Preference Resolution Ledger - Payment Terms | 15 | PT | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 22 | F40305 | Preference Profile - Print Messages | 25 | RM | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 23 | F40330 | Preference Profile - Document Set | 20 | DG | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 24 | F40338 | Preference Profile - Payment Terms (Branch) | 15 | PT | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 25 | F40338R | Preference Resolution Ledger - Payment Terms (Branch) | 17 | PT | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 26 | F4201Z1 | Sales Order Header Unedited Transaction File | 43 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 27 | F4211Z1 | Sales Order Detail Unedited Transaction File | 101 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 28 | F4201 | Sales Order Header File | 30 | SH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 29 | F42019 | Sales Order Header History File | 30 | SH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 30 | F4211 | Sales Order Detail File | 88 | SD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 31 | F42119 | Sales Order History File | 88 | SD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 32 | F42199 | S.O. Detail Ledger File | 88 | SL | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 33 | F42UI01 | SO Header Cache File (MBF) | 35 | ZH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 34 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 28 | ZD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 35 | F42UI521 | Pick Slips Detail File | 81 | S9 | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 36 | F42UI800 | Sales Detail Work File - Sales Update | 72 | SD | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP42B: Sales Order Entry |
| 37 | F42420 | Audit Log Transaction | 48 | AL | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 38 | F45520 | Price List Header | 13 | PH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 39 | F47011 | EDI Purchase Order Header - Inbound | 49 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 40 | F47012 | EDI Purchase Order Detail - Inbound | 105 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 41 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 45 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 42 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 105 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 43 | F47037 | EDI Shipping Notice Detail - Outbound | 100 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 44 | F470371 | EDI Shipping Notice Detail - Outbound | 116 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 45 | F47046 | EDI Invoice Header (Sales) - Outbound | 45 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 46 | F47047 | EDI Invoice Detail (Sales) - Outbound | 105 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 47 | F47091 | EDI Request for Quote Header - Inbound | 49 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 48 | F47092 | EDI Request for Quote Detail - Inbound | 105 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 49 | F47106 | EDI Response to RFQ Header - Outbound | 45 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 50 | F47107 | EDI Response to RFQ Detail - Outbound | 105 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 51 | F47131 | EDI Purchase Order Change Header - Inbound | 46 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 52 | F47132 | EDI Purchase Order Change Detail - Inbound | 106 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 53 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 46 | SY | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 54 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 107 | SZ | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP48: Work Order Processing |
| 55 | F4801ST | Purge - Work Order Master Tag File | 58 | WA | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 56 | F4801T | Work Order Master Tag File | 58 | WA | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 57 | F4817 | Service Order Extension | 12 | SR | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP55: Reserved for Clients |
| 58 | F74H1050 | Invoicing Workfile Header - New | 13 | IH | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| TOP76A: Argentina |
| 59 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 36 | WF | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
| 60 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 54 | WF | RYIN | Payment Instrument | Character | UDC | 1 | 0 |
