| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0014 | Payment Terms | 1 | PN | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 2 | F00141 | Advanced Payment Terms | 1 | L3 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 3 | F00144 | Installment Payment Terms | 1 | L6 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 4 | F004201 | Prepayment Transaction Table | 48 | PT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP03: Accounts Receivable |
| 5 | F0311 | Accounts Receivable Ledger | 56 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 6 | F03B11 | Customer Ledger | 55 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 7 | F03B112 | Invoice Revisions | 47 | RW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 8 | F03B112P | Invoice Revisions Purge File | 47 | RW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 9 | F03B11P | Customer Ledger Purge File | 55 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 10 | F03B11Z1 | Invoice Transactions - Batch File | 72 | VJ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 11 | F03B11Z2 | F03B11 Interoperability Table | 68 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 12 | F03B20 | A/R Notification History | 38 | ZR | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 13 | F03B21 | A/R Notification History Detail | 22 | ZS | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 14 | F03B22 | A/R Fee Journal History | 17 | RS | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 15 | F03B575 | Auto Debit Invoice Select and Build | 64 | RD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP04: Accounts Payable |
| 16 | F0411 | Accounts Payable Ledger | 54 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 17 | F0411A | WF - As Of - Accounts Payable Ledger | 54 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 18 | F0411P | Purge - Accounts Payable Ledger | 54 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 19 | F0411Z1 | Voucher Transactions - Batch File | 72 | VL | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 20 | F0411Z3 | F0411 Interoperability Table | 77 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP07: Payroll |
| 21 | F06492 | Payroll - Accounts Payable Control | 7 | JC | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 22 | F07492 | Payroll - Accounts Payable Control File | 7 | JC | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP15: Property Management |
| 23 | F1511 | Tenant/Lease Billings Detail | 27 | NJ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 24 | F1511B | Tenant/Lease Billings Detail Master | 27 | NJ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 25 | F1511H | Tenant/Lease Billings Detail History | 27 | N# | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 26 | F1511HB | Tenant/Lease Billings Detail History | 27 | NC | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 27 | F1525 | A/R Fee Interest | 34 | N0 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 28 | F1525B | A/R Fee and Interest | 31 | NM | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP17: Customer Service Management |
| 29 | F1720 | Contract Header | 31 | CH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 30 | F1721 | Contract Detail | 95 | CD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP17C: Call Management |
| 31 | F1755 | Customer Call Master | 204 | ZA | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 32 | F1760 | Time Entry | 83 | ZB | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP40: Inventory/OP Base |
| 33 | F4001Z | Batch Receiver File - Order Headings | 53 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 34 | F4011Z | Batch Receiver File - Order Details | 103 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 35 | F40301 | Preference Profile - Payment Terms | 12 | PT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 36 | F40301R | Preference Resolution Ledger - Payment Terms | 14 | PT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 37 | F40338 | Preference Profile - Payment Terms (Branch) | 14 | PT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 38 | F40338R | Preference Resolution Ledger - Payment Terms (Branch) | 16 | PT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 39 | F4201Z1 | Sales Order Header Unedited Transaction File | 42 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 40 | F4211Z1 | Sales Order Detail Unedited Transaction File | 100 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 41 | F49211 | Sales Order Detail File - Tag File | 55 | UD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 42 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 68 | S1 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 43 | F49219 | Sales Order Detail - Tag History File | 55 | UD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP42: Sales Management |
| 44 | F4201 | Sales Order Header File | 29 | SH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 45 | F42019 | Sales Order Header History File | 29 | SH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 46 | F4211 | Sales Order Detail File | 87 | SD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 47 | F42119 | Sales Order History File | 87 | SD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 48 | F42199 | S.O. Detail Ledger File | 87 | SL | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 49 | F42565 | Invoice Print File | 65 | IW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 50 | F42UI01 | SO Header Cache File (MBF) | 34 | ZH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 51 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 26 | ZD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 52 | F42UI520 | Pick Slips Header File | 31 | S8 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 53 | F42UI521 | Pick Slips Detail File | 80 | S9 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP42B: Sales Order Entry |
| 54 | F42420 | Audit Log Transaction | 61 | AL | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 55 | F49299 | S.O. Detail Tag Ledger File | 55 | UD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP43: Procurement |
| 56 | F4301 | Purchase Order Header | 32 | PH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 57 | F4301Z | PO Header Work File | 36 | PA | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 58 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 45 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 59 | F43080 | Approvals Fields Constants | 9 | PD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 60 | F4311 | Purchase Order Detail File | 87 | PD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 61 | F4311Z | Purchase Order Generator File | 91 | PW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 62 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 100 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 63 | F43121 | Purchase Order Receiver File | 33 | PR | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 64 | F43121Z | Receiver workfile | 76 | PW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 65 | F43121Z1 | Receipts Unedited Transaction Table | 50 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 66 | F4314Z | Voucher Match Selection File | 132 | PN | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 67 | F43199 | P.O. Detail Ledger File - Flexible Version | 87 | OL | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 68 | F43UI50D | PO Print Detail Work File | 55 | PW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 69 | F43UI50H | PO Print Header Work File | 35 | PA | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP43C: Contracts |
| 70 | F43C01 | Contract Header | 10 | CH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 71 | F43C10 | Contract Block | 17 | CB | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 72 | F43C11 | Contract Detail | 29 | CD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 73 | F43C20 | Contract Payee | 6 | CP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP43Q: Strategic Sourcing |
| 74 | F43Q10 | Event Header | 13 | EH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 75 | F43Q50 | Analyze Event Header | 25 | AV | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP44H: Homebuilder Management |
| 76 | F44H601 | Bid Header | 35 | BH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 77 | F44H611 | Bid Details | 52 | BD | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 78 | F44H611W | Bid Details Work File | 56 | BW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 79 | F44H711 | Lot Start Workfile | 59 | SW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 80 | F44H711Z | HB Lot Start Unedited Transaction File | 72 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 81 | F44H71W1 | Lot Start Generation Workfile | 59 | GW | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 82 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 32 | CG | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP45: Advanced Pricing |
| 83 | F45520 | Price List Header | 12 | PH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP47: Electronic Commerce |
| 84 | F47011 | EDI Purchase Order Header - Inbound | 48 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 85 | F47012 | EDI Purchase Order Detail - Inbound | 104 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 86 | F47016 | EDI Purchase Order Header - Outbound | 47 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 87 | F47017 | EDI Purchase Order Detail - Outbound | 101 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 88 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 47 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 89 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 101 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 90 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 44 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 91 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 104 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 92 | F47031 | EDI Shipping Notice Header - Inbound | 42 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 93 | F47032 | EDI Shipping Notice Detail - Inbound | 72 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 94 | F47037 | EDI Shipping Notice Detail - Outbound | 99 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 95 | F470371 | EDI Shipping Notice Detail - Outbound | 110 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 96 | F47041 | EDI Invoice Header - Inbound | 37 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 97 | F47042 | EDI Invoice Detail - Inbound | 83 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 98 | F47046 | EDI Invoice Header (Sales) - Outbound | 44 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 99 | F47047 | EDI Invoice Detail (Sales) - Outbound | 104 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 100 | F47057 | EDI Payment Order Remittance Advice - Outbound | 83 | D3 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 101 | F47057W | EDI Payment Order Remittance Advice - Work | 83 | D3 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 102 | F47071 | EDI Receiving Advice Header - Inbound | 48 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 103 | F47072 | EDI Receiving Advice Detail - Inbound | 102 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 104 | F47076 | EDI Receiving Advice Header - Outbound | 48 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 105 | F47077 | EDI Receiving Advice Detail - Outbound | 102 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 106 | F47091 | EDI Request for Quote Header - Inbound | 48 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 107 | F47092 | EDI Request for Quote Detail - Inbound | 104 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 108 | F47096 | EDI Request for Quote Header - Outbound | 47 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 109 | F47097 | EDI Request for Quote Detail - Outbound | 101 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 110 | F47101 | EDI Response to RFQ Header - Inbound | 47 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 111 | F47102 | EDI Response to RFQ Detail - Inbound | 101 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 112 | F47106 | EDI Response to RFQ Header - Outbound | 44 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 113 | F47107 | EDI Response to RFQ Detail - Outbound | 104 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 114 | F47131 | EDI Purchase Order Change Header - Inbound | 45 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 115 | F47132 | EDI Purchase Order Change Detail - Inbound | 105 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 116 | F47136 | EDI Purchase Order Change Header - Outbound | 47 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 117 | F47137 | EDI Purchase Order Change Detail - Outbound | 102 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 118 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 48 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 119 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 103 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 120 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 45 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 121 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 106 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 122 | F47156 | EDI Shipping Schedule Header - Outbound | 50 | SY | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 123 | F47157 | EDI Shipping Schedule Detail - Outbound | 108 | SZ | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP48S: Service Billing |
| 124 | F4822 | Invoice Summary Work File | 16 | W4 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 125 | F4823 | Voucher Summary | 14 | W0 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP52: Contract Billing |
| 126 | F5201 | Contract Master File | 40 | G4 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP55: Reserved for Clients |
| 127 | F74H1050 | Invoicing Workfile Header - New | 12 | IH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP74: EMEA Localization |
| 128 | F7430030 | Legal Document Header (Print Info) - COMM - 03B | 6 | PI | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 129 | F74900 | Foreign Receivables and Payables - EMEA | 62 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP76A: Argentina |
| 130 | F76A21 | Credit Invoice Header - F76A21 - ARG - 3B - 76A | 17 | IH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 131 | F76A21P | Credit Invoice Header Purge - ARG - 03B - 76A | 17 | IH | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 132 | F76AUI51 | Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A | 8 | IK | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 133 | F76B0401 | Tax Code - 04 | 18 | CT | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| 134 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 26 | W3 | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP76C: Colombia |
| 135 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 54 | RP | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP76H: Chile |
| 136 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 4 | PI | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
| TOP89: Conversion Programs |
| 137 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 87 | OL | PTC | Payment Terms Code | String | Generic Edit | 3 | 0 |
