| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F00693 | Cost Center Supplemental Data Text | 5 | M3 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP01: Address Book |
2 | F01093 | Supplemental Database - Narrative | 6 | A3 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP02: Electronic Mail |
3 | F01132 | PPAT Message Text File | 2 | CY | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP03B: Enhanced Accounts Receivable |
4 | F007111 | Text Processor Detail Table | 3 | TB | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP05A: OW HR & PR Foundation |
5 | F08397 | Key Employee Detail | 3 | HY | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP08: Human Resources |
6 | F08093 | Human Resources General Description - Narration | 8 | JY | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
7 | F089921 | Rules Detail | 2 | DT | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP08B: Benefits Administration |
8 | F083201 | Plan Master Text | 2 | B1 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
9 | F08390 | Eligibility | 3 | B9 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
10 | F08593 | Retirement Rule Definition | 3 | H7 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP08U: OW HR US |
11 | F08366 | NDT - Key Employee Detail | 5 | HY | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP09: General Accounting |
12 | F0917 | Bank Statement Detail | 6 | GD | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
13 | F09617 | Auto Bank Statement Detail | 5 | GM | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
14 | F09UI618 | Auto Bank Statement Process Work Table | 4 | NB | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP09E: Expense Reimbursment |
15 | F20112 | Expense Report Detail | 5 | ED | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP10: Financial Reporting |
16 | F10520 | Statement of Cash Flow Rules | 2 | CF | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
17 | F10UI520 | Cash Flow Statement Worktable | 2 | CW | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP15: Property Management |
18 | F1540 | Sales Report Control File | 8 | NR | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
19 | F1540B | Sales Report Control | 8 | NR | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP40: Inventory/OP Base |
20 | F40UI002 | Supplier History Rebuild -workfile | 18 | UT | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP43: Procurement |
21 | F43121Z | Receiver workfile | 84 | PW | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP47: Electronic Commerce |
22 | F4716 | EDI Item Text - Inbound/Outbound | 18 | SZ | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP48S: Service Billing |
23 | F48051 | Invoice Sequence/Summarization Table Detail | 4 | WK | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP52: Contract Billing |
24 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 6 | G5 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
25 | F5213 | Fee Billing Line Cross Reference Details | 6 | G3 | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP76B: Brazil - Reporting System Only |
26 | F76121B | Nota Fiscal Print Message Header - Brazil - 42 | 5 | FZ | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
27 | F7612B | Nota Fiscal Print Message - BRA - 42 | 6 | FY | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOP89: Conversion Programs |
28 | F0917S | Needed for upgrade for XE and below | 4 | GD | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |
TOPH79: CS - Forecasting |
29 | F99301 | Interleaf Processing Option Download Work File | 4 | PO | LIN | Line Number - General | Numeric | Generic Edit | 7 | 2 |