| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0018 | Sales/Use/V.A.T. Tax File | 54 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
2 | F0087 | Conversion Constants File for Euro | 5 | EU | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
3 | F0911 | Account Ledger | 28 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP03: Accounts Receivable |
4 | F0311 | Accounts Receivable Ledger | 33 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
5 | F0312 | A/R Batch Cash Application | 30 | RU | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP03B: Enhanced Accounts Receivable |
6 | F03B11 | Customer Ledger | 34 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
7 | F03B112 | Invoice Revisions | 36 | RW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
8 | F03B112P | Invoice Revisions Purge File | 36 | RW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
9 | F03B11P | Customer Ledger Purge File | 34 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
10 | F03B11Z1 | Invoice Transactions - Batch File | 51 | VJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
11 | F03B11Z2 | F03B11 Interoperability Table | 47 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
12 | F03B13 | Receipts Header File | 27 | RY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
13 | F03B13P | Receipts Header Purge File | 27 | RY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
14 | F03B13Z1 | Electronic Receipts Input | 36 | RU | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
15 | F03B13Z2 | F03B13 Interoperability Table | 40 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
16 | F03B14 | A/R Check Detail File | 34 | RZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
17 | F03B14P | Receipts Detail Purge File | 34 | RZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
18 | F03B14Z2 | F03B14 Interoperability Table | 47 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
19 | F03B22 | A/R Fee Journal History | 15 | RS | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
20 | F03B23 | A/R Fee Journal History Detail | 15 | RT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
21 | F03B465 | A/R Netting Workfile | 26 | RO | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
22 | F03B575 | Auto Debit Invoice Select and Build | 37 | RD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
23 | F03B672 | Draft Remittance Work File - One World Only | 30 | RD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
24 | F09UI011 | Receipt Prepost Work File | 21 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP04: Accounts Payable |
25 | F0411 | Accounts Payable Ledger | 35 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
26 | F0411A | WF - As Of - Accounts Payable Ledger | 35 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
27 | F0411P | Purge - Accounts Payable Ledger | 35 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
28 | F0411Z1 | Voucher Transactions - Batch File | 53 | VL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
29 | F0411Z3 | F0411 Interoperability Table | 58 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
30 | F0414 | Accounts Payable Matching Document Detail | 17 | RN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
31 | F0414A | WF - As Of - Accounts Payable Payment Detail | 17 | RN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
32 | F0414P | Purge - Accounts Payable Matching Document Detail | 17 | RN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
33 | F0414Z1 | F0414 Interoperability Table | 30 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
34 | F04572 | A/P Payment Processing - Summary File | 46 | KK | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
35 | F04573 | A/P Payment Processing - Detail File | 14 | KI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
36 | F09UI005 | Tax Offsets User Index | 27 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
37 | F09UI006 | Tax (F0018) Replica | 54 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP05: Time Accounting and HRM Base |
38 | F0618 | Employee Transaction History | 113 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP05T: Time Entry |
39 | F06116 | Employee Transaction Detail File | 164 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
40 | F06116Z1 | Employee Transactions - Batch File | 177 | VL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
41 | F063951 | Payroll Journal (Compressed) File | 31 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
42 | F0618TA | Temp table for F0618T for conversion | 8 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP07: Payroll |
43 | F05290 | WF - Payroll Journal (Detail) | 31 | JR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
44 | F0716702 | Employee Assignment Rates | 10 | EA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP09: General Accounting |
45 | F0911P | Purge - Account Ledger | 28 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
46 | F0911Z1 | Journal Entry Transactions - Batch File | 45 | VN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
47 | F0911Z4 | F0911 Interoperability Table | 50 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
48 | F09UI015 | Indexed Computations Multi-Tiered Entries | 28 | GL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP09E: Expense Reimbursment |
49 | F09E150 | Credit Card Transaction Interface Table | 17 | CI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
50 | F20112 | Expense Report Detail | 53 | ED | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP11: Multi Currency |
51 | F0015 | Currency Exchange Rates | 9 | CX | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
52 | F0015Z1 | External Currency Exchange Rates | 31 | ZE | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
53 | F1113 | Currency Restatement Rates File | 5 | C1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
54 | F1114 | Company Conversions Parameter File | 15 | C2 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP15: Property Management |
55 | F15012B | Tenant E.P. Class Master | 88 | NS | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
56 | F15013B | Sales Overage Master File | 87 | NO | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
57 | F15014B | Product Scales Master | 51 | NP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
58 | F15015B | Min/Max Rents And Recoveries Master | 52 | NQ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
59 | F15016B | Tenant Escalation Master | 82 | NU | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
60 | F15017 | Lease Master Detail File | 55 | NW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
61 | F1501B | Lease Master Header File | 58 | NE | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
62 | F1502B | Recurring Billings Master | 82 | NF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
63 | F1502WB | Estimated EP Recurring Billing Work File (OneWorld) | 46 | N4 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
64 | F1511 | Tenant/Lease Billings Detail | 44 | NJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
65 | F1511B | Tenant/Lease Billings Detail Master | 44 | NJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
66 | F1511H | Tenant/Lease Billings Detail History | 44 | N# | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
67 | F1511HB | Tenant/Lease Billings Detail History | 44 | NC | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
68 | F1513B | FASB 13 Lease Control File | 69 | O3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
69 | F151991 | G/L Transaction A/R Application Work File | 18 | NB | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
70 | F1538B | EP Billing Register Work File | 118 | NZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
71 | F1540B | Sales Report Control File | 49 | NR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
72 | F15410 | Tenant Weekly Sales File | 39 | N9 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
73 | F1541B | Tenant Sales History File | 49 | N8 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
74 | F1541BW | Sales History Work File | 61 | OW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
75 | F1542 | Projected Sales | 44 | OJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
76 | F1543B | Tenant Sales Analysis Reporting File | 77 | OA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
77 | F1548B | Escalation Billing Register | 71 | N1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
78 | F1565 | Security Deposit Master | 27 | JF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP15L: Adv Real Estate Forecasting |
79 | F15L301 | AREF Projected Sales | 47 | PS | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP17: Customer Service Management |
80 | F1720 | Contract Header | 47 | CH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
81 | F1721 | Contract Detail | 108 | CD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
82 | F1775 | Claim Temporary Table | 34 | TC | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
83 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 106 | WQ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP17C: Call Management |
84 | F1755 | Customer Call Master | 175 | ZA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
85 | F1760 | Time Entry | 89 | ZB | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP18: Resource Scheduling |
86 | F186602 | Labor Rules Tag File | 170 | TF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP31P: Engineer To Order |
87 | F31P10 | Project Quote Header | 9 | PQ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP39: Advanced Stock Valuation |
88 | F39062 | Valuation Layers Table | 21 | ST | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP40: Inventory/OP Base |
89 | F4001Z | Batch Receiver File - Order Headings | 96 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
90 | F4011Z | Batch Receiver File - Order Details | 208 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
91 | F4201Z1 | Sales Order Header Unedited Transaction File | 85 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
92 | F4207 | Price by Item | 30 | PM | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
93 | F4211Z1 | Sales Order Detail Unedited Transaction File | 187 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
94 | F43800 | Summary Voucher Match | 19 | PR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
95 | F49211 | Sales Order Detail File - Tag File | 59 | UD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
96 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 72 | S1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
97 | F49219 | Sales Order Detail - Tag History File | 59 | UD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP41: Inventory Management |
98 | F4118 | Container Deposit File | 19 | CN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
99 | F41181 | Container Transaction File | 27 | CM | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
100 | F41291Z | Landed Cost Cache Table | 21 | IG | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP42: Sales Management |
101 | F4201 | Sales Order Header File | 72 | SH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
102 | F42019 | Sales Order Header History File | 72 | SH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
103 | F4211 | Sales Order Detail File | 174 | SD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
104 | F42119 | Sales Order History File | 174 | SD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
105 | F42199 | S.O. Detail Ledger File | 174 | SL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
106 | F42565 | Invoice Print File | 88 | IW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
107 | F42800G | Sales Update G Batch Workfile | 20 | SG | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
108 | F42800G1 | Sales Update G Batch Detail Workfile | 55 | DG | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
109 | F42UI01 | SO Header Cache File (MBF) | 77 | ZH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
110 | F42UI11 | SO Detail Cache File (MBF) | 109 | ZD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
111 | F42UI520 | Pick Slips Header File | 27 | S8 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
112 | F42UI521 | Pick Slips Detail File | 118 | S9 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
113 | F42UI800 | Sales Detail Work File - Sales Update | 15 | SD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP42B: Sales Order Entry |
114 | F49299 | S.O. Detail Tag Ledger File | 59 | UD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP43: Procurement |
115 | F4301 | Purchase Order Header | 69 | PH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
116 | F4301Z | PO Header Work File | 73 | PA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
117 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 82 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
118 | F43080 | Approvals Fields Constants | 167 | PD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
119 | F4311 | Purchase Order Detail File | 167 | PD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
120 | F4311Z | Purchase Order Generator File | 171 | PW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
121 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 180 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
122 | F43121 | Purchase Order Receiver File | 87 | PR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
123 | F43121Z | Receiver workfile | 60 | PW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
124 | F43121Z1 | Receipts Unedited Transaction Table | 104 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
125 | F4314Z | Voucher Match Selection File | 187 | PN | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
126 | F43199 | P.O. Detail Ledger File - Flexible Version | 167 | OL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
127 | F4343 | Purchase Rebate History | 20 | RH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
128 | F4371 | Suggested Reorder Stock Items | 8 | PD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
129 | F43UI50H | PO Print Header Work File | 32 | PA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP43E: Requisition Self Service |
130 | F43E11 | Requisition Detail | 22 | RD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP43Q: Strategic Sourcing |
131 | F43Q15 | Event Currencies | 6 | EC | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
132 | F43Q40 | Response Header | 11 | RA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP44H: Homebuilder Management |
133 | F44H601 | Bid Header | 43 | BH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
134 | F44H611 | Bid Details | 69 | BD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
135 | F44H611W | Bid Details Work File | 73 | BW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
136 | F44H711 | Lot Start Workfile | 84 | SW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
137 | F44H711Z | HB Lot Start Unedited Transaction File | 97 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
138 | F44H71W1 | Lot Start Generation Workfile | 84 | GW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
139 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 54 | CG | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP45: Advanced Pricing |
140 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 154 | Z1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP47: Electronic Commerce |
141 | F47011 | EDI Purchase Order Header - Inbound | 83 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
142 | F47012 | EDI Purchase Order Detail - Inbound | 209 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
143 | F47016 | EDI Purchase Order Header - Outbound | 84 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
144 | F47017 | EDI Purchase Order Detail - Outbound | 170 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
145 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 84 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
146 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 170 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
147 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 79 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
148 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 209 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
149 | F47031 | EDI Shipping Notice Header - Inbound | 79 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
150 | F47032 | EDI Shipping Notice Detail - Inbound | 110 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
151 | F47037 | EDI Shipping Notice Detail - Outbound | 158 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
152 | F470371 | EDI Shipping Notice Detail - Outbound | 177 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
153 | F47041 | EDI Invoice Header - Inbound | 33 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
154 | F47042 | EDI Invoice Detail - Inbound | 70 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
155 | F47044 | EDI Invoice Summary - Inbound | 36 | SW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
156 | F47046 | EDI Invoice Header (Sales) - Outbound | 79 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
157 | F47047 | EDI Invoice Detail (Sales) - Outbound | 209 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
158 | F47056 | EDI Payment Order Header - Outbound | 32 | D1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
159 | F47056W | EDI Payment Order Header - Work | 32 | D1 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
160 | F47057 | EDI Payment Order Remittance Advice - Outbound | 32 | D3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
161 | F47057W | EDI Payment Order Remittance Advice - Work | 32 | D3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
162 | F47071 | EDI Receiving Advice Header - Inbound | 85 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
163 | F47072 | EDI Receiving Advice Detail - Inbound | 171 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
164 | F47076 | EDI Receiving Advice Header - Outbound | 85 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
165 | F47077 | EDI Receiving Advice Detail - Outbound | 171 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
166 | F47081 | EDI Price Sales Catalog Header - Inbound | 31 | FV | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
167 | F47091 | EDI Request for Quote Header - Inbound | 83 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
168 | F47092 | EDI Request for Quote Detail - Inbound | 209 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
169 | F47096 | EDI Request for Quote Header - Outbound | 84 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
170 | F47097 | EDI Request for Quote Detail - Outbound | 170 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
171 | F47101 | EDI Response to RFQ Header - Inbound | 84 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
172 | F47102 | EDI Response to RFQ Detail - Inbound | 170 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
173 | F47106 | EDI Response to RFQ Header - Outbound | 79 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
174 | F47107 | EDI Response to RFQ Detail - Outbound | 208 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
175 | F47113 | EDI Lockbox/Payment Detail - Batch | 24 | Z3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
176 | F47122 | EDI Product Activity Data Detail - Inbound | 66 | MJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
177 | F47127 | EDI Product Activity Data Detail - Outbound | 66 | MJ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
178 | F47131 | EDI Purchase Order Change Header - Inbound | 80 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
179 | F47132 | EDI Purchase Order Change Detail - Inbound | 210 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
180 | F47136 | EDI Purchase Order Change Header - Outbound | 84 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
181 | F47137 | EDI Purchase Order Change Detail - Outbound | 171 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
182 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 85 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
183 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 172 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
184 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 80 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
185 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 211 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
186 | F47156 | EDI Shipping Schedule Header - Outbound | 88 | SY | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
187 | F47157 | EDI Shipping Schedule Detail - Outbound | 193 | SZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP48: Work Order Processing |
188 | F4801ST | Purge - Work Order Master Tag File | 93 | WA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
189 | F4801T | Work Order Master Tag File | 93 | WA | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
190 | F4817 | Service Order Extension | 55 | SR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP48S: Service Billing |
191 | F4812 | Billing Detail Workfile | 110 | WD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
192 | F4812H | Billing Workfile - History | 110 | WD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
193 | F4812HS | Billing Workfile History Purged Save | 110 | WD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
194 | F4822 | Invoice Summary Work File | 90 | W4 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
195 | F4823 | Voucher Summary | 62 | W0 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
196 | F48S0618 | Payroll Reclassification Workfile | 113 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
197 | F48S910 | Billing Detail Journal File | 44 | W2 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
198 | F48S911 | Compressed Journal File | 28 | W3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
199 | F48SUI01 | Billing Detail Print Workfile | 110 | WD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP52: Contract Billing |
200 | F5201 | Contract Master File | 69 | G4 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
201 | F5202 | Contract Billing Line Detail | 74 | G6 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP53: Change Management |
202 | F5301B | Change Request Master Table | 43 | DI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
203 | F5301BZ1 | Change Request Master Table Workfile | 47 | DI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
204 | F5311 | Change Request Details Table | 142 | DK | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
205 | F5311Z1 | Change Request Details Table Workfile | 147 | DK | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
206 | F5314 | Planned Change Order Master Table | 41 | D2 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
207 | F5315 | Change Order Master Table | 40 | D3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP74: EMEA Localization |
208 | F74093 | Workfile for Printing IVA Summary - Italy | 53 | HC | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
209 | F7430030 | Legal Document Header (Print Info) - COMM - 03B | 12 | PI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
210 | F74411 | Withholding Tax Detail File-Italy | 22 | RS | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
211 | F74412 | Customer / Supplier Balance Workfile (A/R and A/P) | 18 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
212 | F74900 | Foreign Receivables and Payables - EMEA | 41 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
213 | F74S55 | Expenses and Exchange Rate for Payments - Spain | 14 | Q5 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP74R: CIS |
214 | F74R0018 | Russian Tax File - 74R | 46 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP74U: United Kingdom Localizations |
215 | F74U0212 | Accounting Billing Profile - 15 | 10 | P8 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
216 | F74U0213 | Weekly Accounting Profile - 15 | 11 | PW | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
217 | F74U25BT | Interest Tag Table - 15 | 12 | PK | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP74W: Sweden - Reporting System Only |
218 | F74W203 | Debit Advice Invoice File - 74W | 7 | K3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
219 | F74W210 | A/P Automatic Payments Spot Rate - 74W | 5 | K5 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP75C: China - Reporting System Only |
220 | F75C001 | Chinese GUI cross reference file | 12 | CR | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP75T: Taiwan |
221 | F75T004 | GUI/VAT Transaction Header - 75T | 22 | TH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
222 | F75T0049 | GUI/VAT Transaction Header History - 75T | 22 | TH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
223 | F75T004P | GUI/VAT Transaction Header POS - 75T | 22 | TH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
224 | F75T004Z | GUI/VAT Transaction Header - Work - 75T | 20 | ZH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
225 | F75T005 | GUI/VAT Transaction Detail - 75T | 19 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
226 | F75T0059 | GUI/VAT Transaction Detail History - 75T | 19 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
227 | F75T005P | GUI/VAT Transaction Detail POS - 75T | 19 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
228 | F75T005Z | GUI/VAT Transaction Detail - Work - 75T | 25 | ZD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP76A: Argentina |
229 | F760473A | PCG Detail Information Tag File - ARG - 04 | 11 | E5 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
230 | F76A0209 | Header and Footer Invoice/ShipmentNote History WF - ARG - 76A | 52 | HF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
231 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 52 | HF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
232 | F76A0440 | Check details RG 1547 - ARG - 04 - 76A | 9 | CD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
233 | F76A21 | Credit Invoice Header - F76A21 - ARG - 3B - 76A | 13 | IH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
234 | F76A21P | Credit Invoice Header Purge - ARG - 03B - 76A | 13 | IH | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
235 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 8 | IE | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
236 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 18 | TF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
237 | F76AUI20 | Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00 | 52 | HF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
238 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 17 | WF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
239 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 38 | WF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
240 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 24 | WF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
241 | F76AUI89 | Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A | 17 | WF | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP76B: Brazil - Reporting System Only |
242 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 19 | W3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP76C: Colombia |
243 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 33 | RP | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
244 | F76C034A | A/R Check Detail file As Of - COL - 76C | 39 | RZ | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP76H: Chile |
245 | F76H218 | Taxes by Sales Order Line - CHI - 42 - 76H | 26 | TD | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
246 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 35 | PI | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP76P: Peru |
247 | F76P473T | F04573 Tag File - PER - 04 - 76P | 11 | K3 | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
TOP89: Conversion Programs |
248 | F0086 | Conversion Audit File for Euro Conversion | 6 | AU | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
249 | F06116T | Needed for upgrade from Xe to B9 | 11 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
250 | F06116TZ | Needed for upgrade from Xe to B9 | 12 | VL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
251 | F0618T | Needed for upgrade from Xe to B9 | 11 | YT | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |
252 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 167 | OL | CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 |