| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0902 | Account Balances | 8 | GB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP09: General Accounting |
2 | F0902B | Account Balances - 52 Period Accounting | 8 | GB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
3 | F0902P | Purge - Account Balances | 8 | GB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
4 | F0902Z1 | Account Balances - Batch File | 11 | GB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
5 | F09UI004 | Variable Numerator Allocations work file | 18 | R# | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP10: Financial Reporting |
6 | F1002 | Multi-Site Consolidation Transfer File | 15 | GQ | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
7 | F1002Z1 | Unedited MSC Interoperability Table | 24 | SZ | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
8 | F10UI006 | MSC - F1002 Elimination Work File | 19 | GE | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP12: Fixed Assets |
9 | F1202 | Asset Account Balances File | 8 | FL | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
10 | F1202P | Asset Account Balances Purge Table | 8 | FL | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP15L: Adv Real Estate Forecasting |
11 | F15L109 | AREF Budget Results | 8 | BR | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP16: Profit Management (EPS) |
12 | F1602 | Cost Analyzer Balances | 18 | CB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
13 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 40 | CZ | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP43: Procurement |
14 | F40910 | Commitment Integrity Report Work File | 9 | P# | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP74R: CIS |
15 | F74R9002 | Correspondence Balance - RUS- 09 - 74R | 9 | GB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP75C: China - Reporting System Only |
16 | F75C014 | AP/AR Balances - China | 7 | BA | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
17 | F75C902 | Subsidiary Balances File - China | 38 | SB | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |
TOP76B: Brazil - Reporting System Only |
18 | F76B8200 | IN86-Work Table for Fixed Assets - 12 | 22 | FA | APYC | Amount - Beginning Balance/PYE Forward | Numeric | Generic Edit | 15 | 2 |