| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0010 | Company Constants | 5 | CC | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
2 | F0010Z | Company Constants Z File | 18 | SZ | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
TOP07: Payroll |
3 | F06900 | Payroll Fiscal Patterns | 3 | Y$ | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
TOP09: General Accounting |
4 | F09UI004 | Variable Numerator Allocations work file | 17 | R# | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
TOP39: Advanced Stock Valuation |
5 | F39061 | Valuation Period Table | 4 | SO | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
6 | F390619 | Historical Valuation Period Detail Table | 4 | SO | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
7 | F39062 | Valuation Layers Table | 4 | ST | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
8 | F39063 | Period Additional Quantity Table | 3 | SU | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
9 | F390639 | Historical Additional Quantity Table | 3 | SU | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
10 | F39064 | Valuation Document Summary Table | 3 | DS | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
11 | F390649 | Historical Valuation Document Summary Table | 3 | DS | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
12 | F39120 | Temporary Period Build File for Stock Valuation | 15 | TF | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
13 | F39120W | Period Detail Work File | 11 | TW | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |
TOP40: Inventory/OP Base |
14 | F41001 | Inventory Constants | 42 | CI | PNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 |