| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TAPOL | Automatic Allocation of Materials to LIFO Pools | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
2 | TSPOL | Text Descriptions for LIFO Pools | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
TOPBalance Sheet Valuation Procedures |
3 | MYML | LIFO Material Layer (Annual) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
4 | MYML1 | LIFO: Transaction-Related Material Layer | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
5 | MYML1Q | LIFO: Transaction-Related Material Layer (Quantity) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
6 | MYML1V | LIFO: Transaction-Related Material Layer (Values) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
7 | MYMLM | LIFO Material Layer (Monthly) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
8 | MYMP | LIFO Period Stocks, Individual Material | 2 | MYKEY | Valuation level for receipts relevant to LIFO/FIFO | nvarchar | 4 | 0 | | |
9 | MYMP1 | Receipt Data LFIO/FIFO Valuation | 2 | MYKEY | Valuation level for receipts relevant to LIFO/FIFO | nvarchar | 4 | 0 | | |
10 | MYMP1R | Storage for Invoice Differences (LIFO/FIFO) | 2 | MYKEY | Valuation level for receipts relevant to LIFO/FIFO | nvarchar | 4 | 0 | | |
11 | MYPL | LIFO Pool Layer (Annual) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
12 | MYPLM | LIFO Pool Layer (Monthly) | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
13 | MYPS1 | Rules for Pool Splitting Method for LIFO Valuation | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
14 | MYPS2 | Rules for Pool Splitting Method for LIFO Valuation | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
15 | MYPS3 | Rule Type for Reassignment of Material Layers | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
16 | T001Y | Valuation Levels for LIFO Inventory Valuation | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
17 | TMY05 | Directory for Versions for LIFO Valuation | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
18 | TPOOL | Master Record, LIFO Pools | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
19 | TSVER | Text Descriptions for LIFO Layer Versions | 3 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
TOPBusiness Application Support |
20 | CNV_10994_T001Y | Valuation levels for LIFO stock valuation (before conv.) | 3 | MYKEY | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
TOPMaterial Master |
21 | MVMS | LIFO relevant materials material versions | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |
22 | MYMS | LIFO-relevant materials | 2 | MYKEY | LIFO valuation level | nvarchar | 4 | 0 | | |