JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

616 columns | Print definition?920 | CRCD

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0010Company Constants25CCCRCDCurrency Code - FromStringGeneric Edit30
2F0010ZCompany Constants Z File38SZCRCDCurrency Code - FromStringGeneric Edit30
3F0013Currency Codes1CVCRCDCurrency Code - FromStringGeneric Edit30
4F0018Taxes53TDCRCDCurrency Code - FromStringGeneric Edit30
5F0030Bank Transit Master9AYCRCDCurrency Code - FromStringGeneric Edit30
6F004201Prepayment Transaction Table40PTCRCDCurrency Code - FromStringGeneric Edit30
7F0902Account Balances40GBCRCDCurrency Code - FromStringGeneric Edit30
8F0911Account Ledger27GLCRCDCurrency Code - FromStringGeneric Edit30
9F09190Inter/Intra Company Account Relationships4C9CRCDCurrency Code - FromStringGeneric Edit30
TOP03: Accounts Receivable
10F03012Customer Master by Line of Business10AICRCDCurrency Code - FromStringGeneric Edit30
11F03012Z1Customer Master LOB-Batch Table23VOCRCDCurrency Code - FromStringGeneric Edit30
12F0311Accounts Receivable Ledger32RPCRCDCurrency Code - FromStringGeneric Edit30
13F0312A/R Batch Cash Application29RUCRCDCurrency Code - FromStringGeneric Edit30
TOP03B: Enhanced Accounts Receivable
14F03B11Customer Ledger33RPCRCDCurrency Code - FromStringGeneric Edit30
15F03B112Invoice Revisions37RWCRCDCurrency Code - FromStringGeneric Edit30
16F03B112PInvoice Revisions Purge File37RWCRCDCurrency Code - FromStringGeneric Edit30
17F03B116Revenue Recognition Invoice2RKCRCDCurrency Code - FromStringGeneric Edit30
18F03B117Revenue Recognition GL Info60RLCRCDCurrency Code - FromStringGeneric Edit30
19F03B118Revenue Recognition Invoice Audit2RMCRCDCurrency Code - FromStringGeneric Edit30
20F03B119Revenue Recognition GL Info Audit59RNCRCDCurrency Code - FromStringGeneric Edit30
21F03B11PCustomer Ledger Purge File33RPCRCDCurrency Code - FromStringGeneric Edit30
22F03B11SWCustomer Ledger Summary Work Table5CSCRCDCurrency Code - FromStringGeneric Edit30
23F03B11Z1Batch Invoices50VJCRCDCurrency Code - FromStringGeneric Edit30
24F03B11Z2F03B11 Interoperability Table46SYCRCDCurrency Code - FromStringGeneric Edit30
25F03B13Receipts Header26RYCRCDCurrency Code - FromStringGeneric Edit30
26F03B13PReceipts Header Purge File26RYCRCDCurrency Code - FromStringGeneric Edit30
27F03B13Z1Electronic Receipts Input35RUCRCDCurrency Code - FromStringGeneric Edit30
28F03B13Z2F03B13 Interoperability Table39SYCRCDCurrency Code - FromStringGeneric Edit30
29F03B14Receipts Detail33RZCRCDCurrency Code - FromStringGeneric Edit30
30F03B14PReceipts Detail Purge File33RZCRCDCurrency Code - FromStringGeneric Edit30
31F03B14Z2F03B14 Interoperability Table46SZCRCDCurrency Code - FromStringGeneric Edit30
32F03B15Credit and Cash Management36RTCRCDCurrency Code - FromStringGeneric Edit30
33F03B16A/R Statistical History43RVCRCDCurrency Code - FromStringGeneric Edit30
34F03B16SA/R Statistical Summary40RSCRCDCurrency Code - FromStringGeneric Edit30
35F03B20A/R Notification History33ZRCRCDCurrency Code - FromStringGeneric Edit30
36F03B21A/R Notification History Detail18ZSCRCDCurrency Code - FromStringGeneric Edit30
37F03B22A/R Fee Journal History14RSCRCDCurrency Code - FromStringGeneric Edit30
38F03B23A/R Fee Journal History Detail13RTCRCDCurrency Code - FromStringGeneric Edit30
39F03B26A/R Delinquency Policy Notification12RLCRCDCurrency Code - FromStringGeneric Edit30
40F03B27A/R Delinquency Policy Detail - Fees17RMCRCDCurrency Code - FromStringGeneric Edit30
41F03B29Credit Insurance7IPCRCDCurrency Code - FromStringGeneric Edit30
42F03B40A/R Deduction Management27RBCRCDCurrency Code - FromStringGeneric Edit30
43F03B41A/R Deduction Activity12RCCRCDCurrency Code - FromStringGeneric Edit30
44F03B465A/R Netting Workfile30ROCRCDCurrency Code - FromStringGeneric Edit30
45F03B571Auto Debit Batch Control14RCCRCDCurrency Code - FromStringGeneric Edit30
46F03B575Auto Debit Invoice Select and Build36RDCRCDCurrency Code - FromStringGeneric Edit30
47F03B672Draft Remittance29RDCRCDCurrency Code - FromStringGeneric Edit30
48F03BUI04Work File for Integrity by Offset Account8W3CRCDCurrency Code - FromStringGeneric Edit30
49F09UI011Receipt Prepost Work File20GLCRCDCurrency Code - FromStringGeneric Edit30
TOP04: Accounts Payable
50F0411Accounts Payable Ledger34RPCRCDCurrency Code - FromStringGeneric Edit30
51F0411AWF - 'As Of' Accounts Payable Ledger34RPCRCDCurrency Code - FromStringGeneric Edit30
52F0411PPurge - Accounts Payable Ledger34RPCRCDCurrency Code - FromStringGeneric Edit30
53F0411SWSupplier Ledger Summary Work Table5SSCRCDCurrency Code - FromStringGeneric Edit30
54F0411Z1Voucher Transactions - Batch Upload52VLCRCDCurrency Code - FromStringGeneric Edit30
55F0411Z3F0411 Interoperability Table56SZCRCDCurrency Code - FromStringGeneric Edit30
56F0413Accounts Payable - Matching Document12RMCRCDCurrency Code - FromStringGeneric Edit30
57F0413AWF - 'As Of' Accounts Payable Payment Register12RMCRCDCurrency Code - FromStringGeneric Edit30
58F0413PPurge - Accounts Payable Matching Documents12RMCRCDCurrency Code - FromStringGeneric Edit30
59F0413Z1F0413 Interoperability Table26SYCRCDCurrency Code - FromStringGeneric Edit30
60F0414Accounts Payable Matching Document Detail16RNCRCDCurrency Code - FromStringGeneric Edit30
61F0414AWF - 'As Of' Accounts Payable Payment Detail16RNCRCDCurrency Code - FromStringGeneric Edit30
62F0414PPurge - Accounts Payable Matching Document Detail16RNCRCDCurrency Code - FromStringGeneric Edit30
63F0414Z1F0414 Interoperability Table29SZCRCDCurrency Code - FromStringGeneric Edit30
64F04571A/P Payment Processing - Header5KHCRCDCurrency Code - FromStringGeneric Edit30
65F04572A/P Payment Processing - Summary7KKCRCDCurrency Code - FromStringGeneric Edit30
66F04573A/P Payment Processing - Detail13KICRCDCurrency Code - FromStringGeneric Edit30
67F09UI005Tax Offsets User Index17GLCRCDCurrency Code - FromStringGeneric Edit30
68F09UI006Tax (F0018) Replica53TDCRCDCurrency Code - FromStringGeneric Edit30
TOP05: Time Accounting and HRM Base
69F0618Employee Transaction History114YTCRCDCurrency Code - FromStringGeneric Edit30
TOP05A: PeopleSoft HR & PR Foundation
70F060117Employee Master - International Data13YACRCDCurrency Code - FromStringGeneric Edit30
TOP05T: Time Entry
71F06116Employee Transaction Detail File165YTCRCDCurrency Code - FromStringGeneric Edit30
72F06116Z1Employee Transactions - Batch File178VLCRCDCurrency Code - FromStringGeneric Edit30
73F06116Z2ESS Timecard History178VMCRCDCurrency Code - FromStringGeneric Edit30
74F063951Payroll Journal (Compressed) File30GLCRCDCurrency Code - FromStringGeneric Edit30
TOP06: Payroll (old) - Obsolete-do not reuse
75F0618TATemp table for F0618T for conversion9YTCRCDCurrency Code - FromStringGeneric Edit30
TOP07: Payroll
76F05290WF - Payroll Journal (Detail)30JRCRCDCurrency Code - FromStringGeneric Edit30
77F0716701Employee Assignment T/E Template Information87EACRCDCurrency Code - FromStringGeneric Edit30
78F0716709Employee Assignment T/E Template Info History87EACRCDCurrency Code - FromStringGeneric Edit30
TOP09: General Accounting
79F0901Account Master12GMCRCDCurrency Code - FromStringGeneric Edit30
80F0902BAccount Balances - 52 Period Accounting80GBCRCDCurrency Code - FromStringGeneric Edit30
81F0902PPurge - Account Balances40GBCRCDCurrency Code - FromStringGeneric Edit30
82F0902Z1Account Balances - Batch File43GBCRCDCurrency Code - FromStringGeneric Edit30
83F0911PPurge - Account Ledger27GLCRCDCurrency Code - FromStringGeneric Edit30
84F0911RWF - Account Ledger Reconciliation27GLCRCDCurrency Code - FromStringGeneric Edit30
85F0911R1Account Reconciliations Header - OneWorld ONLY9GLCRCDCurrency Code - FromStringGeneric Edit30
86F0911SWAccount Ledger Summary Work Table5GSCRCDCurrency Code - FromStringGeneric Edit30
87F0911Z1Journal Entry Transactions - Batch File44VNCRCDCurrency Code - FromStringGeneric Edit30
88F0911Z4F0911 Interoperability Table49SZCRCDCurrency Code - FromStringGeneric Edit30
89F0917Bank Statement Detail11GDCRCDCurrency Code - FromStringGeneric Edit30
90F09617Auto Bank Statement Detail14GMCRCDCurrency Code - FromStringGeneric Edit30
91F097021WAccount Ledger to Account Master Work Table19TACRCDCurrency Code - FromStringGeneric Edit30
92F097031WAccount Balance to Account Master Work Table10ABCRCDCurrency Code - FromStringGeneric Edit30
93F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY16GLCRCDCurrency Code - FromStringGeneric Edit30
94F09UI009Trial Balance Generic Work File - OneWorld ONLY4GBCRCDCurrency Code - FromStringGeneric Edit30
95F09UI015Indexed Computations Multi-Tiered Entries27GLCRCDCurrency Code - FromStringGeneric Edit30
96F09UI016Account Balance Compare Exceptions10GWCRCDCurrency Code - FromStringGeneric Edit30
97F11151Currency Cross Rates Calculation Master1CECRCDCurrency Code - FromStringGeneric Edit30
98F48S85Burden Rates8RTCRCDCurrency Code - FromStringGeneric Edit30
99F52G02Burdening Summarized Ledger12BSCRCDCurrency Code - FromStringGeneric Edit30
100F52G11Burdening Detail Ledger20BDCRCDCurrency Code - FromStringGeneric Edit30
101F52G11WFTemporary Burdened Detail Ledger Workfile20BWCRCDCurrency Code - FromStringGeneric Edit30
102F70UI001Work File for G/L by Cat. Code Localization25WACRCDCurrency Code - FromStringGeneric Edit30
103F740911Work File for G/L Report by Category Code Localization28WACRCDCurrency Code - FromStringGeneric Edit30
TOP09E: Expense Reimbursment
104F20112Expense Report Detail16EDCRCDCurrency Code - FromStringGeneric Edit30
TOP10: Financial Reporting
105F1002Multi-Site Consolidation Transfer File13GQCRCDCurrency Code - FromStringGeneric Edit30
106F1002Z1Unedited MSC Interoperability Table22SZCRCDCurrency Code - FromStringGeneric Edit30
107F10UI006MSC - F1002 Elimination Work File12GECRCDCurrency Code - FromStringGeneric Edit30
TOP11: Multi Currency
108F0015Currency Exchange Rates1CXCRCDCurrency Code - FromStringGeneric Edit30
109F0015Z1External Currency Exchange Rates23ZECRCDCurrency Code - FromStringGeneric Edit30
110F1113Currency Restatement Rates File3C1CRCDCurrency Code - FromStringGeneric Edit30
TOP12: Fixed Assets
111F1202Asset Account Balances File46FLCRCDCurrency Code - FromStringGeneric Edit30
112F1202PAsset Account Balances Purge Table46FLCRCDCurrency Code - FromStringGeneric Edit30
113F12911ERPost G/L to FA Exceptions Work File15GLCRCDCurrency Code - FromStringGeneric Edit30
TOP13E: Equipment Cost Analysis
114F1383Equipment Analysis Costs23ECCRCDCurrency Code - FromStringGeneric Edit30
TOP15: Real Estate Management
115F15012Tenant E.P. Class Master50NSCRCDCurrency Code - FromStringGeneric Edit30
116F150122AShare Factor Denominator Audit24SACRCDCurrency Code - FromStringGeneric Edit30
117F15012BTenant E.P. Class Master57NSCRCDCurrency Code - FromStringGeneric Edit30
118F15013Sales Overage Master62NOCRCDCurrency Code - FromStringGeneric Edit30
119F15013BSales Overage Master File41NOCRCDCurrency Code - FromStringGeneric Edit30
120F15014BProduct Scales Master53NPCRCDCurrency Code - FromStringGeneric Edit30
121F15015BMin/Max Rents And Recoveries Master54NQCRCDCurrency Code - FromStringGeneric Edit30
122F15016Tenant Escalation Master48NUCRCDCurrency Code - FromStringGeneric Edit30
123F15016BTenant Escalation Master51NUCRCDCurrency Code - FromStringGeneric Edit30
124F15017Lease Master Detail56NWCRCDCurrency Code - FromStringGeneric Edit30
125F1501BLease Master Header60NECRCDCurrency Code - FromStringGeneric Edit30
126F1502Recurring Billings Master43NFCRCDCurrency Code - FromStringGeneric Edit30
127F1502BRecurring Billings Master43NFCRCDCurrency Code - FromStringGeneric Edit30
128F1502WABRent Increase Amounts21NFCRCDCurrency Code - FromStringGeneric Edit30
129F1502WBEstimated EP Recurring Billings45N4CRCDCurrency Code - FromStringGeneric Edit30
130F1505BManagement Fee Master59NDCRCDCurrency Code - FromStringGeneric Edit30
131F1505HBRevenue Fee Generation History19OKCRCDCurrency Code - FromStringGeneric Edit30
132F1511Tenant/Lease Billings Detail43NJCRCDCurrency Code - FromStringGeneric Edit30
133F15110BExpense Participation Class Account18OBCRCDCurrency Code - FromStringGeneric Edit30
134F1511BLease Billings Master43NJCRCDCurrency Code - FromStringGeneric Edit30
135F1511HTenant/Lease Billings Detail History43N#CRCDCurrency Code - FromStringGeneric Edit30
136F1511HBLease Billings History43NCCRCDCurrency Code - FromStringGeneric Edit30
137F1513BFASB 13 Lease Control67O3CRCDCurrency Code - FromStringGeneric Edit30
138F15151Building E.P. Caps13CDCRCDCurrency Code - FromStringGeneric Edit30
139F15152Lease E.P. Caps20LCCRCDCurrency Code - FromStringGeneric Edit30
140F15153Lease Cap History31LCCRCDCurrency Code - FromStringGeneric Edit30
141F151991G/L Transaction A/R Application Work File17NBCRCDCurrency Code - FromStringGeneric Edit30
142F15199WG/L Transaction Summarization Work File13NBCRCDCurrency Code - FromStringGeneric Edit30
143F1525BFees and Interest44NMCRCDCurrency Code - FromStringGeneric Edit30
144F15303E.P. Class Expenses History28CHCRCDCurrency Code - FromStringGeneric Edit30
145F1531Expense Participation Class Adjustment13OMCRCDCurrency Code - FromStringGeneric Edit30
146F1532BExpense Participation Audit File29NTCRCDCurrency Code - FromStringGeneric Edit30
147F1533BTenant Account Exclusions29NMCRCDCurrency Code - FromStringGeneric Edit30
148F1538WF - Expence Participation Register60NZCRCDCurrency Code - FromStringGeneric Edit30
149F1538BEP Billing Register62NZCRCDCurrency Code - FromStringGeneric Edit30
150F1538B1Occupancy Gross Up Audit24GUCRCDCurrency Code - FromStringGeneric Edit30
151F1538B2Exclusion/Redistribution15RDCRCDCurrency Code - FromStringGeneric Edit30
152F1539AEP Billing Account Adjustments Audit22AUCRCDCurrency Code - FromStringGeneric Edit30
153F1539CEP Billing Class Adjustments Audit File18AUCRCDCurrency Code - FromStringGeneric Edit30
154F1539EEP Billing Account Exclusions Audit23AUCRCDCurrency Code - FromStringGeneric Edit30
155F1539FCEP Billing Adj Factor EP Class Audit17AUCRCDCurrency Code - FromStringGeneric Edit30
156F1539FLEP Billing Adj Factor Lease Audit22AUCRCDCurrency Code - FromStringGeneric Edit30
157F1540BSales Report Control51NRCRCDCurrency Code - FromStringGeneric Edit30
158F15410Tenant Weekly Sales38N9CRCDCurrency Code - FromStringGeneric Edit30
159F1541BTenant Sales History48N8CRCDCurrency Code - FromStringGeneric Edit30
160F1541BWSales History Work File60OWCRCDCurrency Code - FromStringGeneric Edit30
161F1542Projected Sales41OJCRCDCurrency Code - FromStringGeneric Edit30
162F1543BTenant Sales Analysis Reporting File76OACRCDCurrency Code - FromStringGeneric Edit30
163F1544BSales Analysis Control48OBCRCDCurrency Code - FromStringGeneric Edit30
164F1548BEscalation Billing Register70N1CRCDCurrency Code - FromStringGeneric Edit30
165F15525WPM Statements Credit/Cash Build Workfile44RTCRCDCurrency Code - FromStringGeneric Edit30
166F1565Security Deposit Master25JFCRCDCurrency Code - FromStringGeneric Edit30
167F15703Legal Clause Amounts23NICRCDCurrency Code - FromStringGeneric Edit30
168F159071Market/Potential/Renewal Rent Master23NYCRCDCurrency Code - FromStringGeneric Edit30
TOP15L: Adv Real Estate Forecasting
169F15L301AREF Projected Sales44PSCRCDCurrency Code - FromStringGeneric Edit30
170F15L402AREF Tenant Exclusion Rule Audit6SGCRCDCurrency Code - FromStringGeneric Edit30
171F15L403AREF Gross Up Processing Audit25SHCRCDCurrency Code - FromStringGeneric Edit30
TOP16: Profit Management (EPS)
172F1602Cost Analyzer Balances55CBCRCDCurrency Code - FromStringGeneric Edit30
173F1602Z1External Cost Analyzer Balances - Interoperability Table77CZCRCDCurrency Code - FromStringGeneric Edit30
174F1630Driver Definitions9CDCRCDCurrency Code - FromStringGeneric Edit30
TOP17: Customer Service Management
175F1720Contract Header33CHCRCDCurrency Code - FromStringGeneric Edit30
176F1721Contract Detail109CDCRCDCurrency Code - FromStringGeneric Edit30
177F1775Claim Temporary Table11TCCRCDCurrency Code - FromStringGeneric Edit30
178F4801TZ2Warranty Claim/Supplier Recovery processing30WQCRCDCurrency Code - FromStringGeneric Edit30
TOP17C: Call Management
179F1755Case Master107ZACRCDCurrency Code - FromStringGeneric Edit30
180F1760Time Entry27ZBCRCDCurrency Code - FromStringGeneric Edit30
TOP18: Timecard Automation
181F186602Labor Rules Tag File171TFCRCDCurrency Code - FromStringGeneric Edit30
TOP31B: Blend Management
182F31B21Cost Groups Header3CGCRCDCurrency Code - FromStringGeneric Edit30
TOP31P: Engineer To Order
183F31P10Project Quote Header10PQCRCDCurrency Code - FromStringGeneric Edit30
TOP32: Configuration Management
184F3201Configurator Master Table14CMCRCDCurrency Code - FromStringGeneric Edit30
185F32019Configurator Master History Table14CHCRCDCurrency Code - FromStringGeneric Edit30
TOP38: Agreement Management
186F38011Agreement Quantities20DFCRCDCurrency Code - FromStringGeneric Edit30
187F38012Product Source/Destination Master13DPCRCDCurrency Code - FromStringGeneric Edit30
188F38014Agreement Formulas and Factors11DRCRCDCurrency Code - FromStringGeneric Edit30
189F38111Agreements Transaction Ledger52DZCRCDCurrency Code - FromStringGeneric Edit30
190F38112Agreements Committed Quantities14DXCRCDCurrency Code - FromStringGeneric Edit30
TOP39: Advanced Stock Valuation
191F39061Valuation Period Table1SOCRCDCurrency Code - FromStringGeneric Edit30
192F390619Historical Valuation Period Detail Table1SOCRCDCurrency Code - FromStringGeneric Edit30
193F39062Valuation Layers Table1STCRCDCurrency Code - FromStringGeneric Edit30
194F39063Period Additional Quantity Table1SUCRCDCurrency Code - FromStringGeneric Edit30
195F390639Historical Additional Quantity Table1SUCRCDCurrency Code - FromStringGeneric Edit30
196F39064Valuation Document Summary Table1DSCRCDCurrency Code - FromStringGeneric Edit30
197F390649Historical Valuation Document Summary Table1DSCRCDCurrency Code - FromStringGeneric Edit30
198F3908Item Pool Valuation Cost Master1CSCRCDCurrency Code - FromStringGeneric Edit30
199F3910G/L Adjustment Table1SCCRCDCurrency Code - FromStringGeneric Edit30
200F39120Temporary Period Build File for Stock Valuation5TFCRCDCurrency Code - FromStringGeneric Edit30
TOP40: Inventory/OP Base
201F4001ZBatch Receiver File - Order Headings95SYCRCDCurrency Code - FromStringGeneric Edit30
202F4011ZBatch Receiver File - Order Details207SZCRCDCurrency Code - FromStringGeneric Edit30
203F4011ZTXRecurring Order Detail Tax Table15ZTCRCDCurrency Code - FromStringGeneric Edit30
204F40332Preference Profile - Customer Freight16CFCRCDCurrency Code - FromStringGeneric Edit30
205F40345Preference Profile - Customer Currency14CRCRCDCurrency Code - FromStringGeneric Edit30
206F40345RPreference Resolution Ledger - Customer Currency16CRCRCDCurrency Code - FromStringGeneric Edit30
207F40P011Promotion Deal Detail File11PDCRCDCurrency Code - FromStringGeneric Edit30
208F40UI74Price Adjustment History Work File21AWCRCDCurrency Code - FromStringGeneric Edit30
209F4106Item Base Price File12BPCRCDCurrency Code - FromStringGeneric Edit30
210F4106NCBase Price Extraction17SZCRCDCurrency Code - FromStringGeneric Edit30
211F4201Z1Sales Order Header Unedited Transaction File84SYCRCDCurrency Code - FromStringGeneric Edit30
212F4207Price by Item29PMCRCDCurrency Code - FromStringGeneric Edit30
213F4211AUSales Order Detail Audit File11AUCRCDCurrency Code - FromStringGeneric Edit30
214F4211Z1Sales Order Detail Unedited Transaction File186SZCRCDCurrency Code - FromStringGeneric Edit30
215F43800Summary Voucher Match17PRCRCDCurrency Code - FromStringGeneric Edit30
216F49211Sales Order Detail File - Tag File60UDCRCDCurrency Code - FromStringGeneric Edit30
217F49211Z1Sales Order Detail Tag Unedited Transaction File73S1CRCDCurrency Code - FromStringGeneric Edit30
218F49219Sales Order Detail - Tag History File60UDCRCDCurrency Code - FromStringGeneric Edit30
TOP40G: Grower Management
219F40G02Grower Block64GBCRCDCurrency Code - FromStringGeneric Edit30
220F40G03Grower Harvest74GHCRCDCurrency Code - FromStringGeneric Edit30
221F40G032Harvest Estimate Freeze Detail21FDCRCDCurrency Code - FromStringGeneric Edit30
222F40G95Pay On Proceeds Log File17PPCRCDCurrency Code - FromStringGeneric Edit30
TOP40S: Supply Chain Self Service
223F4947SWSelf-Service Shipment Tracking Work File16SWCRCDCurrency Code - FromStringGeneric Edit30
TOP41: Inventory Management
224F41051Average Cost Work file8CHCRCDCurrency Code - FromStringGeneric Edit30
225F4118Container Deposit File18CNCRCDCurrency Code - FromStringGeneric Edit30
226F41181Container Transaction File26CMCRCDCurrency Code - FromStringGeneric Edit30
227F41291ZLanded Cost Cache Table22IGCRCDCurrency Code - FromStringGeneric Edit30
TOP41F: Apparel Management
228FCW11Item Base Price File Work File11WPCRCDCurrency Code - FromStringGeneric Edit30
229FCW33Price List Header9PHCRCDCurrency Code - FromStringGeneric Edit30
230FCW38Price List Exchange Rate1TRCRCDCurrency Code - FromStringGeneric Edit30
231FCW70Supplier Price/Catalog File - Header5CBCRCDCurrency Code - FromStringGeneric Edit30
232FCW71Supplier Price/Catalog File - Detail24CBCRCDCurrency Code - FromStringGeneric Edit30
233FCW84Exchange Rate for Outsource Operations1TRCRCDCurrency Code - FromStringGeneric Edit30
234FCW93Copy to Outsource Operations for Style Items12STCRCDCurrency Code - FromStringGeneric Edit30
TOP42: Sales Management
235F4074Price Adjustment Ledger File15ALCRCDCurrency Code - FromStringGeneric Edit30
236F4201Sales Order Header File71SHCRCDCurrency Code - FromStringGeneric Edit30
237F42019Sales Order Header History File71SHCRCDCurrency Code - FromStringGeneric Edit30
238F4211Sales Order Detail File173SDCRCDCurrency Code - FromStringGeneric Edit30
239F42119Sales Order History File173SDCRCDCurrency Code - FromStringGeneric Edit30
240F4211Z1TSales Order Detail Unedited Tax Transaction File16DZCRCDCurrency Code - FromStringGeneric Edit30
241F42199S.O. Detail Ledger File173SLCRCDCurrency Code - FromStringGeneric Edit30
242F42565Invoice Print File86IWCRCDCurrency Code - FromStringGeneric Edit30
243F42800GSales Update G Batch Workfile19SGCRCDCurrency Code - FromStringGeneric Edit30
244F42800G1Sales Update G Batch Detail Workfile54DGCRCDCurrency Code - FromStringGeneric Edit30
245F42A011Campaigns8CACRCDCurrency Code - FromStringGeneric Edit30
246F42A012Opportunity10OPCRCDCurrency Code - FromStringGeneric Edit30
247F42CSSCustomer Self Service Workfile18CSCRCDCurrency Code - FromStringGeneric Edit30
248F42UI01SO Header Cache File (MBF)76ZHCRCDCurrency Code - FromStringGeneric Edit30
249F42UI11SO Detail Cache File (MBF)108ZDCRCDCurrency Code - FromStringGeneric Edit30
250F42UI12Sales Order Detail Cache 2 (MBF)155ZDCRCDCurrency Code - FromStringGeneric Edit30
251F42UI520Pick Slips Header File29S8CRCDCurrency Code - FromStringGeneric Edit30
252F42UI521Pick Slips Detail File117S9CRCDCurrency Code - FromStringGeneric Edit30
253F42UI800Sales Detail Work File - Sales Update17SDCRCDCurrency Code - FromStringGeneric Edit30
TOP42B: Sales Order Entry
254F42119TXSales Order Detail History Tax Table17DTCRCDCurrency Code - FromStringGeneric Edit30
255F4211TXSales Order Detail Tax Table17DTCRCDCurrency Code - FromStringGeneric Edit30
256F42199TXSO Detail Ledger Tax Table17DTCRCDCurrency Code - FromStringGeneric Edit30
257F42420TXTax Audit Log Transaction9TACRCDCurrency Code - FromStringGeneric Edit30
258F49299S.O. Detail Tag Ledger File60UDCRCDCurrency Code - FromStringGeneric Edit30
TOP42I: Outbound Inventory Management
259F42I015Outbound Inventory Agreement Transaction File45OICRCDCurrency Code - FromStringGeneric Edit30
260F42I02Outbound Inventory Agreement Acknowledge40OICRCDCurrency Code - FromStringGeneric Edit30
261F42I03Outbound Order Consumption Report File37OICRCDCurrency Code - FromStringGeneric Edit30
262F42I07Outbound Inventory Agreement Details Change History21OQCRCDCurrency Code - FromStringGeneric Edit30
TOP42X: In-Memory Sales Advisor
263F42X010WLine Advisor Work File21USCRCDCurrency Code - FromStringGeneric Edit30
264F42X040WOrder Upsell Item Group Totals Work File8GRCRCDCurrency Code - FromStringGeneric Edit30
265F42X041WOrder Upsell Item Group Opportunities WF11BRCRCDCurrency Code - FromStringGeneric Edit30
266F42X050WOrder Level Upsell Candidate Items27CICRCDCurrency Code - FromStringGeneric Edit30
TOP43: Procurement
267F41061Supplier Price/Catalog File13CBCRCDCurrency Code - FromStringGeneric Edit30
268F4301Purchase Order Header68PHCRCDCurrency Code - FromStringGeneric Edit30
269F4301SWPurchase Order Summary Work Table4PSCRCDCurrency Code - FromStringGeneric Edit30
270F4301ZPO Header Work File72PACRCDCurrency Code - FromStringGeneric Edit30
271F4301Z1Purchase Order Header Unedited Transaction Table81SYCRCDCurrency Code - FromStringGeneric Edit30
272F43080Approvals Fields Constants166PDCRCDCurrency Code - FromStringGeneric Edit30
273F4311Purchase Order Detail File166PDCRCDCurrency Code - FromStringGeneric Edit30
274F4311TPurchase Order Detail Tag File10PDCRCDCurrency Code - FromStringGeneric Edit30
275F4311ZPurchase Order Generator File170PWCRCDCurrency Code - FromStringGeneric Edit30
276F4311Z1Purchase Order Detail Unedited Transaction Table179SZCRCDCurrency Code - FromStringGeneric Edit30
277F43121Purchase Order Receiver File86PRCRCDCurrency Code - FromStringGeneric Edit30
278F43121TPurchase Order Receiver Tag File17PRCRCDCurrency Code - FromStringGeneric Edit30
279F43121ZReceiver workfile74PWCRCDCurrency Code - FromStringGeneric Edit30
280F43121Z1Receipts Unedited Transaction Table103SZCRCDCurrency Code - FromStringGeneric Edit30
281F43147Freight Distribution Workfile31FDCRCDCurrency Code - FromStringGeneric Edit30
282F4314ZVoucher Match Selection File186PNCRCDCurrency Code - FromStringGeneric Edit30
283F4316Purchase Order Multiple Account File39P3CRCDCurrency Code - FromStringGeneric Edit30
284F4316TPurchase Order Multiple Account Tag File15P3CRCDCurrency Code - FromStringGeneric Edit30
285F4317Purchase Order Detail Non-Billable12PDCRCDCurrency Code - FromStringGeneric Edit30
286F43199P.O. Detail Ledger File - Flexible Version166OLCRCDCurrency Code - FromStringGeneric Edit30
287F4331Quantity Breaks File10P1CRCDCurrency Code - FromStringGeneric Edit30
288F4340Purchase Rebate Master File9RDCRCDCurrency Code - FromStringGeneric Edit30
289F4343Purchase Rebate History19RHCRCDCurrency Code - FromStringGeneric Edit30
290F43632ZOpen Purchase Order by Item Work File24OICRCDCurrency Code - FromStringGeneric Edit30
291F4371Suggested Reorder Stock Items6PDCRCDCurrency Code - FromStringGeneric Edit30
292F43UI50HPO Print Header Work File29PACRCDCurrency Code - FromStringGeneric Edit30
TOP43A: Purchase Order Receipt/Routing
293F43126Purchase Order Receiver Multiple Account38P4CRCDCurrency Code - FromStringGeneric Edit30
294F43126TPurchase Order Receiver Multiple Account Tag File19P4CRCDCurrency Code - FromStringGeneric Edit30
295F43127Purchase Order Receiver Non-Billable19PRCRCDCurrency Code - FromStringGeneric Edit30
TOP43E: Requisition Self Service
296F43E11Requisition Detail21RDCRCDCurrency Code - FromStringGeneric Edit30
297F43E16Requisition Multiple Account File31P3CRCDCurrency Code - FromStringGeneric Edit30
TOP43Q: Strategic Sourcing
298F43Q15Event Currencies5ECCRCDCurrency Code - FromStringGeneric Edit30
299F43Q40Response Header10RACRCDCurrency Code - FromStringGeneric Edit30
300F43Q401Response Header Question23RCCRCDCurrency Code - FromStringGeneric Edit30
301F43Q41Response Line19RBCRCDCurrency Code - FromStringGeneric Edit30
302F43Q411Response Detail Question26RECRCDCurrency Code - FromStringGeneric Edit30
303F43Q50Analyze Event Header10AVCRCDCurrency Code - FromStringGeneric Edit30
304F43Q51Analyze Event Detail16EDCRCDCurrency Code - FromStringGeneric Edit30
TOP43S: JSSS/Supplier Self Service
305F4313POFLIP19PFCRCDCurrency Code - FromStringGeneric Edit30
306F4323PO FLIP Header7PDCRCDCurrency Code - FromStringGeneric Edit30
TOP44H: Homebuilder Management
307F44H601Bid Header42BHCRCDCurrency Code - FromStringGeneric Edit30
308F44H611Bid Details68BDCRCDCurrency Code - FromStringGeneric Edit30
309F44H611WBid Details Work File72BWCRCDCurrency Code - FromStringGeneric Edit30
310F44H711Lot Start Workfile81SWCRCDCurrency Code - FromStringGeneric Edit30
311F44H711ZHB Lot Start Unedited Transaction File94SZCRCDCurrency Code - FromStringGeneric Edit30
312F44H71W1Lot Start Generation Workfile81GWCRCDCurrency Code - FromStringGeneric Edit30
313F44H73W1Lot Start - P.O. / Committment Generation Work File51CGCRCDCurrency Code - FromStringGeneric Edit30
TOP45: Advanced Pricing
314F4072Price Adjustment Detail9ADCRCDCurrency Code - FromStringGeneric Edit30
315F4072PPrice Adjustment Detail Purge10ADCRCDCurrency Code - FromStringGeneric Edit30
316F4072WPrice Adjustment Detail Work File9ADCRCDCurrency Code - FromStringGeneric Edit30
317F4075Price Variable Table2VBCRCDCurrency Code - FromStringGeneric Edit30
318F4077Rebate Thresholds10RTCRCDCurrency Code - FromStringGeneric Edit30
319F4077PRebate Thresholds Purge11RTCRCDCurrency Code - FromStringGeneric Edit30
320F4078Rebate Transaction Summary11RHCRCDCurrency Code - FromStringGeneric Edit30
321F4079Rebate Transaction Detail15SVCRCDCurrency Code - FromStringGeneric Edit30
322F4511WPricing Structure View46APCRCDCurrency Code - FromStringGeneric Edit30
323F45520Price List Header14PHCRCDCurrency Code - FromStringGeneric Edit30
324F4572Z1Live Promotions Interface - Inbound / Outbound27LPCRCDCurrency Code - FromStringGeneric Edit30
325F4572ZPPurge Live Promotions Interface27PGCRCDCurrency Code - FromStringGeneric Edit30
326F4574Key Reference Table16KRCRCDCurrency Code - FromStringGeneric Edit30
327F4575Ship and Debit History36AHCRCDCurrency Code - FromStringGeneric Edit30
328F4575TMPShip and Debit History - Temp Table36AHCRCDCurrency Code - FromStringGeneric Edit30
329F4576Ship and Debit Claims27ACCRCDCurrency Code - FromStringGeneric Edit30
330F4576TMPShip and Debit Claims- Temp Table27ACCRCDCurrency Code - FromStringGeneric Edit30
331F4576Z1Ship and Debit Claims Unedited Transaction Table40Z1CRCDCurrency Code - FromStringGeneric Edit30
TOP46: Warehouse Management
332F4942Z1Work File for F494235SYCRCDCurrency Code - FromStringGeneric Edit30
TOP47: Electronic Commerce
333F47007EDI Order Detail - Outbound Tax Table26DTCRCDCurrency Code - FromStringGeneric Edit30
334F47011EDI Purchase Order Header - Inbound82SYCRCDCurrency Code - FromStringGeneric Edit30
335F47012EDI Purchase Order Detail - Inbound208SZCRCDCurrency Code - FromStringGeneric Edit30
336F47012TXEDI Purchase Order Detail Tax - Inbound25DTCRCDCurrency Code - FromStringGeneric Edit30
337F47016EDI Purchase Order Header - Outbound83SYCRCDCurrency Code - FromStringGeneric Edit30
338F47017EDI Purchase Order Detail - Outbound169SZCRCDCurrency Code - FromStringGeneric Edit30
339F47021EDI P.O. Acknowledgment Header - Inbound83SYCRCDCurrency Code - FromStringGeneric Edit30
340F47022EDI P.O. Acknowledgment Detail - Inbound169SZCRCDCurrency Code - FromStringGeneric Edit30
341F47026EDI P.O. Acknowledgment Header - Outbound78SYCRCDCurrency Code - FromStringGeneric Edit30
342F47027EDI P.O. Acknowledgment Detail - Outbound208SZCRCDCurrency Code - FromStringGeneric Edit30
343F47031EDI Shipping Notice Header - Inbound78SYCRCDCurrency Code - FromStringGeneric Edit30
344F47032EDI Shipping Notice Detail - Inbound109SZCRCDCurrency Code - FromStringGeneric Edit30
345F47037EDI Shipping Notice Detail - Outbound157SZCRCDCurrency Code - FromStringGeneric Edit30
346F470371EDI Shipping Notice Detail - Outbound176SZCRCDCurrency Code - FromStringGeneric Edit30
347F470371XEDI Shipping Notice Detail Tax - Outbound29DTCRCDCurrency Code - FromStringGeneric Edit30
348F47041EDI Invoice Header - Inbound32SYCRCDCurrency Code - FromStringGeneric Edit30
349F47042EDI Invoice Detail - Inbound69SZCRCDCurrency Code - FromStringGeneric Edit30
350F47044EDI Invoice Summary - Inbound35SWCRCDCurrency Code - FromStringGeneric Edit30
351F47046EDI Invoice Header (Sales) - Outbound78SYCRCDCurrency Code - FromStringGeneric Edit30
352F47047EDI Invoice Detail (Sales) - Outbound208SZCRCDCurrency Code - FromStringGeneric Edit30
353F47056EDI Payment Order Header - Outbound30D1CRCDCurrency Code - FromStringGeneric Edit30
354F47056WEDI Payment Order Header - Work30D1CRCDCurrency Code - FromStringGeneric Edit30
355F47057EDI Payment Order Remittance Advice - Outbound30D3CRCDCurrency Code - FromStringGeneric Edit30
356F47057WEDI Payment Order Remittance Advice - Work30D3CRCDCurrency Code - FromStringGeneric Edit30
357F47071EDI Receiving Advice Header - Inbound84SYCRCDCurrency Code - FromStringGeneric Edit30
358F47072EDI Receiving Advice Detail - Inbound170SZCRCDCurrency Code - FromStringGeneric Edit30
359F47076EDI Receiving Advice Header - Outbound84SYCRCDCurrency Code - FromStringGeneric Edit30
360F47077EDI Receiving Advice Detail - Outbound170SZCRCDCurrency Code - FromStringGeneric Edit30
361F47081EDI Price Sales Catalog Header - Inbound30FVCRCDCurrency Code - FromStringGeneric Edit30
362F47082EDI Price Sales Catalog Detail - Inbound67FYCRCDCurrency Code - FromStringGeneric Edit30
363F47091EDI Request for Quote Header - Inbound82SYCRCDCurrency Code - FromStringGeneric Edit30
364F47092EDI Request for Quote Detail - Inbound208SZCRCDCurrency Code - FromStringGeneric Edit30
365F47096EDI Request for Quote Header - Outbound83SYCRCDCurrency Code - FromStringGeneric Edit30
366F47097EDI Request for Quote Detail - Outbound169SZCRCDCurrency Code - FromStringGeneric Edit30
367F47098EDI RFQ Detail Quantity - Outbound16SZCRCDCurrency Code - FromStringGeneric Edit30
368F47101EDI Response to RFQ Header - Inbound83SYCRCDCurrency Code - FromStringGeneric Edit30
369F47102EDI Response to RFQ Detail - Inbound169SZCRCDCurrency Code - FromStringGeneric Edit30
370F47103EDI Response to RFQ Detail Quantity - Inbound16SZCRCDCurrency Code - FromStringGeneric Edit30
371F47106EDI Response to RFQ Header - Outbound78SYCRCDCurrency Code - FromStringGeneric Edit30
372F47107EDI Response to RFQ Detail - Outbound207SZCRCDCurrency Code - FromStringGeneric Edit30
373F47113EDI Lockbox/Payment Detail - Batch23Z3CRCDCurrency Code - FromStringGeneric Edit30
374F47122EDI Product Activity Data Detail - Inbound65MJCRCDCurrency Code - FromStringGeneric Edit30
375F47127EDI Product Activity Data Detail - Outbound65MJCRCDCurrency Code - FromStringGeneric Edit30
376F47131EDI Purchase Order Change Header - Inbound79SYCRCDCurrency Code - FromStringGeneric Edit30
377F47132EDI Purchase Order Change Detail - Inbound209SZCRCDCurrency Code - FromStringGeneric Edit30
378F47132TXEDI Purchase Order Change Detail Tax - Inbound25DTCRCDCurrency Code - FromStringGeneric Edit30
379F47136EDI Purchase Order Change Header - Outbound83SYCRCDCurrency Code - FromStringGeneric Edit30
380F47137EDI Purchase Order Change Detail - Outbound170SZCRCDCurrency Code - FromStringGeneric Edit30
381F47141EDI P.O. Change Acknowledgment Header - Inbound84SYCRCDCurrency Code - FromStringGeneric Edit30
382F47142EDI P.O. Change Acknowledgment Detail - Inbound171SZCRCDCurrency Code - FromStringGeneric Edit30
383F47146EDI P.O. Change Acknowledgment Header - Outbound79SYCRCDCurrency Code - FromStringGeneric Edit30
384F47147EDI P.O. Change Acknowledgment Detail - Outbound210SZCRCDCurrency Code - FromStringGeneric Edit30
385F47156EDI Shipping Schedule Header - Outbound87SYCRCDCurrency Code - FromStringGeneric Edit30
386F47157EDI Shipping Schedule Detail - Outbound192SZCRCDCurrency Code - FromStringGeneric Edit30
TOP48: Work Order Processing
387F4801STPurge - Work Order Master Tag File17WACRCDCurrency Code - FromStringGeneric Edit30
388F4801TWork Order Master Tag File17WACRCDCurrency Code - FromStringGeneric Edit30
389F4801Z1Outbound Work Order Header164SYCRCDCurrency Code - FromStringGeneric Edit30
390F4817Service Order Extension53SRCRCDCurrency Code - FromStringGeneric Edit30
TOP48S: Service Billing
391F48096Billing Rate / Mark up Table29WQCRCDCurrency Code - FromStringGeneric Edit30
392F4812Billing Detail Workfile109WDCRCDCurrency Code - FromStringGeneric Edit30
393F4812HBilling Workfile History109WDCRCDCurrency Code - FromStringGeneric Edit30
394F4812HSBilling Workfile History Purged Save109WDCRCDCurrency Code - FromStringGeneric Edit30
395F4822Invoice Summary Work File88W4CRCDCurrency Code - FromStringGeneric Edit30
396F4823Voucher Summary60W0CRCDCurrency Code - FromStringGeneric Edit30
397F48520Invoice Summary Access12AECRCDCurrency Code - FromStringGeneric Edit30
398F4860Component Table Master5AFCRCDCurrency Code - FromStringGeneric Edit30
399F4861Component Table Detail12AFCRCDCurrency Code - FromStringGeneric Edit30
400F4862Component Cross Reference5AFCRCDCurrency Code - FromStringGeneric Edit30
401F48S0618Payroll Reclassification Workfile114YTCRCDCurrency Code - FromStringGeneric Edit30
402F48S910Billing Detail Journal Workfile38W2CRCDCurrency Code - FromStringGeneric Edit30
403F48S911Summarized Journal Workfile23W3CRCDCurrency Code - FromStringGeneric Edit30
404F48SUI01Billing Detail Print Workfile109WDCRCDCurrency Code - FromStringGeneric Edit30
TOP49: Transportation Management
405F47092TXEDI Request for Quote Detail Tax - Inbound25DTCRCDCurrency Code - FromStringGeneric Edit30
406F4941Shipment Routing Steps38RSCRCDCurrency Code - FromStringGeneric Edit30
407F4942Shipment Detail22ISCRCDCurrency Code - FromStringGeneric Edit30
408F4945Shipment Charges24SCCRCDCurrency Code - FromStringGeneric Edit30
409F4950Routing Entries23RTCRCDCurrency Code - FromStringGeneric Edit30
410F49501Intermodal Detail Routing Entries9RDCRCDCurrency Code - FromStringGeneric Edit30
411F49595Document Print - Document Summary16DKCRCDCurrency Code - FromStringGeneric Edit30
412F49633Load In-Transit Confirmed Quantities28IQCRCDCurrency Code - FromStringGeneric Edit30
413F49634Load In-Transit Confirmed Quantities Detail19QDCRCDCurrency Code - FromStringGeneric Edit30
414F49695Document Register14DRCRCDCurrency Code - FromStringGeneric Edit30
415F4972Rate Detail6RXCRCDCurrency Code - FromStringGeneric Edit30
416F49721Spot Quote Detail8QSCRCDCurrency Code - FromStringGeneric Edit30
417F4973Rate Structure Definition9TLCRCDCurrency Code - FromStringGeneric Edit30
418F4977Rate Parameters3MRCRCDCurrency Code - FromStringGeneric Edit30
419F4981Freight Audit History37FHCRCDCurrency Code - FromStringGeneric Edit30
420F49T10Sales Order Release Staging Table30ORCRCDCurrency Code - FromStringGeneric Edit30
421F49T100Procurement Freight Request staging table20OBCRCDCurrency Code - FromStringGeneric Edit30
422F49T20Shipment Staging Table28SSCRCDCurrency Code - FromStringGeneric Edit30
423F49T40Shipment Freight Cost Staging Table8TCCRCDCurrency Code - FromStringGeneric Edit30
424F49T80Locations Staging Table8LCCRCDCurrency Code - FromStringGeneric Edit30
TOP51: Job Costing
425F51006MCM Currency Code Mapping1VMCRCDCurrency Code - FromStringGeneric Edit30
TOP51X: In-Memory Project Management
426F51X0902Ledger Balances Worktable10LBCRCDCurrency Code - FromStringGeneric Edit30
427F51X10Project Advisor Console Worktable15EXCRCDCurrency Code - FromStringGeneric Edit30
428F51X21Billing Amount Worktable27BACRCDCurrency Code - FromStringGeneric Edit30
429F51X30Project Advisor Results Header107PBCRCDCurrency Code - FromStringGeneric Edit30
TOP52: Contract Billing
430F5201Contract Master45G4CRCDCurrency Code - FromStringGeneric Edit30
431F5202Contract Billing Line Detail75G6CRCDCurrency Code - FromStringGeneric Edit30
432F5216Milestone/Progress Billing Information13A6CRCDCurrency Code - FromStringGeneric Edit30
433F5280Contract Revenue Summary17GWCRCDCurrency Code - FromStringGeneric Edit30
434F5280WContract Revenue Summary Work File14GYCRCDCurrency Code - FromStringGeneric Edit30
TOP52G: Proj & Gov Contract Accounting
435F4822HInvoice Summary History88IHCRCDCurrency Code - FromStringGeneric Edit30
436F52G01MAdvanced Contracts Modifications50CMCRCDCurrency Code - FromStringGeneric Edit30
437F52G05ACRN Detail Table12ADCRCDCurrency Code - FromStringGeneric Edit30
438F52G05HACRN History Table20AHCRCDCurrency Code - FromStringGeneric Edit30
439F52G200Advanced Contract Billing Limit Summary11LSCRCDCurrency Code - FromStringGeneric Edit30
440F52G90Invoice Printing Work Table36WTCRCDCurrency Code - FromStringGeneric Edit30
TOP53: Change Management
441F5301BChange Request Master Table42DICRCDCurrency Code - FromStringGeneric Edit30
442F5301BZ1Change Request Master Table Workfile46DICRCDCurrency Code - FromStringGeneric Edit30
443F5311Change Request Details Table141DKCRCDCurrency Code - FromStringGeneric Edit30
444F5311Z1Change Request Details Table Workfile146DKCRCDCurrency Code - FromStringGeneric Edit30
445F5314Planned Change Order Master Table40D2CRCDCurrency Code - FromStringGeneric Edit30
446F5315Change Order Master Table39D3CRCDCurrency Code - FromStringGeneric Edit30
TOP54HS: Health & Safety Incident Mgt
447F54HS01Incident Master43S1CRCDCurrency Code - FromStringGeneric Edit30
448F54HS01MIncident Master Change History46I1CRCDCurrency Code - FromStringGeneric Edit30
449F54HS07Incident Costs8S8CRCDCurrency Code - FromStringGeneric Edit30
450F54HS07MIncident Costs Change History11I8CRCDCurrency Code - FromStringGeneric Edit30
TOP54R: Rental Management
451F54R099Rental Contract Header Ledger74HLCRCDCurrency Code - FromStringGeneric Edit30
452F54R10Rental Contract Header72CHCRCDCurrency Code - FromStringGeneric Edit30
453F54R11Rental Contract Detail119CDCRCDCurrency Code - FromStringGeneric Edit30
454F54R199Rental Contract Detail Ledger115DLCRCDCurrency Code - FromStringGeneric Edit30
TOP70: Multi-National Products
455F700050Bank Connection for Legal Documents - COMM - 001BCCRCDCurrency Code - FromStringGeneric Edit30
456F7001100Localizations Additional Fields AB - 0155LACRCDCurrency Code - FromStringGeneric Edit30
457F7003B11Localizations Additional Fields Customer Ledger - 0158LACRCDCurrency Code - FromStringGeneric Edit30
458F700411Localizations Additional Fields Accounts Payable Ledger - 0459LACRCDCurrency Code - FromStringGeneric Edit30
459F702018Taxes by Sales Order Line - COMM - 4210TACRCDCurrency Code - FromStringGeneric Edit30
460F702033Sales Document Line Tag File - COMM - 4211D1CRCDCurrency Code - FromStringGeneric Edit30
461F704001Payment WH Info TEMP - COMM - 0452PTCRCDCurrency Code - FromStringGeneric Edit30
462F704002Payment WH Info - COMM - 0451PFCRCDCurrency Code - FromStringGeneric Edit30
463F704002PPayment WH Info Purge - COMM - 0451PFCRCDCurrency Code - FromStringGeneric Edit30
464F704008Localizations Additional Fields Tax Area - 0454LACRCDCurrency Code - FromStringGeneric Edit30
465F704100Suspended VAT AP - COMM - 7016VACRCDCurrency Code - FromStringGeneric Edit30
466F704101ALocalizations Additional Fields Item Master - 0155LACRCDCurrency Code - FromStringGeneric Edit30
467F704200Final VAT AP - COMM - 7018FVCRCDCurrency Code - FromStringGeneric Edit30
468F704201Localizations Additional Fields Sales Order - 0157LACRCDCurrency Code - FromStringGeneric Edit30
TOP74: EMEA Localization
469F0018TIntrastat Revision41TDCRCDCurrency Code - FromStringGeneric Edit30
470F740018DData extraction ESL - 7428DECRCDCurrency Code - FromStringGeneric Edit30
471F740018WData extraction ESL - Workfile - 7428DECRCDCurrency Code - FromStringGeneric Edit30
472F74030HDutch-Payments Bank Information15NLCRCDCurrency Code - FromStringGeneric Edit30
473F74093Worktable for Printing IVA Summary - Italy52HCCRCDCurrency Code - FromStringGeneric Edit30
474F740931IVA Summary Report Header - Worktable- Italy4HDCRCDCurrency Code - FromStringGeneric Edit30
475F7420018Taxes by Sales Order Line - COMM - 428STCRCDCurrency Code - FromStringGeneric Edit30
476F7420033Sales Document Line (Print Info) - COMM - 4212PICRCDCurrency Code - FromStringGeneric Edit30
477F7420034Price Adjustment (Print Info) - COMM - 426PICRCDCurrency Code - FromStringGeneric Edit30
478F7430018Taxes by A/R Invoice Line - COMM - 03B8TICRCDCurrency Code - FromStringGeneric Edit30
479F7430030Legal Document Header (Print Info) - COMM - 03B11PICRCDCurrency Code - FromStringGeneric Edit30
480F7430033A/R Document Line (Print Info) - COMM - 03B9PICRCDCurrency Code - FromStringGeneric Edit30
481F7430035Taxes by Legal Document Line - COMM - 03B6PICRCDCurrency Code - FromStringGeneric Edit30
482F743035Display Taxes by Legal Document Line - COMM - 03B8DTCRCDCurrency Code - FromStringGeneric Edit30
483F74411Withholding Tax Detail - Italy21RSCRCDCurrency Code - FromStringGeneric Edit30
484F74412Customer / Supplier Balance Worktable (A/P and A/R)17RPCRCDCurrency Code - FromStringGeneric Edit30
485F74900Foreign Receivables and Payables - EMEA40RPCRCDCurrency Code - FromStringGeneric Edit30
486F749103Section Column Definition - EMEA - 7414CDCRCDCurrency Code - FromStringGeneric Edit30
487F749105Cells Definition - EMEA - 7412EDCRCDCurrency Code - FromStringGeneric Edit30
488F74UI92WF - Account Cell Value - EMEA - 7413CVCRCDCurrency Code - FromStringGeneric Edit30
TOP74B: Begium Localization
489F74B200Yearly/Quarterly VAT Listing - Belgium9VTCRCDCurrency Code - FromStringGeneric Edit30
490F74B250History VAT Listing - BEL - 0024CPCRCDCurrency Code - FromStringGeneric Edit30
TOP74F: France
491F74F210FEC - Last Sequence Number by CO-Fiscal Period - FR9FPCRCDCurrency Code - FromStringGeneric Edit30
TOP74H: Hungary
492F74H309Gains & Losses Unrealized Account ing - HUN - 03B16GLCRCDCurrency Code - FromStringGeneric Edit30
493F74H409A/P Gains & Losses Unrealized Accounting - HUN - 0416GLCRCDCurrency Code - FromStringGeneric Edit30
494F74H410Foreign Voucher Supplier Amounts - HUN - 74H23SACRCDCurrency Code - FromStringGeneric Edit30
TOP74L: Portugal
495F74L3035Tax Details by Legal Document - POR - 74L15TDCRCDCurrency Code - FromStringGeneric Edit30
TOP74P: Poland
496F74902TAccount Balance Tag File - COM - 09 - 74P8ATCRCDCurrency Code - FromStringGeneric Edit30
497F74P03BWA/R Trial Balance - POL - 03B - 74P5P3CRCDCurrency Code - FromStringGeneric Edit30
498F74P04WA/P Trial Balance Work Table - POL - 04 - 74P5P2CRCDCurrency Code - FromStringGeneric Edit30
TOP74R: Russia
499F74R0018Russian Tax File - 74R43TDCRCDCurrency Code - FromStringGeneric Edit30
500F74R0100Petty Cash Transactions - RUS - 00 - 74R19PCCRCDCurrency Code - FromStringGeneric Edit30
501F74R012Cash Documents Next Number Setup - RUS - 007CDCRCDCurrency Code - FromStringGeneric Edit30
502F74R3035Currency Code Relationship - RUS - 74R1CCCRCDCurrency Code - FromStringGeneric Edit30
503F74R311Prepayment Detail Tax File - RUS - 03B22DECRCDCurrency Code - FromStringGeneric Edit30
504F74R410Tax on Hold - RUS - 049THCRCDCurrency Code - FromStringGeneric Edit30
505F74R9002Correspondence Balance - RUS- 09 - 74R44GBCRCDCurrency Code - FromStringGeneric Edit30
506F74R9011Correspondence Rules - RUS -09 - 74R32CRCRCDCurrency Code - FromStringGeneric Edit30
507F74R9029Open Accounts - RUS - 09 - 74R10OACRCDCurrency Code - FromStringGeneric Edit30
TOP74S: Spain
508F74S505Stamps (Timbres) Fee Header - 03B2SHCRCDCurrency Code - FromStringGeneric Edit30
509F74S55Expenses and Exchange Rate for Payments - Spain - 0416Q5CRCDCurrency Code - FromStringGeneric Edit30
510F74S70Model 347 - Record Type 0 - Spain - 03B17Q0CRCDCurrency Code - FromStringGeneric Edit30
511F74S90Model 349 - Record Type 0 - Spain - 03B23Q0CRCDCurrency Code - FromStringGeneric Edit30
TOP74U: United Kingdom Localizations
512F74U0405SPC Certificate Holding Table - UK - 4317CHCRCDCurrency Code - FromStringGeneric Edit30
513F74U0420SPC - Application Master - UK - 4351SECRCDCurrency Code - FromStringGeneric Edit30
514F74U0425SPC - Certificate Master - UK - 4353SFCRCDCurrency Code - FromStringGeneric Edit30
TOP74W: Sweden
515F74W203Debit Advice Invoice File - 74W6K3CRCDCurrency Code - FromStringGeneric Edit30
TOP74Y: Italy
516F74Y021Italy Intrastat Declarations - Detail Sections - ITA - 0018IDCRCDCurrency Code - FromStringGeneric Edit30
517F74Y050Third party Black List Amounts - IT - 0028THCRCDCurrency Code - FromStringGeneric Edit30
518F74Y060Yearly List Summarized Workfile -ITA - 74Y29YSCRCDCurrency Code - FromStringGeneric Edit30
519F74Y061Yearly List Detailed Workfile -ITA - 74Y21YDCRCDCurrency Code - FromStringGeneric Edit30
TOP74Z: Czech Republic
520F74Z0010Cash Desk Document Printed - CZE - 74Z12ZOCRCDCurrency Code - FromStringGeneric Edit30
TOP75C: China
521F75C001Chinese GUI cross reference file13CRCRCDCurrency Code - FromStringGeneric Edit30
522F75C007China - Chart of Accounts Set Up7CACRCDCurrency Code - FromStringGeneric Edit30
523F75C010WAP & AR XML Workfile - China -75C19AACRCDCurrency Code - FromStringGeneric Edit30
524F75C014AP/AR Balances - China11BACRCDCurrency Code - FromStringGeneric Edit30
525F75C015Cash Flow Data - China25CFCRCDCurrency Code - FromStringGeneric Edit30
526F75C902Subsidiary Balances File - China7SBCRCDCurrency Code - FromStringGeneric Edit30
527F75C910China Reports Balance -CNAO V28CFCRCDCurrency Code - FromStringGeneric Edit30
TOP75I: India
528F75I035Display Taxes by Legal Document Line Tag File - IND - 03B6DGCRCDCurrency Code - FromStringGeneric Edit30
529F75I055Vouchers Generated for Reverse Charge AP - IND - 0417RPCRCDCurrency Code - FromStringGeneric Edit30
530F75I309Personal Consumption - CENVAT setoff - IND - 4127CSCRCDCurrency Code - FromStringGeneric Edit30
531F75I357Consignment Header23CHCRCDCurrency Code - FromStringGeneric Edit30
532F75I3571Consignment - Work Orders24CWCRCDCurrency Code - FromStringGeneric Edit30
533F75I3572Consignment - Stock Transfers27CSCRCDCurrency Code - FromStringGeneric Edit30
534F75I3573Consignment - Order Items29COCRCDCurrency Code - FromStringGeneric Edit30
535F75I3574Consignment - Issues/Receipts Transactions38CTCRCDCurrency Code - FromStringGeneric Edit30
536F75I3575Consignment - Work Order Part List Items - Balances21CPCRCDCurrency Code - FromStringGeneric Edit30
537F75I3576Stock Transfer - Work Orders26SWCRCDCurrency Code - FromStringGeneric Edit30
538F75I380Excise - RG-1 - Transaction File - IND49RGCRCDCurrency Code - FromStringGeneric Edit30
539F75I385RG23D Register - Issues - IND - 4220EDCRCDCurrency Code - FromStringGeneric Edit30
540F75I3901Work With Consignment - IND -4342COCRCDCurrency Code - FromStringGeneric Edit30
541F75I4074Price Adj Ledger Tag File - 03B13ALCRCDCurrency Code - FromStringGeneric Edit30
542F75I409Personal Consumption - VAT setoff - IND - 4121VSCRCDCurrency Code - FromStringGeneric Edit30
543F75I735Order Detail by Service Category Code - IND - 75I14STCRCDCurrency Code - FromStringGeneric Edit30
544F75IUI7Service Tax Credit Register - Work File - IND14WFCRCDCurrency Code - FromStringGeneric Edit30
TOP75J: Japan
545F75012Bank Charge - Japan - 0411J2CRCDCurrency Code - FromStringGeneric Edit30
546F75013Stamp Tax - Japan - 043J3CRCDCurrency Code - FromStringGeneric Edit30
547F75014Withholding - Japan - 042JPCRCDCurrency Code - FromStringGeneric Edit30
TOP75T: Taiwan
548F75T004GUI/VAT Transaction Header - 75T26THCRCDCurrency Code - FromStringGeneric Edit30
549F75T0049GUI/VAT Transaction Header History - 75T26THCRCDCurrency Code - FromStringGeneric Edit30
550F75T004PGUI/VAT Transaction Header POS - 75T27THCRCDCurrency Code - FromStringGeneric Edit30
551F75T004ZGUI/VAT Transaction Header - Work - 75T24ZHCRCDCurrency Code - FromStringGeneric Edit30
552F75T005GUI/VAT Transaction Detail - 75T23TDCRCDCurrency Code - FromStringGeneric Edit30
553F75T0059GUI/VAT Transaction Detail History - 75T23TDCRCDCurrency Code - FromStringGeneric Edit30
554F75T005PGUI/VAT Transaction Detail POS - 75T29TDCRCDCurrency Code - FromStringGeneric Edit30
555F75T005TGUI/VAT Transaction Detail Temp - 75T23TDCRCDCurrency Code - FromStringGeneric Edit30
556F75T005ZGUI/VAT Transaction Detail - Work - 75T30ZDCRCDCurrency Code - FromStringGeneric Edit30
557F75T1113Taiwan Exchange Rate Update3TRCRCDCurrency Code - FromStringGeneric Edit30
558F75T42WWork file with union of F4211 and F4211937SWCRCDCurrency Code - FromStringGeneric Edit30
TOP76A: Argentina
559F764008AAditionals Tax Areas - ARG - 04 - 76A71TQCRCDCurrency Code - FromStringGeneric Edit30
560F76A0440Check details RG 1547 - ARG - 04 - 76A8CDCRCDCurrency Code - FromStringGeneric Edit30
561F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A12IHCRCDCurrency Code - FromStringGeneric Edit30
562F76A21PCredit Invoice Header Purge - ARG - 03B - 76A12IHCRCDCurrency Code - FromStringGeneric Edit30
563F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A6IECRCDCurrency Code - FromStringGeneric Edit30
564F76A396Item Valuation Cost Master - 76A1CSCRCDCurrency Code - FromStringGeneric Edit30
565F76A40Withholding Certificates Legal Number - 76A14WCCRCDCurrency Code - FromStringGeneric Edit30
566F76A55Withholding Certificates Legal Number History Files - 76A9HWCRCDCurrency Code - FromStringGeneric Edit30
567F76A8500Tag File F03B14 - ARG - 03B - 76A19TFCRCDCurrency Code - FromStringGeneric Edit30
568F76AUI81Draft - Invoices Work File - ARG - 03B - 76A16WFCRCDCurrency Code - FromStringGeneric Edit30
569F76AUI82Draft - Drafts Work File - ARG - 03B - 03B39WFCRCDCurrency Code - FromStringGeneric Edit30
570F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A22WFCRCDCurrency Code - FromStringGeneric Edit30
TOP76B: Brazil
571F7601BNota Fiscal Header - BRA - 4284FHCRCDCurrency Code - FromStringGeneric Edit30
572F7611BNota Fiscal Detail - BRA - 42107FDCRCDCurrency Code - FromStringGeneric Edit30
573F76B016Import Declarations17IDCRCDCurrency Code - FromStringGeneric Edit30
574F76B1001Tag File F7601B Nota Fiscal Header - BRA - 76B8THCRCDCurrency Code - FromStringGeneric Edit30
575F76B1010Tag File F7611B Nota Fiscal Detail - BRA - 76B11TDCRCDCurrency Code - FromStringGeneric Edit30
576F76B4101Tag file F76411 - Item Master - BRA - 76B7IMCRCDCurrency Code - FromStringGeneric Edit30
577F76B4102Tag file F76412 - Item Branch - BRA - 76B10IBCRCDCurrency Code - FromStringGeneric Edit30
578F76B429Service Nota Fiscal Wh by Formula Installment - BRA - 76B12SNCRCDCurrency Code - FromStringGeneric Edit30
TOP76C: Colombia
579F76C031AA/R Customer ledger As Of - F76C031A - COL - 0432RPCRCDCurrency Code - FromStringGeneric Edit30
580F76C034AA/R Check Detail file As Of - COL - 03B32RZCRCDCurrency Code - FromStringGeneric Edit30
581F76C0902Debits and Credits T/B by object account - COL - 76C20GBCRCDCurrency Code - FromStringGeneric Edit30
582F76C9F02DIAN Formats by AccountID - COL - 0916DFCRCDCurrency Code - FromStringGeneric Edit30
583F76CI1Tax Parameters - COL - 76C20PICRCDCurrency Code - FromStringGeneric Edit30
584F76CUI02Tax Detail - Work File - COL - 76C58TDCRCDCurrency Code - FromStringGeneric Edit30
585F76CUI04Tax Detail for Distribution - Work File - COL - 76C59TDCRCDCurrency Code - FromStringGeneric Edit30
TOP76H: Chile
586F76H218Taxes by Sales Order Line - CHI - 42 - 76H25TDCRCDCurrency Code - FromStringGeneric Edit30
587F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H34PICRCDCurrency Code - FromStringGeneric Edit30
588F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H6PICRCDCurrency Code - FromStringGeneric Edit30
589F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H11PICRCDCurrency Code - FromStringGeneric Edit30
590F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H6PICRCDCurrency Code - FromStringGeneric Edit30
591F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H5PICRCDCurrency Code - FromStringGeneric Edit30
592F76H3B40A/P Document Line (Print Info) - CHI - 045PICRCDCurrency Code - FromStringGeneric Edit30
593F76H3B50Lot of Printing - Header - CHI - 03B - 76H10LPCRCDCurrency Code - FromStringGeneric Edit30
594F76H902TAccount Balances Tag File - CHI - 09 - 76H8ATCRCDCurrency Code - FromStringGeneric Edit30
595F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H19WFCRCDCurrency Code - FromStringGeneric Edit30
TOP76M: Mexico
596F76M0314Receipt Detail Tag File - Mexico18MACRCDCurrency Code - FromStringGeneric Edit30
597F76M0414F0414 - Payment Detail Tag File - Mexico20RTCRCDCurrency Code - FromStringGeneric Edit30
598F76M311AR Soft Rounding VAT - Mexico10MBCRCDCurrency Code - FromStringGeneric Edit30
599F76M411Soft Rounding VAT Calculation12RSCRCDCurrency Code - FromStringGeneric Edit30
TOP79A: Greenhouse Gas Accounting
600F79A11GHG Ledger49GRCRCDCurrency Code - FromStringGeneric Edit30
601F79A11Z1GHG Ledger - Batch File57GLCRCDCurrency Code - FromStringGeneric Edit30
602F79A12GHG Ledger Audit50GRCRCDCurrency Code - FromStringGeneric Edit30
603F79A80GHG Carbon Permit Management8CPCRCDCurrency Code - FromStringGeneric Edit30
604F79AU11GHG Ledger Work Table53GRCRCDCurrency Code - FromStringGeneric Edit30
TOP83: Management Reporting - FASTR
605F83UI001Balance Audit Work File - (Financial Reporting)14R1CRCDCurrency Code - FromStringGeneric Edit30
TOP89: Conversion Programs
606F00151Needed for upgrade for XE and below1T1CRCDCurrency Code - FromStringGeneric Edit30
607F06116TNeeded for upgrade from Xe to B99YTCRCDCurrency Code - FromStringGeneric Edit30
608F06116TZNeeded for upgrade from Xe to B910VLCRCDCurrency Code - FromStringGeneric Edit30
609F0618TNeeded for upgrade from Xe to B99YTCRCDCurrency Code - FromStringGeneric Edit30
610F0902AAccount Debit Balances8GDCRCDCurrency Code - FromStringGeneric Edit30
611F4072TEMPrice Adjustment Detail - Temp for Upgrade11ADCRCDCurrency Code - FromStringGeneric Edit30
612F43199ATemp F43199 for ERP 9.0 Upgrade166OLCRCDCurrency Code - FromStringGeneric Edit30
TOP90CB: CRM Sales Force Automation
613F90CB020Opportunity Table23OTCRCDCurrency Code - FromStringGeneric Edit30
614F90CB02MCost Table39OMCRCDCurrency Code - FromStringGeneric Edit30
615F90CB06BOpportunity_For_Forecast Table23OFCRCDCurrency Code - FromStringGeneric Edit30
616F90CB06ZOpportunity for Forecast WTF24ZFCRCDCurrency Code - FromStringGeneric Edit30