| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0014 | Payment Terms | 3 | PN | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
2 | F00141 | Advanced Payment Terms | 3 | L3 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
3 | F00144 | Installment Payment Terms | 3 | L6 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
TOP03B: Enhanced Accounts Receivable |
4 | F03B11Z2 | F03B11 Interoperability Table | 136 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
TOP07: Payroll |
5 | F069171 | Payroll Payment/ Reporting Terms | 23 | YP | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
TOP47: Electronic Commerce |
6 | F47016 | EDI Purchase Order Header - Outbound | 105 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
7 | F470161 | EDI Purchase Order Additional Header - Outbound | 38 | S3 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
8 | F47017 | EDI Purchase Order Detail - Outbound | 208 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
9 | F470171 | EDI Purchase Order Additional Detail - Outbound | 34 | S4 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
10 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 105 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
11 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 209 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
12 | F47031 | EDI Shipping Notice Header - Inbound | 98 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
13 | F47032T | EDI Shipping Notice Detail- Inbound Tag | 14 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
14 | F470371 | EDI Shipping Notice Detail - Outbound | 112 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
15 | F47041 | EDI Invoice Header - Inbound | 46 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
16 | F47042 | EDI Invoice Detail - Inbound | 85 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
17 | F470461 | EDI Invoice Additional Header - Outbound | 39 | S3 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
18 | F470471 | EDI Invoice Additional Detail - Outbound | 36 | S4 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
19 | F470473 | EDI Invoice Detail Charges | 35 | S7 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
20 | F47071 | EDI Receiving Advice Header - Inbound | 103 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
21 | F47072 | EDI Receiving Advice Detail - Inbound | 225 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
22 | F47076 | EDI Receiving Advice Header - Outbound | 103 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
23 | F47077 | EDI Receiving Advice Detail - Outbound | 226 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
24 | F47096 | EDI Request for Quote Header - Outbound | 106 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
25 | F47097 | EDI Request for Quote Detail - Outbound | 209 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
26 | F47101 | EDI Response to RFQ Header - Inbound | 107 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
27 | F47102 | EDI Response to RFQ Detail - Inbound | 209 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
28 | F471061 | EDI Response to RFQ Additional Header - Outbound | 39 | S3 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
29 | F471071 | EDI Response to RFQ Additional Detail - Outbound | 36 | S4 | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
30 | F47136 | EDI Purchase Order Change Header - Outbound | 105 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
31 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 106 | SY | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
32 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 210 | SZ | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
TOP48S: Service Billing |
33 | F4812 | Billing Detail Workfile | 105 | WD | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
34 | F4812H | Billing Workfile History | 105 | WD | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
35 | F4812HS | Billing Workfile History Purged Save | 105 | WD | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |
36 | F48SUI01 | Billing Detail Print Workfile | 105 | WD | DCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 |