40: Inventory/OP Base |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F40314R | PJ | 26 | 2 | Preference Resolution Ledger - Price Adjustment Schedule | Extra Features Files | 42B: Sales Order Entry | No |
Number | Description |
---|
1 | UniqueKeyID (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | UKID | Unique Key ID (Internal) | Ascending |
|
2 | AddressNumberEtc |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | CS14 | Customer Group - Price Adjustment Sched. | Ascending | 3 | ITM | Item Number - Short | Ascending | 4 | IT14 | Item Group - Price Adjustment Schedule | Ascending | 5 | EXDJ | Date - Expired | Ascending | 6 | MXQ | Quantity - Thru | Ascending | 7 | UOM | Unit of Measure as Input | Ascending | 8 | ASN | Price and Adjustment Schedule | Ascending | 9 | UPMJ | Date - Updated | Ascending | 10 | TDAY | Time of Day | Ascending |
|