| 42: Sales Management |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
|---|
| 1 | 812 | F4015W | OD | 3 | 2 | Order Templates - Web Customers | Extra Features Files | 42B: Sales Order Entry | No |
| 2 | 812 | F4020 | AR | 32 | 1 | Freight/Additional Charges Rate Information | Constants Files | 42: Sales Management | AS400 Coexistence Tables |
| 3 | 812 | F4074 | AL | 70 | 1 | Price Adjustment Ledger File | Transaction Files | 45: Advanced Pricing | AS400 Coexistence Tables |
| 4 | 812 | F42003 | RE | 8 | 2 | Related Salesperson File | Extra Features Files | 42: Sales Management | AS400 Coexistence Tables |
| 5 | 812 | F42004 | CM | 22 | 2 | Commission Constants File | Extra Features Files | 42: Sales Management | AS400 Coexistence Tables |
| 6 | 812 | F42005 | SC | 52 | 2 | Sales Commission File | Extra Features Files | 42: Sales Management | AS400 Coexistence Tables |
| 7 | 812 | F4201 | SH | 133 | 9 | Sales Order Header File | Transaction Files | 42: Sales Management | AS400 Coexistence Tables |
| 8 | 812 | F42019 | SH | 133 | 3 | Sales Order Header History File | History Files | 42: Sales Management | AS400 Coexistence Tables |
| 9 | 812 | F4211 | SD | 254 | 15 | Sales Order Detail File | Transaction Files | 42: Sales Management | AS400 Coexistence Tables |
| 10 | 812 | F42119 | SD | 254 | 7 | Sales Order History File | History Files | 42: Sales Management | AS400 Coexistence Tables |
| 11 | 812 | F42140 | CM | 22 | 2 | Customer Master Commission Information | Files | 42: Sales Management | Business Data |
| 12 | 812 | F42150 | SH | 9 | 1 | Sales Order Header Commission Information | Files | 42: Sales Management | Business Data |
| 13 | 812 | F4216 | XD | 19 | 4 | SO Pack Confirm Detail | Transaction Files | 49: Transportation Management | No |
| 14 | 812 | F42160 | SD | 11 | 1 | Sales Order Detail Commission Information | Files | 42: Sales Management | |
| 15 | 812 | F42160A | SD | 8 | 1 | Temp Table Sales Order Commission information | Files | 42: Sales Management | |
| 16 | 812 | F42199 | SL | 254 | 1 | S.O. Detail Ledger File | History Files | 42: Sales Management | AS400 Coexistence Tables |
| 17 | 812 | F4229 | SS | 64 | 1 | Sales Summary History File | Extra Features Files | 42: Sales Management | AS400 Coexistence Tables |
| 18 | 812 | F4239 | LC | 14 | 1 | Last Customer Shipment | Files | 42: Sales Management | Business Data |
| 19 | 812 | F42430 | CS | 10 | 1 | Customer Set | Files | 42: Sales Management | Business Data |
| 20 | 812 | F42565 | IW | 180 | 5 | Invoice Print File | Regular Work Files | 42: Sales Management | No |
| 21 | 812 | F42800G | SG | 46 | 1 | Sales Update G Batch Workfile | Files | 42: Sales Management | |
| 22 | 812 | F42800G1 | DG | 125 | 1 | Sales Update G Batch Detail Workfile | Files | 42: Sales Management | |
| 23 | 812 | F42800TP | TP | 2 | 1 | Sales Update TP Failure Table | Files | 42: Sales Management | |
| 24 | 812 | F4290 | SE | 19 | 1 | Delivery Note History | History Files | 42: Sales Management | AS400 Coexistence Tables |
| 25 | 812 | F42A011 | CA | 43 | 1 | Campaigns | Master Files | 42: Sales Management | No |
| 26 | 812 | F42A012 | OP | 43 | 3 | Opportunity | Master Files | 42: Sales Management | No |
| 27 | 812 | F42CSS | CS | 18 | 1 | Customer Self Service Workfile | Work Files | 42B: Sales Order Entry | No |
| 28 | 812 | F42UI005 | SC | 54 | 2 | Sales Commission File | Extra Features Files | 42: Sales Management | Business Data |
| 29 | 812 | F42UI01 | ZH | 172 | 3 | SO Header Cache File (MBF) | Regular Work Files | 42B: Sales Order Entry | No |
| 30 | 812 | F42UI11 | ZD | 187 | 4 | SO Detail Cache File (MBF) | Regular Work Files | 42B: Sales Order Entry | No |
| 31 | 812 | F42UI11C | SC | 12 | 1 | Customer Self Service Shopping Cart Workfile | Regular Work Files | 42B: Sales Order Entry | No |
| 32 | 812 | F42UI12 | ZD | 130 | 3 | Sales Order Detail Cache 2 (MBF) | Regular Work Files | 42B: Sales Order Entry | No |
| 33 | 812 | F42UI130 | ZC | 62 | 2 | Commitment Work File | Regular Work Files | 42: Sales Management | No |
| 34 | 812 | F42UI150 | ZH | 8 | 1 | Sales Order Header Commission Information Work File | Work Files | 42: Sales Management | |
| 35 | 812 | F42UI160 | ZD | 9 | 1 | Sales Order Detail Commission Information Work File | Work Files | 42: Sales Management | |
| 36 | 812 | F42UI520 | S8 | 53 | 2 | Pick Slips Header File | Work Files | 42: Sales Management | No |
| 37 | 812 | F42UI521 | S9 | 136 | 3 | Pick Slips Detail File | Work Files | 42: Sales Management | No |
| 38 | 812 | F42UI800 | SD | 116 | 3 | Sales Detail Work File - Sales Update | Regular Work Files | 42: Sales Management | No |
| 39 | 812 | F47027T | UZ | 50 | 1 | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | Files | 42: Sales Management | Business Data |
| 40 | 812 | F470371T | UZ | 105 | 2 | Tag for F470371- EDI shipping Notice Detail - Outbound | Files | 42: Sales Management | Business Data |
| 41 | 812 | F47047T | UZ | 50 | 1 | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | Files | 42: Sales Management | Business Data |
| 42 | 812 | F47107T | UZ | 50 | 1 | Tag for F47107- EDI Response to RFQ Detail - Outbound | Files | 42: Sales Management | Business Data |
| 43 | 812 | F47147T | UZ | 50 | 1 | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | Files | 42: Sales Management | Business Data |
