| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F4011ZTX | Recurring Order Detail Tax Table | 5 | ZT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP42: Sales Management |
2 | F4211Z1T | Sales Order Detail Unedited Tax Transaction File | 6 | DZ | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
3 | F42565 | Invoice Print File | 190 | IW | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
4 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 143 | ZD | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP42B: Sales Order Entry |
5 | F42119TX | Sales Order Detail History Tax Table | 5 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
6 | F4211TX | Sales Order Detail Tax Table | 5 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
7 | F42199TX | SO Detail Ledger Tax Table | 5 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
8 | F42420TX | Tax Audit Log Transaction | 10 | TA | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP42I: Outbound Inventory Management |
9 | F42I015 | Outbound Inventory Agreement Transaction File | 29 | OI | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP42X: In-Memory Sales Advisor |
10 | F42X010W | Line Advisor Work File | 12 | US | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
11 | F42X020W | Order Advisor Work File | 8 | XC | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
12 | F42X050W | Order Level Upsell Candidate Items | 19 | CI | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP45: Advanced Pricing |
13 | F45521TX | Price List Detail Tax Table | 4 | LT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP47: Electronic Commerce |
14 | F47007 | EDI Order Detail - Outbound Tax Table | 21 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
15 | F47012TX | EDI Purchase Order Detail Tax - Inbound | 20 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
16 | F470371X | EDI Shipping Notice Detail Tax - Outbound | 25 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
17 | F47132TX | EDI Purchase Order Change Detail Tax - Inbound | 20 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |
TOP49: Transportation Management |
18 | F47092TX | EDI Request for Quote Detail Tax - Inbound | 20 | DT | TUPRC | Taxed Unit Price | Numeric | Generic Edit | 15 | 4 |