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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

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

714 columns | Print definition?910 | CO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master5MCCOCompanyStringGeneric Edit50
2F0006SDate Effective Business Unit Master7MCCOCompanyStringGeneric Edit50
3F0006Z1Cost Center Unedited Transaction Table18SZCOCompanyStringGeneric Edit50
4F0010Company Constants1CCCOCompanyStringGeneric Edit50
5F0010TCompany Constants Tag Table1CCCOCompanyStringGeneric Edit50
6F0012Automatic Accounting Instructions Master2KGCOCompanyStringGeneric Edit50
7F0012DAAI Alternate Description Master2LJCOCompanyStringGeneric Edit50
8F0018Taxes1TDCOCompanyStringGeneric Edit50
9F00189WF - Tax Reconciliation1TGCOCompanyStringGeneric Edit50
10F0022Tax Rules1VACOCompanyStringGeneric Edit50
11F0026Job Cost Constants1CLCOCompanyStringGeneric Edit50
12F0028Sales Tax Work File by Taxing Authority9TECOCompanyStringGeneric Edit50
13F0029Sales Tax Work File by Taxing Authority and Document9TFCOCompanyStringGeneric Edit50
14F0039MGenerated Document Media Object History5GHCOCompanyStringGeneric Edit50
15F0902Account Balances7GBCOCompanyStringGeneric Edit50
16F0911Account Ledger13GLCOCompanyStringGeneric Edit50
17F09190Inter/Intra Company Account Relationships1C9COCompanyStringGeneric Edit50
18F4096Sales Flex Accounting3FACOCompanyStringGeneric Edit50
19F4303MLog Models19PMCOCompanyStringGeneric Edit50
TOP01: Address Book
20F01301Activity Master59AMCOCompanyStringGeneric Edit50
21F01301DActivity Detail60ADCOCompanyStringGeneric Edit50
TOP03: Accounts Receivable
22F03012Customer Master by Line of Business2AICOCompanyStringGeneric Edit50
23F03012ADate Effective Category Codes2A2COCompanyStringGeneric Edit50
24F03012Z1Customer Master LOB-Batch Table15VOCOCompanyStringGeneric Edit50
25F0311Accounts Receivable Ledger15RPCOCompanyStringGeneric Edit50
26F0312A/R Batch Cash Application27RUCOCompanyStringGeneric Edit50
TOP03B: Enhanced Accounts Receivable
27F03012TCustomer Master by Line of Business Tag Table2ATCOCompanyStringGeneric Edit50
28F03B08Credit/Collection Date Pattern1RDCOCompanyStringGeneric Edit50
29F03B11Customer Ledger14RPCOCompanyStringGeneric Edit50
30F03B112Invoice Revisions14RWCOCompanyStringGeneric Edit50
31F03B112PInvoice Revisions Purge File14RWCOCompanyStringGeneric Edit50
32F03B11PCustomer Ledger Purge File14RPCOCompanyStringGeneric Edit50
33F03B11Z1Batch Invoices32VJCOCompanyStringGeneric Edit50
34F03B11Z2F03B11 Interoperability Table27SYCOCompanyStringGeneric Edit50
35F03B13Receipts Header17RYCOCompanyStringGeneric Edit50
36F03B13PReceipts Header Purge File17RYCOCompanyStringGeneric Edit50
37F03B13Z1Electronic Receipts Input34RUCOCompanyStringGeneric Edit50
38F03B13Z2F03B13 Interoperability Table30SYCOCompanyStringGeneric Edit50
39F03B14Receipts Detail18RZCOCompanyStringGeneric Edit50
40F03B14PReceipts Detail Purge File18RZCOCompanyStringGeneric Edit50
41F03B14Z2F03B14 Interoperability Table31SZCOCompanyStringGeneric Edit50
42F03B15Credit and Cash Management3RTCOCompanyStringGeneric Edit50
43F03B15TF03B15 Tag Table3RTCOCompanyStringGeneric Edit50
44F03B16A/R Statistical History2RVCOCompanyStringGeneric Edit50
45F03B16SA/R Statistical Summary3RSCOCompanyStringGeneric Edit50
46F03B20A/R Notification History7ZRCOCompanyStringGeneric Edit50
47F03B21A/R Notification History Detail4ZSCOCompanyStringGeneric Edit50
48F03B22A/R Fee Journal History7RSCOCompanyStringGeneric Edit50
49F03B23A/R Fee Journal History Detail19RTCOCompanyStringGeneric Edit50
50F03B25Delinquency Policy2RFCOCompanyStringGeneric Edit50
51F03B29Credit Insurance13IPCOCompanyStringGeneric Edit50
52F03B31Customer Activity Log4ZGCOCompanyStringGeneric Edit50
53F03B40A/R Deduction Management25RBCOCompanyStringGeneric Edit50
54F03B41A/R Deduction Activity14RCCOCompanyStringGeneric Edit50
55F03B465A/R Netting Workfile10ROCOCompanyStringGeneric Edit50
56F03B575Auto Debit Invoice Select and Build17RDCOCompanyStringGeneric Edit50
57F03B672Draft Remittance20RDCOCompanyStringGeneric Edit50
58F03BUI04Work File for Integrity by Offset Account4W3COCompanyStringGeneric Edit50
59F09UI011Receipt Prepost Work File8GLCOCompanyStringGeneric Edit50
TOP04: Accounts Payable
60F0401TSupplier Master - Voucher Match Automation File4VTCOCompanyStringGeneric Edit50
61F0401Z1TSupplier Master - Voucher Match Automation Tag File8VTCOCompanyStringGeneric Edit50
62F0411Accounts Payable Ledger18RPCOCompanyStringGeneric Edit50
63F0411AWF - As Of Accounts Payable Ledger18RPCOCompanyStringGeneric Edit50
64F0411PPurge - Accounts Payable Ledger18RPCOCompanyStringGeneric Edit50
65F0411Z1Voucher Transactions - Batch Upload36VLCOCompanyStringGeneric Edit50
66F0411Z3F0411 Interoperability Table40SZCOCompanyStringGeneric Edit50
67F0413Z1F0413 Interoperability Table19SYCOCompanyStringGeneric Edit50
68F0414Accounts Payable Matching Document Detail26RNCOCompanyStringGeneric Edit50
69F0414AWF - As Of Accounts Payable Payment Detail26RNCOCompanyStringGeneric Edit50
70F0414PPurge - Accounts Payable Matching Document Detail26RNCOCompanyStringGeneric Edit50
71F0414Z1F0414 Interoperability Table39SZCOCompanyStringGeneric Edit50
72F045141099 Merged Worktables (F045141:F045143)1G1COCompanyStringGeneric Edit50
73F0451411099 G/L Worktable1G1COCompanyStringGeneric Edit50
74F0451431099 A/P Worktable1G1COCompanyStringGeneric Edit50
75F04572A/P Payment Processing - Summary20KKCOCompanyStringGeneric Edit50
76F04573A/P Payment Processing - Detail10KICOCompanyStringGeneric Edit50
77F04614T5018 Tax File2CTCOCompanyStringGeneric Edit50
78F046141T5018 Tax Workfile1CUCOCompanyStringGeneric Edit50
79F046UI01T5018 Tax Workfile1CVCOCompanyStringGeneric Edit50
80F04UI004Integrity Report Worktable4RPCOCompanyStringGeneric Edit50
81F04UI0061099 Worktable User Index1G1COCompanyStringGeneric Edit50
82F09UI005Tax Offsets User Index10GLCOCompanyStringGeneric Edit50
83F09UI006Tax (F0018) Replica1TDCOCompanyStringGeneric Edit50
TOP05: Time Accounting and HRM Base
84F050116WEmployee Master Integrations Work File10EMCOCompanyStringGeneric Edit50
85F051402Search Constants1SCCOCompanyStringGeneric Edit50
86F05400Self-Service Process Flow Settings2PFCOCompanyStringGeneric Edit50
87F054101Employee Personal Profile Information History Table22EHCOCompanyStringGeneric Edit50
88F054101WEmployee Personal Profile Information Work Table22EPCOCompanyStringGeneric Edit50
89F05430ESS User Defined Text3UTCOCompanyStringGeneric Edit50
90F0618Employee Transaction History7YTCOCompanyStringGeneric Edit50
91F069086Payroll Corporate Tax Identification1YICOCompanyStringGeneric Edit50
92F069216Workers Compensation Insurance Rates1YBCOCompanyStringGeneric Edit50
93F069226Unemployment Insurance Rates1YHCOCompanyStringGeneric Edit50
TOP05T: Time Entry
94F06116Employee Transaction Detail File7YTCOCompanyStringGeneric Edit50
95F06116Z1Employee Transactions - Batch File24VLCOCompanyStringGeneric Edit50
96F06116Z2ESS Timecard History24VMCOCompanyStringGeneric Edit50
97F06278Retro Timecard Detail File10YTCOCompanyStringGeneric Edit50
98F06290Payroll Accounting Journal Work File2YRCOCompanyStringGeneric Edit50
99F063951Payroll Journal (Compressed) File6GLCOCompanyStringGeneric Edit50
100F06904Automatic Accounting Instructions1Y#COCompanyStringGeneric Edit50
101F06914Accounting Summarization Rules File1JGCOCompanyStringGeneric Edit50
TOP05U: OW HR & PR Foundation US
102F05850EEO-1 Annual Data6EOCOCompanyStringGeneric Edit50
TOP06: Payroll (old) - Obsolete-do not reuse
103F06210Payroll Cycle Parameters5YDCOCompanyStringGeneric Edit50
104F069096Payroll General Constants1YKCOCompanyStringGeneric Edit50
105F0690961Payroll Additional Constants1YKCOCompanyStringGeneric Edit50
TOP07: Payroll
106F05290WF - Payroll Journal (Detail)6JRCOCompanyStringGeneric Edit50
107F06053Interim Check Parameters File36YWCOCompanyStringGeneric Edit50
108F06490Payroll/Accounts Payable Ledger Detail18JRCOCompanyStringGeneric Edit50
109F06491Payroll/Accounts Payable Ledger Detail11J6COCompanyStringGeneric Edit50
110F07100CCQ WORKFILE1F7COCompanyStringGeneric Edit50
111F07210Pay Cycle Parameters File58YDCOCompanyStringGeneric Edit50
112F07350Payment File5Y0COCompanyStringGeneric Edit50
113F074001New Hire Reporting Workfile - OneWorld Only2NHCOCompanyStringGeneric Edit50
114F07490Payroll - Accounts Payable Detail (One World)18JRCOCompanyStringGeneric Edit50
115F07491Payroll - Accounts Payable Summary File11J6COCompanyStringGeneric Edit50
116F07600Leave Administration Control1LCCOCompanyStringGeneric Edit50
117F077011Tax History Integrity (Temp)2Y$COCompanyStringGeneric Edit50
118F077011ATax History Integrity Additional (Temp)2Y$COCompanyStringGeneric Edit50
119F077021Transaction History Integrity(Temp)2Y$COCompanyStringGeneric Edit50
120F07811Negative Amount Workfile5JECOCompanyStringGeneric Edit50
121F07821Company Form Count Table2JGCOCompanyStringGeneric Edit50
122F07830Employee Federal Control Table4Y0COCompanyStringGeneric Edit50
123F07831Employee State/Local Control Table4YBCOCompanyStringGeneric Edit50
124F07832Employee Special Handling Control Table19YHCOCompanyStringGeneric Edit50
125F079430Prevailing Wage Transaction Detail19PWCOCompanyStringGeneric Edit50
126F079440Prevailing Wage Transaction History18PWCOCompanyStringGeneric Edit50
127F07UI200Timecard History Work File10THCOCompanyStringGeneric Edit50
TOP08: Human Resources
128F05401Self-Service Process Flow Director Text2DTCOCompanyStringGeneric Edit50
129F085540Benefits Enrollment Plan/Option URL Address8PUCOCompanyStringGeneric Edit50
130F085550Employee Self-Service Personal Information Options4IOCOCompanyStringGeneric Edit50
TOP08B: Benefits Administration
131F085518Benefit Confirmation Statement Options5SOCOCompanyStringGeneric Edit50
TOP08U: OW HR US
132F08990COBRA General Constants1HWCOCompanyStringGeneric Edit50
133F089901COBRA General Constants Additional Information1CCCOCompanyStringGeneric Edit50
134F089902COBRA General Constants - COBRA Notices Information1J2COCompanyStringGeneric Edit50
135F08991COBRA Qualifying Event Constant1HDCOCompanyStringGeneric Edit50
TOP08W: Wage and Salary
136F08818Increase Type Rules2YMCOCompanyStringGeneric Edit50
137F08830WFCompensation Root Work Table11YNCOCompanyStringGeneric Edit50
TOP09: General Accounting
138F0050AStructure Definition File49MACOCompanyStringGeneric Edit50
139F0901Account Master1GMCOCompanyStringGeneric Edit50
140F0902BAccount Balances - 52 Period Accounting7GBCOCompanyStringGeneric Edit50
141F0902PPurge - Account Balances7GBCOCompanyStringGeneric Edit50
142F0902Z1Account Balances - Batch File7GBCOCompanyStringGeneric Edit50
143F0909Chart of Accounts - Reference File2ACCOCompanyStringGeneric Edit50
144F0911PPurge - Account Ledger13GLCOCompanyStringGeneric Edit50
145F0911RWF - Account Ledger Reconciliation13GLCOCompanyStringGeneric Edit50
146F0911R1Account Reconciliations Header - OneWorld ONLY7GLCOCompanyStringGeneric Edit50
147F0911Z1Journal Entry Transactions - Batch File30VNCOCompanyStringGeneric Edit50
148F0911Z4F0911 Interoperability Table35SZCOCompanyStringGeneric Edit50
149F0912Cost Allocations/Flex Budgeting16RJCOCompanyStringGeneric Edit50
150F09123Advanced Variable Numerator4VNCOCompanyStringGeneric Edit50
151F0912AIndex Computation Entry File12RICOCompanyStringGeneric Edit50
152F0912BVariable Allocation File10R#COCompanyStringGeneric Edit50
153F0917Bank Statement Detail24GDCOCompanyStringGeneric Edit50
154F09218Online Consolidations Set-up File1LSCOCompanyStringGeneric Edit50
155F09522Cash Forecast Data10FDCOCompanyStringGeneric Edit50
156F09617Auto Bank Statement Detail11GMCOCompanyStringGeneric Edit50
157F09628Auto Bank Statement Account Setup4GACOCompanyStringGeneric Edit50
158F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY17GLCOCompanyStringGeneric Edit50
159F09UI008Global Business Unit Change9GMCOCompanyStringGeneric Edit50
160F09UI010WorkFile for R09701111WFCOCompanyStringGeneric Edit50
161F09UI013Company by Batch Out of Balance3GLCOCompanyStringGeneric Edit50
162F09UI014Annual Close Work Table5GBCOCompanyStringGeneric Edit50
163F09UI015Indexed Computations Multi-Tiered Entries13GLCOCompanyStringGeneric Edit50
164F09UI016Account Balance Compare Exceptions16GWCOCompanyStringGeneric Edit50
165F09UI017Cash Forecast Detail18FWCOCompanyStringGeneric Edit50
166F09UI123Advanced Variable Numerator Worktable13VWCOCompanyStringGeneric Edit50
167F52G02Burdening Summarized Ledger14BSCOCompanyStringGeneric Edit50
168F52G11Burdening Detail Ledger9BDCOCompanyStringGeneric Edit50
169F52G11WFTemporary Burdened Detail Ledger Workfile9BWCOCompanyStringGeneric Edit50
170F70UI001Work File for G/L by Cat. Code Localization1WACOCompanyStringGeneric Edit50
171F740911Work File for G/L Report by Category Code Localization1WACOCompanyStringGeneric Edit50
TOP09E: Expense Reimbursment
172F20111Expense Report Header32EHCOCompanyStringGeneric Edit50
173F20112Expense Report Detail68EDCOCompanyStringGeneric Edit50
TOP10: Financial Reporting
174F0050BBusiness Unit Structure Build File49MACOCompanyStringGeneric Edit50
175F1001Multi-Site Consolidation Transfer File Header15GPCOCompanyStringGeneric Edit50
176F1001Z1Unedited MSC Interoperability Header Table25IACOCompanyStringGeneric Edit50
177F100901Level of Detail4FRCOCompanyStringGeneric Edit50
178F10471Elimination Rules (OW)4ERCOCompanyStringGeneric Edit50
179F10UI002Dynamically Created Business Units7BUCOCompanyStringGeneric Edit50
180F10UI003Dynamically Created Accounts5ACCOCompanyStringGeneric Edit50
TOP11: Multi Currency
181F1114Company Conversions Parameter File2C2COCompanyStringGeneric Edit50
182F11UI001Load Domestic Currency Codes - A/R Work File2LCCOCompanyStringGeneric Edit50
TOP12: Fixed Assets
183F12002Default Accounting Constants1FDCOCompanyStringGeneric Edit50
184F12003Default Depreciation Constants1FFCOCompanyStringGeneric Edit50
185F1201Asset Master File1FACOCompanyStringGeneric Edit50
186F1201PAsset Master Purge Table1FACOCompanyStringGeneric Edit50
187F1201Z1Unedited Asset Master Transactions14FACOCompanyStringGeneric Edit50
188F1202Asset Account Balances File7FLCOCompanyStringGeneric Edit50
189F1202PAsset Account Balances Purge Table7FLCOCompanyStringGeneric Edit50
190F12141Disposal Account Rule Table1DTCOCompanyStringGeneric Edit50
191F12911ERPost G/L to FA Exceptions Work File8GLCOCompanyStringGeneric Edit50
TOP13: Plant/Equipment Management
192F1302Rental Rules1FKCOCompanyStringGeneric Edit50
193F1303Billing Exception Days1FJCOCompanyStringGeneric Edit50
194F1305Equipment Distribution Rules1FVCOCompanyStringGeneric Edit50
TOP13E: Equipment Cost Analysis
195F1381Equipment Analysis Filters4EFCOCompanyStringGeneric Edit50
196F1382Equipment Analysis Listing8ELCOCompanyStringGeneric Edit50
197F1383Equipment Analysis Costs17ECCOCompanyStringGeneric Edit50
198F1385Equipment Analysis Rules2ERCOCompanyStringGeneric Edit50
TOP14: Modeling - Planning & Budgeting
199F1403Forecast Basis7BDCOCompanyStringGeneric Edit50
200F1404Forecast Results - Header7BYCOCompanyStringGeneric Edit50
201F14041Forecast Results - Detail7BZCOCompanyStringGeneric Edit50
TOP15: Property Management
202F1501Tenant/Lease Master66NECOCompanyStringGeneric Edit50
203F15017Lease Master Detail29NWCOCompanyStringGeneric Edit50
204F1501BLease Master Header38NECOCompanyStringGeneric Edit50
205F1506Floor Master15OPCOCompanyStringGeneric Edit50
206F1507Unit Master53NHCOCompanyStringGeneric Edit50
207F1510Property Management Constants1OECOCompanyStringGeneric Edit50
208F1510BReal Estate Management Constants1OECOCompanyStringGeneric Edit50
209F1511Tenant/Lease Billings Detail17NJCOCompanyStringGeneric Edit50
210F1511BLease Billings Master17NJCOCompanyStringGeneric Edit50
211F1511HTenant/Lease Billings Detail History17N#COCompanyStringGeneric Edit50
212F1511HBLease Billings History17NCCOCompanyStringGeneric Edit50
213F1532BExpense Participation Audit File16NTCOCompanyStringGeneric Edit50
214F1541Tenant Sales History9N8COCompanyStringGeneric Edit50
215F15410Tenant Weekly Sales11N9COCompanyStringGeneric Edit50
216F1541BTenant Sales History10N8COCompanyStringGeneric Edit50
217F1541BWSales History Work File12OWCOCompanyStringGeneric Edit50
218F1542Projected Sales11OJCOCompanyStringGeneric Edit50
219F1543BTenant Sales Analysis Reporting File11OACOCompanyStringGeneric Edit50
220F15525WPM Statements Credit/Cash Build Workfile4RTCOCompanyStringGeneric Edit50
221F1565Security Deposit Master3JFCOCompanyStringGeneric Edit50
222F159071Market/Potential/Renewal Rent Master1NYCOCompanyStringGeneric Edit50
TOP15L: Adv Real Estate Forecasting
223F15L109AREF Budget Results7BRCOCompanyStringGeneric Edit50
224F15L110AREF Account Status36ASCOCompanyStringGeneric Edit50
225F15L301AREF Projected Sales11PSCOCompanyStringGeneric Edit50
TOP16: Profit Management (EPS)
226F1602Cost Analyzer Balances17CBCOCompanyStringGeneric Edit50
227F1602Z1External Cost Analyzer Balances - Interoperability Table39CZCOCompanyStringGeneric Edit50
228F1610Cost Calculation Definitions70CDCOCompanyStringGeneric Edit50
229F1632Driver Balances19CBCOCompanyStringGeneric Edit50
230F1632Z1External Driver Balances-Interoperability Table41CYCOCompanyStringGeneric Edit50
231F1642Rate Master Header File2RHCOCompanyStringGeneric Edit50
TOP17: Customer Service Management
232F1720Contract Header24CHCOCompanyStringGeneric Edit50
233F1721Contract Detail23CDCOCompanyStringGeneric Edit50
234F4801Z2Warranty Claim/Supplier Recovery processing32WSCOCompanyStringGeneric Edit50
TOP17C: Call Management
235F1755Case Master116ZACOCompanyStringGeneric Edit50
236F1760Time Entry91ZBCOCompanyStringGeneric Edit50
237F1797S/WM Address Book Information51CSCOCompanyStringGeneric Edit50
TOP18: Resource Scheduling
238F186602Labor Rules Tag File21TFCOCompanyStringGeneric Edit50
TOP31: Shop Floor Control
239F31UI802Accumulate Amounts by Account10WGCOCompanyStringGeneric Edit50
240F31UI803Work File for Summarizing Journal Entries10SGCOCompanyStringGeneric Edit50
TOP31B: Blend Management
241F31BAAIBlend Automatic Accounting Instructions2BLCOCompanyStringGeneric Edit50
TOP32: Configuration Management
242F3201Configurator Master Table12CMCOCompanyStringGeneric Edit50
243F32019Configurator Master History Table12CHCOCompanyStringGeneric Edit50
TOP36: Forecasting
244F3400Forecast Summary File13SGCOCompanyStringGeneric Edit50
TOP38: Agreement Management
245F38001Agreement Constants1DCCOCompanyStringGeneric Edit50
246F38111Agreements Transaction Ledger8DZCOCompanyStringGeneric Edit50
TOP39: Advanced Stock Valuation
247F3904Item Pool Valuation Master1PLCOCompanyStringGeneric Edit50
248F39041Valuation Category Master1VCCOCompanyStringGeneric Edit50
249F39042Company G/L Update Method Master1SCCOCompanyStringGeneric Edit50
250F39061Valuation Period Table7SOCOCompanyStringGeneric Edit50
251F390619Historical Valuation Period Detail Table7SOCOCompanyStringGeneric Edit50
252F39062Valuation Layers Table7STCOCompanyStringGeneric Edit50
253F39063Period Additional Quantity Table6SUCOCompanyStringGeneric Edit50
254F390639Historical Additional Quantity Table6SUCOCompanyStringGeneric Edit50
255F39064Valuation Document Summary Table7DSCOCompanyStringGeneric Edit50
256F390649Historical Valuation Document Summary Table7DSCOCompanyStringGeneric Edit50
257F3908Item Pool Valuation Cost Master2CSCOCompanyStringGeneric Edit50
258F3910G/L Adjustment Table2SCCOCompanyStringGeneric Edit50
259F39120Temporary Period Build File for Stock Valuation1TFCOCompanyStringGeneric Edit50
260F39120WPeriod Detail Work File2TWCOCompanyStringGeneric Edit50
261F39121WAdditional Quantity Work File2AQCOCompanyStringGeneric Edit50
262F39122Company and Unique Key ID From Extracted F41111SVCOCompanyStringGeneric Edit50
TOP40: Inventory/OP Base
263F3462Forecast Shipment Summary5MBCOCompanyStringGeneric Edit50
264F4001ZBatch Receiver File - Order Headings29SYCOCompanyStringGeneric Edit50
265F4011ZBatch Receiver File - Order Details20SZCOCompanyStringGeneric Edit50
266F4095Distribution/Manufacturing - AAI Values2MLCOCompanyStringGeneric Edit50
267F4201Z1Sales Order Header Unedited Transaction File19SYCOCompanyStringGeneric Edit50
268F4211AUSales Order Detail Audit File4AUCOCompanyStringGeneric Edit50
269F4211Z1Sales Order Detail Unedited Transaction File20SZCOCompanyStringGeneric Edit50
TOP41: Inventory Management
270F41131Stranded Hard Commitments Table10IUCOCompanyStringGeneric Edit50
271F4118Container Deposit File5CNCOCompanyStringGeneric Edit50
272F41181Container Transaction File5CMCOCompanyStringGeneric Edit50
273F41185Container Reconciliation File4CTCOCompanyStringGeneric Edit50
TOP41F: Apparel Management
274FCW65Work Order Header for Style Items14OFCOCompanyStringGeneric Edit50
TOP42: Sales Management
275F4201Sales Order Header File6SHCOCompanyStringGeneric Edit50
276F42019Sales Order Header History File6SHCOCompanyStringGeneric Edit50
277F4211Sales Order Detail File7SDCOCompanyStringGeneric Edit50
278F42119Sales Order History File7SDCOCompanyStringGeneric Edit50
279F42140Customer Master Commission Information2CMCOCompanyStringGeneric Edit50
280F42199S.O. Detail Ledger File7SLCOCompanyStringGeneric Edit50
281F42565Invoice Print File15IWCOCompanyStringGeneric Edit50
282F42800GSales Update G Batch Workfile40SGCOCompanyStringGeneric Edit50
283F42800G1Sales Update G Batch Detail Workfile50DGCOCompanyStringGeneric Edit50
284F42UI01SO Header Cache File (MBF)11ZHCOCompanyStringGeneric Edit50
285F42UI11SO Detail Cache File (MBF)11ZDCOCompanyStringGeneric Edit50
286F42UI521Pick Slips Detail File7S9COCompanyStringGeneric Edit50
287F42UI800Sales Detail Work File - Sales Update73SDCOCompanyStringGeneric Edit50
TOP43: Procurement
288F40910Commitment Integrity Report Work File13P#COCompanyStringGeneric Edit50
289F4095TEMF4095 Temporary Table2MLCOCompanyStringGeneric Edit50
290F4303Log Master21PKCOCompanyStringGeneric Edit50
291F4305Log Master29PLCOCompanyStringGeneric Edit50
292F43080Approvals Fields Constants17PDCOCompanyStringGeneric Edit50
293F4311Purchase Order Detail File7PDCOCompanyStringGeneric Edit50
294F4311ZPurchase Order Generator File11PWCOCompanyStringGeneric Edit50
295F4311Z1Purchase Order Detail Unedited Transaction Table20SZCOCompanyStringGeneric Edit50
296F43121Purchase Order Receiver File46PRCOCompanyStringGeneric Edit50
297F43121ZReceiver workfile75PWCOCompanyStringGeneric Edit50
298F43121Z1Receipts Unedited Transaction Table63SZCOCompanyStringGeneric Edit50
299F43147Freight Distribution Workfile19FDCOCompanyStringGeneric Edit50
300F4314ZVoucher Match Selection File145PNCOCompanyStringGeneric Edit50
301F4316Purchase Order Multiple Account File19P3COCompanyStringGeneric Edit50
302F4317Purchase Order Detail Non-Billable11PDCOCompanyStringGeneric Edit50
303F43199P.O. Detail Ledger File - Flexible Version7OLCOCompanyStringGeneric Edit50
304F4322Purchasing Tolerance Rules4PZCOCompanyStringGeneric Edit50
305F4340Purchase Rebate Master File3RDCOCompanyStringGeneric Edit50
306F4343Purchase Rebate History10RHCOCompanyStringGeneric Edit50
307F44445ZSubcontractor Waiver1SWCOCompanyStringGeneric Edit50
TOP43B: Voucher Match and Landed Cost
308F43221Rounding Rules1RZCOCompanyStringGeneric Edit50
TOP43E: Requisition Self Service
309F43E16Requisition Multiple Account File20P3COCompanyStringGeneric Edit50
TOP44H: Homebuilder Management
310F4453Lot Master (World)14JBCOCompanyStringGeneric Edit50
311F44H001HomeBuilder Constants1HCCOCompanyStringGeneric Edit50
312F44H0011HomeBuilder Constants Lot Start Documents1LDCOCompanyStringGeneric Edit50
313F44H201Lot Master109LMCOCompanyStringGeneric Edit50
314F44H201HLot Master History110LMCOCompanyStringGeneric Edit50
315F44H201ZHB Lot Master Unedited Transaction File122SZCOCompanyStringGeneric Edit50
316F44H501SSales Statistics History8SSCOCompanyStringGeneric Edit50
317F44H501WSales Statistics Work Table9SSCOCompanyStringGeneric Edit50
TOP45: Advanced Pricing
318F4510Price Workbench Query Header9PWCOCompanyStringGeneric Edit50
319F4511WPricing Structure View99APCOCompanyStringGeneric Edit50
320F45520Price List Header3PHCOCompanyStringGeneric Edit50
321F4574Key Reference Table76KRCOCompanyStringGeneric Edit50
322F4575Ship and Debit History58AHCOCompanyStringGeneric Edit50
323F4575TMPShip and Debit History - Temp Table58AHCOCompanyStringGeneric Edit50
324F4576Ship and Debit Claims86ACCOCompanyStringGeneric Edit50
325F4576TMPShip and Debit Claims- Temp Table86ACCOCompanyStringGeneric Edit50
326F4576Z1Ship and Debit Claims Unedited Transaction Table83Z1COCompanyStringGeneric Edit50
TOP47: Electronic Commerce
327F47011EDI Purchase Order Header - Inbound24SYCOCompanyStringGeneric Edit50
328F47012EDI Purchase Order Detail - Inbound21SZCOCompanyStringGeneric Edit50
329F47017EDI Purchase Order Detail - Outbound21SZCOCompanyStringGeneric Edit50
330F47022EDI P.O. Acknowledgment Detail - Inbound21SZCOCompanyStringGeneric Edit50
331F47026EDI P.O. Acknowledgment Header - Outbound21SYCOCompanyStringGeneric Edit50
332F47027EDI P.O. Acknowledgment Detail - Outbound21SZCOCompanyStringGeneric Edit50
333F47032EDI Shipping Notice Detail - Inbound24SZCOCompanyStringGeneric Edit50
334F47037EDI Shipping Notice Detail - Outbound24SZCOCompanyStringGeneric Edit50
335F470371EDI Shipping Notice Detail - Outbound24SZCOCompanyStringGeneric Edit50
336F47041EDI Invoice Header - Inbound15SYCOCompanyStringGeneric Edit50
337F47042EDI Invoice Detail - Inbound16SZCOCompanyStringGeneric Edit50
338F47044EDI Invoice Summary - Inbound15SWCOCompanyStringGeneric Edit50
339F47046EDI Invoice Header (Sales) - Outbound21SYCOCompanyStringGeneric Edit50
340F47047EDI Invoice Detail (Sales) - Outbound21SZCOCompanyStringGeneric Edit50
341F47056EDI Payment Order Header - Outbound18D1COCompanyStringGeneric Edit50
342F470561EDI Payment Order Bank N & A - Outbound13D2COCompanyStringGeneric Edit50
343F470561WEDI Payment Order Bank N & A - Work15D2COCompanyStringGeneric Edit50
344F470562EDI Payment Order Vendor N & A - Outbound12D4COCompanyStringGeneric Edit50
345F470562WEDI Payment Order Vendor N & A - Work12D4COCompanyStringGeneric Edit50
346F470563EDI Payment Order Payee N & A - Outbound12D5COCompanyStringGeneric Edit50
347F470563WEDI Payment Order Payee N & A - Work12D5COCompanyStringGeneric Edit50
348F47056WEDI Payment Order Header - Work18D1COCompanyStringGeneric Edit50
349F47057EDI Payment Order Remittance Advice - Outbound18D3COCompanyStringGeneric Edit50
350F47057WEDI Payment Order Remittance Advice - Work18D3COCompanyStringGeneric Edit50
351F47072EDI Receiving Advice Detail - Inbound22SZCOCompanyStringGeneric Edit50
352F47077EDI Receiving Advice Detail - Outbound22SZCOCompanyStringGeneric Edit50
353F47091EDI Request for Quote Header - Inbound24SYCOCompanyStringGeneric Edit50
354F47092EDI Request for Quote Detail - Inbound21SZCOCompanyStringGeneric Edit50
355F47097EDI Request for Quote Detail - Outbound21SZCOCompanyStringGeneric Edit50
356F47102EDI Response to RFQ Detail - Inbound21SZCOCompanyStringGeneric Edit50
357F47106EDI Response to RFQ Header - Outbound21SYCOCompanyStringGeneric Edit50
358F47107EDI Response to RFQ Detail - Outbound21SZCOCompanyStringGeneric Edit50
359F47114EDI Lockbox/Payment Detail - Payment27Z4COCompanyStringGeneric Edit50
360F47131EDI Purchase Order Change Header - Inbound21SYCOCompanyStringGeneric Edit50
361F47132EDI Purchase Order Change Detail - Inbound22SZCOCompanyStringGeneric Edit50
362F47137EDI Purchase Order Change Detail - Outbound22SZCOCompanyStringGeneric Edit50
363F47142EDI P.O. Change Acknowledgment Detail - Inbound23SZCOCompanyStringGeneric Edit50
364F47146EDI P.O. Change Acknowledgment Header - Outbound22SYCOCompanyStringGeneric Edit50
365F47147EDI P.O. Change Acknowledgment Detail - Outbound23SZCOCompanyStringGeneric Edit50
366F47157EDI Shipping Schedule Detail - Outbound21SZCOCompanyStringGeneric Edit50
367F4722EDI Tolerance Rules4PZCOCompanyStringGeneric Edit50
TOP48: Work Order Processing
368F4801Work Order Master File13WACOCompanyStringGeneric Edit50
369F4801SPurge - Work Order Master file13WACOCompanyStringGeneric Edit50
370F4801Z1Outbound Work Order Header32SYCOCompanyStringGeneric Edit50
371F48UI001X4801 Master Business Function Workfile16WACOCompanyStringGeneric Edit50
TOP48S: Service Billing
372F48091CIndependent Revenue/Invoice Company Exception1CECOCompanyStringGeneric Edit50
373F4812Billing Detail Workfile20WDCOCompanyStringGeneric Edit50
374F4812HBilling Workfile History20WDCOCompanyStringGeneric Edit50
375F4812HSBilling Workfile History Purged Save20WDCOCompanyStringGeneric Edit50
376F4822Invoice Summary Work File17W4COCompanyStringGeneric Edit50
377F4823Voucher Summary15W0COCompanyStringGeneric Edit50
378F48S0618Payroll Reclassification Workfile7YTCOCompanyStringGeneric Edit50
379F48S910Billing Detail Journal Workfile7W2COCompanyStringGeneric Edit50
380F48S911Summarized Journal Workfile6W3COCompanyStringGeneric Edit50
381F48SUI01Billing Detail Print Workfile20WDCOCompanyStringGeneric Edit50
382F48SUI02Load domestic currency code - Billing System2WDCOCompanyStringGeneric Edit50
TOP49: Transportation Management
383F49110Transportation Bill of Lading Workfile29BWCOCompanyStringGeneric Edit50
384F49130Shipment Document Workfile33BWCOCompanyStringGeneric Edit50
385F49141Packing List Workfile14PWCOCompanyStringGeneric Edit50
386F49160Document Next Number1NNCOCompanyStringGeneric Edit50
387F49197Depot Document Print Set Up (Conversion from World File)11OQCOCompanyStringGeneric Edit50
388F49198Depot Document Print Setup13OQCOCompanyStringGeneric Edit50
389F49592Document Print Batch Document Header10DHCOCompanyStringGeneric Edit50
390F49594Document Print - Document Detail14DICOCompanyStringGeneric Edit50
391F49595Document Print - Document Summary3DKCOCompanyStringGeneric Edit50
392F49695Document Register1DRCOCompanyStringGeneric Edit50
393F49696Document Register Detail1DJCOCompanyStringGeneric Edit50
394F49697Document Register Summary1DNCOCompanyStringGeneric Edit50
395F49T50Order Release Location Staging36LOCOCompanyStringGeneric Edit50
396F49T80Locations Staging Table7LCCOCompanyStringGeneric Edit50
TOP51: Job Costing
397F51911Draw Reporting Master5GKCOCompanyStringGeneric Edit50
398F51911EXDraw Explanation Table3GKCOCompanyStringGeneric Edit50
TOP52: Contract Billing
399F5201Contract Master28G4COCompanyStringGeneric Edit50
400F5202Contract Billing Line Detail22G6COCompanyStringGeneric Edit50
401F5280WContract Revenue Summary Work File27GYCOCompanyStringGeneric Edit50
TOP52G: Government Contracting
402F4822HInvoice Summary History17IHCOCompanyStringGeneric Edit50
403F52G01MProject and Government Contract Modifications33CMCOCompanyStringGeneric Edit50
TOP53: Change Management
404F5301BChange Request Master Table3DICOCompanyStringGeneric Edit50
405F5301BZ1Change Request Master Table Workfile7DICOCompanyStringGeneric Edit50
406F5311Change Request Details Table5DKCOCompanyStringGeneric Edit50
407F5311Z1Change Request Details Table Workfile7DKCOCompanyStringGeneric Edit50
408F5314Planned Change Order Master Table3D2COCompanyStringGeneric Edit50
409F5315Change Order Master Table3D3COCompanyStringGeneric Edit50
TOP54HS: Health & Safety Incident Mgt
410F54HS01Incident Master25S1COCompanyStringGeneric Edit50
411F54HS01MIncident Master Change History28I1COCompanyStringGeneric Edit50
412F54HS20Safety Hours3SHCOCompanyStringGeneric Edit50
TOP57: Reserved for Clients
413F74T190Check/Draft Book Seq Number1SNCOCompanyStringGeneric Edit50
414F74T550General Ledger Work File - Turkish5DKCOCompanyStringGeneric Edit50
415F74T550BGeneral Ledger PO Work File - Turkish9POCOCompanyStringGeneric Edit50
416F74T133Customer Year End Table3CTCOCompanyStringGeneric Edit50
417F74T134Supplier Year End Table3STCOCompanyStringGeneric Edit50
TOP70: Multi-National Products - obsolete-do not reuse
418F700050Bank Connection for Legal Documents - COMM - 002BCCOCompanyStringGeneric Edit50
419F702018Taxes by Sales Order Line - COMM - 429TACOCompanyStringGeneric Edit50
420F704001Payment WH Info TEMP - COMM - 0415PTCOCompanyStringGeneric Edit50
421F704002Payment WH Info - COMM - 0414PFCOCompanyStringGeneric Edit50
422F704002PPayment WH Info Purge - COMM - 0414PFCOCompanyStringGeneric Edit50
423F704003Payment Done - Accum - COMM - 042PDCOCompanyStringGeneric Edit50
424F70404G/L Registration Balance - 093Z7COCompanyStringGeneric Edit50
TOP74: EMEA Localization
425F0018TIntrastat Revision8TDCOCompanyStringGeneric Edit50
426F00900Year-End VAT Revision - Italy1IRCOCompanyStringGeneric Edit50
427F7400010Company Aditional Information - COMM - 001LCCOCompanyStringGeneric Edit50
428F740018DData extraction ESL - 746DECOCompanyStringGeneric Edit50
429F740018OOriginal Transaction Detail for Data Extraction8OTCOCompanyStringGeneric Edit50
430F740018WData extraction ESL - Workfile - 746DECOCompanyStringGeneric Edit50
431F74092IVA Balances History - Italy1HBCOCompanyStringGeneric Edit50
432F74093Worktable for Printing IVA Summary - Italy1HCCOCompanyStringGeneric Edit50
433F7420018Taxes by Sales Order Line - COMM - 427STCOCompanyStringGeneric Edit50
434F7430018Taxes by A/R Invoice Line - COMM - 03B7TICOCompanyStringGeneric Edit50
435F74411Withholding Tax Detail - Italy23RSCOCompanyStringGeneric Edit50
436F74412Customer / Supplier Balance Worktable (A/P and A/R)3RPCOCompanyStringGeneric Edit50
437F74413VAT Ceiling Limit-Italy1VCCOCompanyStringGeneric Edit50
438F74900Foreign Receivables and Payables - EMEA20RPCOCompanyStringGeneric Edit50
439F749111Account Group Detail- EMEA - 746AGCOCompanyStringGeneric Edit50
440F74UI91WF - Account Detail - EMEA - 748ADCOCompanyStringGeneric Edit50
441F74UI93WF - Cost Center Detail - EMEA - 747CDCOCompanyStringGeneric Edit50
442F74UI94WF - Cost Center Detail by Company - EMEA - 742CCCOCompanyStringGeneric Edit50
TOP74B: Begium Localization
443F74B010Company Additional Info - Belgium - 74B1CCCOCompanyStringGeneric Edit50
444F74B200Yearly/Quarterly VAT Listing - Belgium11VTCOCompanyStringGeneric Edit50
445F74B250History VAT Listing - BEL - 009CPCOCompanyStringGeneric Edit50
TOP74H: Hungary
446F741201Accumulated Depreciation Asset Column Setup - HUN - 741CSCOCompanyStringGeneric Edit50
447F741202Work File Accumulated Asset Movement Dep - HUN - 749WFCOCompanyStringGeneric Edit50
448F74H1004VAT Declaration Detail - HUN -0414VDCOCompanyStringGeneric Edit50
449F74H309Gains & Losses Unrealized Account ing - HUN - 03B15GLCOCompanyStringGeneric Edit50
450F74H409A/P Gains & Losses Unrealized Accounting - HUN - 0415GLCOCompanyStringGeneric Edit50
451F74H910JE VAT Differences - HUN - 097VDCOCompanyStringGeneric Edit50
TOP74P: Poland
452F74902TAccount Balance Tag File - COM - 09 - 74P38ATCOCompanyStringGeneric Edit50
453F74P03BWA/R Trial Balance - POL - 03B - 74P6P3COCompanyStringGeneric Edit50
454F74P04WA/P Trial Balance Work Table - POL - 04 - 74P6P2COCompanyStringGeneric Edit50
TOP74R: CIS
455F74R0018Russian Tax File - 74R40TDCOCompanyStringGeneric Edit50
456F74R311Prepayment Detail Tax File - RUS - 03B39DECOCompanyStringGeneric Edit50
457F74R420Tax Releases - RUS - 0421TRCOCompanyStringGeneric Edit50
458F74R5010Revaluation Code By Class - RUS - 12 - 74R1RCCOCompanyStringGeneric Edit50
459F74R5110F1201 Tag File - RUS - 12 - 74R1TFCOCompanyStringGeneric Edit50
460F74R9002Correspondence Balance - RUS- 09 - 74R8GBCOCompanyStringGeneric Edit50
461F74R9011Correspondence Rules - RUS -09 - 74R31CRCOCompanyStringGeneric Edit50
462F74R9029Open Accounts - RUS - 09 - 74R5OACOCompanyStringGeneric Edit50
TOP74S: Spain
463F74S0010Company Tag File - Spain - 091CCCOCompanyStringGeneric Edit50
464F74S71Model 347 - Record Type 1 - Spain - 03B23Q1COCompanyStringGeneric Edit50
465F74S72Model 347 - Record Type 2 - Spain17Q2COCompanyStringGeneric Edit50
466F74S73Model 347 - Record Type 3 - Spain20Q3COCompanyStringGeneric Edit50
467F74S79Model 347 - Record Type 2 - Spain Tag File9TQCOCompanyStringGeneric Edit50
468F74S91Model 349 - Record Type 1 - Spain - 03B20Q1COCompanyStringGeneric Edit50
469F74S92Model 349 - Record Type 2 Spain - 03B17Q2COCompanyStringGeneric Edit50
TOP74U: United Kingdom Localizations
470F74U0101CIS Company Constants - 041SCCOCompanyStringGeneric Edit50
471F74U0102Tax Payment Voucher Constants - 041VCCOCompanyStringGeneric Edit50
472F74U0111CIS Company Constants 2007 Update - UK - 041CCCOCompanyStringGeneric Edit50
473F74U0201Property Company Constants - 151P1COCompanyStringGeneric Edit50
474F74U0401SPC - Constants - UK - 431SACOCompanyStringGeneric Edit50
475F74U0402CIS - Supp Constants - UK - 041SBCOCompanyStringGeneric Edit50
476F74U0405SPC Certificate Holding Table - UK - 4318CHCOCompanyStringGeneric Edit50
477F74U0420SPC - Application Master - UK - 4314SECOCompanyStringGeneric Edit50
478F74U0425SPC - Certificate Master - UK - 4315SFCOCompanyStringGeneric Edit50
479F74U4051Header - CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
480F74UUI51Header - XML Work File CIS Monthly Return - UK - 042HMCOCompanyStringGeneric Edit50
TOP74Y: Italy - Reporting System Only
481F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B10TICOCompanyStringGeneric Edit50
482F74Y020Italy Intrastat Declarations - Header - ITA - 005IHCOCompanyStringGeneric Edit50
483F74Y050Third party Black List Amounts - IT - 003THCOCompanyStringGeneric Edit50
TOP74Z: Czech Republic
484F74Z0010Cash Desk Document Printed - CZE - 74Z3ZOCOCompanyStringGeneric Edit50
485F74ZUI02Czech VAT Report - CZE - 74Z - Work File8CZCOCompanyStringGeneric Edit50
TOP75A: Australia - Reporting System Only
486F75A0010Australian Employee Termination Details83A0COCompanyStringGeneric Edit50
487F75A0301Superannuation Payment3SACOCompanyStringGeneric Edit50
488F75A0404Australia State Payroll Tax Company Group Members4ZMCOCompanyStringGeneric Edit50
489F75A0406Australia State Payroll Taxable Wages History1ZHCOCompanyStringGeneric Edit50
490F75A0407Australia State Payroll Tax Liability History1TLCOCompanyStringGeneric Edit50
491F75A9096Australian/New Zealand company constants1ZCCOCompanyStringGeneric Edit50
TOP75C: China - Reporting System Only
492F75C004Report Item - Natural Account Mapping4RNCOCompanyStringGeneric Edit50
493F75C006Natural Account Structure Set Up1NACOCompanyStringGeneric Edit50
494F75C007China - Chart of Accounts Set Up1CACOCompanyStringGeneric Edit50
495F75C008Employee Record Information - China13EMCOCompanyStringGeneric Edit50
496F75C009GL Basic Information - China1BICOCompanyStringGeneric Edit50
497F75C010WAP & AR XML Workfile - China -75C1AACOCompanyStringGeneric Edit50
498F75C014AP/AR Balances - China1BACOCompanyStringGeneric Edit50
499F75C015Cash Flow Data - China7CFCOCompanyStringGeneric Edit50
500F75C204Asset Master History File - CHINA1AHCOCompanyStringGeneric Edit50
501F75C504Payroll Category - CHINA3PCCOCompanyStringGeneric Edit50
502F75C910China Reports Balance -CNAO V21CFCOCompanyStringGeneric Edit50
503F75C911CNAO - E1 Document Number mapping - China1DNCOCompanyStringGeneric Edit50
504F75CUI04China CNAO V2 Fixed Asset XML Work File - CHINA1WFCOCompanyStringGeneric Edit50
505F75CUI05AP & AR Multiple Period XML Workfile - China -75C1MPCOCompanyStringGeneric Edit50
TOP75I: India
506F75I017Sales Order Tag File IND 429SOCOCompanyStringGeneric Edit50
507F75I100TDS Ceritificate Master Maintenance1QBCOCompanyStringGeneric Edit50
508F75I100QTDS Form 26Q - WorkFile (Quarterly)1EFCOCompanyStringGeneric Edit50
509F75I100WTDS Form 26 - WorkFile1EFCOCompanyStringGeneric Edit50
510F75I101TDS Certificate Work Maintenance1QBCOCompanyStringGeneric Edit50
511F75I102TDS Certificate Master Maintenance -Tag File1QBCOCompanyStringGeneric Edit50
512F75I103TDS / TCS Acknowledgement Number1TACOCompanyStringGeneric Edit50
513F75I104TDS Certificate Master Maintenance Tag File1TDCOCompanyStringGeneric Edit50
514F75I15ATDS Document Company Maintenance File1QCCOCompanyStringGeneric Edit50
515F75I20ATDS Document Company1QDCOCompanyStringGeneric Edit50
516F75I2241WorkFile for VAT/CST Receivables2VCCOCompanyStringGeneric Edit50
517F75I322Excise - Work File for F04211 & F41019Q3COCompanyStringGeneric Edit50
518F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)9Q3COCompanyStringGeneric Edit50
519F75I324Work File for ARE1 ARE3 IND 4211Q3COCompanyStringGeneric Edit50
520F75I331Customer Master Tagfile - IND - 03B2AICOCompanyStringGeneric Edit50
521F75I401Sales Form Information-IND-4211QACOCompanyStringGeneric Edit50
522F75I401CSales Form Information- Secondary3QACOCompanyStringGeneric Edit50
523F75I402Purchase Tax Form Details24PTCOCompanyStringGeneric Edit50
524F75I402TPurchase Tax Form Details -Secondary31PTCOCompanyStringGeneric Edit50
525F75I403Stock Transfer Details8ABCOCompanyStringGeneric Edit50
526F75I403TTemp Data for F75i4038ABCOCompanyStringGeneric Edit50
527F75I406State / Branch Plant Cross Reference1SBCOCompanyStringGeneric Edit50
528F75I408VAT/CST Account Master1VCCOCompanyStringGeneric Edit50
529F75I601TCS Register Details-IND-4211TRCOCompanyStringGeneric Edit50
530F75I603TCS Prepayment Master File - IND-03B3TMCOCompanyStringGeneric Edit50
531F75I605TCS Tax Amount1TACOCompanyStringGeneric Edit50
532F75I611TCS Prepayment Transaction File - IND-03B30TTCOCompanyStringGeneric Edit50
533F75I612TCS Prepayment To Tax Authority3TPCOCompanyStringGeneric Edit50
534F75I701Bill of Entry - Header17QHCOCompanyStringGeneric Edit50
535F75IUI01eTCS Anuual Return - Work File4TWCOCompanyStringGeneric Edit50
TOP75J: Japan - Reporting System Only
536F750411Withholding Tax Detail - Japan - 047JXCOCompanyStringGeneric Edit50
537F75J504Setup Rounding Options - 75J - JAP1ROCOCompanyStringGeneric Edit50
TOP75T: Taiwan
538F75T001GUI/VAT Declaration Site - 75T1DSCOCompanyStringGeneric Edit50
539F75T001PGUI/VAT Declaration Period - 75T1DPCOCompanyStringGeneric Edit50
540F75T002GUI/VAT Number Register - 75T9NRCOCompanyStringGeneric Edit50
541F75T0029GUI/VAT Number Register History - 75T9NRCOCompanyStringGeneric Edit50
542F75T003GUI/VAT Number Segment - 75T12NSCOCompanyStringGeneric Edit50
543F75T0039GUI/VAT Number Segment History - 75T12NSCOCompanyStringGeneric Edit50
544F75T004GUI/VAT Transaction Header - 75T3THCOCompanyStringGeneric Edit50
545F75T0049GUI/VAT Transaction Header History - 75T3THCOCompanyStringGeneric Edit50
546F75T004PGUI/VAT Transaction Header POS - 75T5THCOCompanyStringGeneric Edit50
547F75T007GUI/VAT Media Declaration Flat File - 75T1MDCOCompanyStringGeneric Edit50
548F75T0079GUI/VAT Media Declaration Flat File History - 75T1MDCOCompanyStringGeneric Edit50
549F75T009GUI/VAT Customer Constants - 75T2DVCOCompanyStringGeneric Edit50
550F75T010GUI/VAT User / Declaration Site Mapping - 75T5UMCOCompanyStringGeneric Edit50
551F75T013Declaration Site Tax Account Mapping-75T1EACOCompanyStringGeneric Edit50
552F75T014GUI/VAT Number Segment (Batch) Setup - 75T1SBCOCompanyStringGeneric Edit50
553F75T401GUI/VAT Declaration Report 401 - 75T1D1COCompanyStringGeneric Edit50
554F75T403GUI/VAT Declaration Report 403 - 75T1D3COCompanyStringGeneric Edit50
555F75T4031GUI/VAT Declaration Report 403-1 - 75T1A1COCompanyStringGeneric Edit50
556F75T4032GUI/VAT Declaration Report 403-2 - 75T1A2COCompanyStringGeneric Edit50
557F75T42WWork file with union of F4211 and F421195SWCOCompanyStringGeneric Edit50
TOP76A: Argentina
558F76001ANext Number File - ARG - 03B - 76A1NCCOCompanyStringGeneric Edit50
559F760401AGross Income Withholding Percentage - ARG - 04 - 76A1K2COCompanyStringGeneric Edit50
560F760402AV.A.T. withholding percentage - ARG - 04 - 76A1K1COCompanyStringGeneric Edit50
561F760403AProfit Withholding Percentage - ARG - 04 - 76A1K3COCompanyStringGeneric Edit50
562F760404AProfit Withholding Percentage - 4th.Category - ARG - - 76A1K5COCompanyStringGeneric Edit50
563F760405AContract Withholding Percentage - ARG - 04 - 76A1K7COCompanyStringGeneric Edit50
564F760406AProfit Withholding - Payments Done - ARG - 04 - 76A6K6COCompanyStringGeneric Edit50
565F760407AGross Income - State Set Up - ARG - 04 - 76A1K4COCompanyStringGeneric Edit50
566F760409AVoucher Authorization Rules Maintenance - ARG - 04 - 76A2V9COCompanyStringGeneric Edit50
567F760410AEventual Services Withholding Percentage - ARG - 04 - 76A1K0COCompanyStringGeneric Edit50
568F760499AContract Withholding - Advances - ARG -04 - 76A14K8COCompanyStringGeneric Edit50
569F76A003A/P Tag File - CAI Storage - ARG - 04 - 76A1RGCOCompanyStringGeneric Edit50
570F76A005CAI - Invoice range for Preprinters - ARG - 03B1RHCOCompanyStringGeneric Edit50
571F76A0456Security Withholding Payments Done - ARG6X1COCompanyStringGeneric Edit50
572F76A09Invoice Total - ARG - 03B - 76A6TTCOCompanyStringGeneric Edit50
573F76A09PInvoice Total Purge - ARG - 03B - 76A6TTCOCompanyStringGeneric Edit50
574F76A100Autoprinter Supplier Control File - ARG - 04 - 76A1RGCOCompanyStringGeneric Edit50
575F76A1244Fixed Assets by Data Type Record - Anexo A - ARG - 12 - 76A1FQCOCompanyStringGeneric Edit50
576F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 03B - 76A8TOCOCompanyStringGeneric Edit50
577F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A8TOCOCompanyStringGeneric Edit50
578F76A19Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A8TICOCompanyStringGeneric Edit50
579F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A8TICOCompanyStringGeneric Edit50
580F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A26VKCOCompanyStringGeneric Edit50
581F76A20Credit Invoice Constants - ARG - 03B - 76A1ICCOCompanyStringGeneric Edit50
582F76A392Calculated costs header - 76A5C2COCompanyStringGeneric Edit50
583F76A393Calculated costs detail - 76A5C3COCompanyStringGeneric Edit50
584F76A394Adjustments - 76A5C4COCompanyStringGeneric Edit50
585F76A396Item Valuation Cost Master - 76A2CSCOCompanyStringGeneric Edit50
586F76A405Small Contributors that Exceeded the Limit - ARG - 042SECOCompanyStringGeneric Edit50
587F76A42CERG G/L - Work File - ARG - 09 - 76A1TFCOCompanyStringGeneric Edit50
588F76A430Contract Service Withholding - Payments Done - ARG - 041PDCOCompanyStringGeneric Edit50
589F76A715Prenumbered Invoice / Shipment Note Print - ARG - 42 - 76A1PICOCompanyStringGeneric Edit50
590F76A8001Generation SICOREs - Last Step -RG 738/99 - ARG - 04 - 76A25V2COCompanyStringGeneric Edit50
591F76A8011Supplier Information RG 726 - ARG - 04 - 76A1PACOCompanyStringGeneric Edit50
592F76A8051Perceptions Exempt per Company - ARG - 03B - 76A1PECOCompanyStringGeneric Edit50
593F76A8070Profit Withholding - Payments Done - RG 830 - ARG - 0 - 76A6K7COCompanyStringGeneric Edit50
594F76A8080Certificate Next Number RG 738/99- ARG - 04 - 76A1NNCOCompanyStringGeneric Edit50
595F76A8081Company Relation RG 738/99 - ARG - 04 - 76A1CRCOCompanyStringGeneric Edit50
596F76A8090V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76A1VPCOCompanyStringGeneric Edit50
597F76A81A/P Payment Control Group File - ARG - 04 - 76A21C5COCompanyStringGeneric Edit50
598F76A82A/P Payment Control Group File - ARG - 04 - 76A23C6COCompanyStringGeneric Edit50
599F76AUI24Taxes Work File - ARG - 03B - 76A8TICOCompanyStringGeneric Edit50
600F76AUI81Draft - Invoices Work File - ARG - 03B - 76A1WFCOCompanyStringGeneric Edit50
601F76AUI82Draft - Drafts Work File - ARG - 03B - 03B1WFCOCompanyStringGeneric Edit50
602F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A1WFCOCompanyStringGeneric Edit50
603F76AUI84Supplier Without information from Internet - Rg 726 A - 76A2INCOCompanyStringGeneric Edit50
604F76AUI88Work File Last Invoice Number by Month - ARG - 03B - 76A4LICOCompanyStringGeneric Edit50
605F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A4WFCOCompanyStringGeneric Edit50
TOP76B: Brazil - Reporting System Only
606F7601BNota Fiscal Header - BRA - 4211FHCOCompanyStringGeneric Edit50
607F7602BFiscal Book Next Number Control - Brazil - 091NJCOCompanyStringGeneric Edit50
608F76101BNota Fiscal - Header (Fiscal Books) - 428QXCOCompanyStringGeneric Edit50
609F7611BNota Fiscal Detail - BRA - 4221FDCOCompanyStringGeneric Edit50
610F761BAAS Fiscal file book - 0920FBCOCompanyStringGeneric Edit50
611F76B015Legal Company - Subsidiaries - BR - 002LSCOCompanyStringGeneric Edit50
612F76B050Address Book - SPED Project - WF - BRA - 76B5WACOCompanyStringGeneric Edit50
613F76B051Item number - SPED Project - WF - BRA - 76B5WICOCompanyStringGeneric Edit50
614F76B0510Electronic Reporting Process Header - BR -6PHCOCompanyStringGeneric Edit50
615F76B0515Electronic Reporting Constant Setup1CSCOCompanyStringGeneric Edit50
616F76B052Unit of measure - SPED Fiscal Brazilian WF - BRA - 76B5WUCOCompanyStringGeneric Edit50
617F76B053Transaction Nature - SPED Fiscal Brazilian WF - BRA - 76B5WTCOCompanyStringGeneric Edit50
618F76B054Messages Information - SPED Fiscal Brazilian WF - BRA - 76B5WMCOCompanyStringGeneric Edit50
619F76B055Cost Center - SPED Fiscal Brazilian WF - BRA - 76B5WCCOCompanyStringGeneric Edit50
620F76B056Account - SPED Fiscal Brazilian WF - BRA - 76B5WTCOCompanyStringGeneric Edit50
621F76B057Administrative Process - SPED Project - WF - BRA - 76B5WDCOCompanyStringGeneric Edit50
622F76B058Judicial Process- SPED Project - WF - BRA - 76B5WJCOCompanyStringGeneric Edit50
623F76B0590Electronic Reporting - Chart of Accounts3CHCOCompanyStringGeneric Edit50
624F76B0715Ato Cotepe 09 Constant Setup - BR - 001CSCOCompanyStringGeneric Edit50
625F76B0735Ato - Cotepe11 - Block E - Work File5WFCOCompanyStringGeneric Edit50
626F76B0740Ato Cotepe Process - BR - 004PHCOCompanyStringGeneric Edit50
627F76B0770ICMS Period Balance by State and Company1ICCOCompanyStringGeneric Edit50
628F76B0771IPI Period Balance by Company1IPCOCompanyStringGeneric Edit50
629F76B10Account Ledger - IN68 - 091ARCOCompanyStringGeneric Edit50
630F76B11Account Balances - IN68 - 091ABCOCompanyStringGeneric Edit50
631F76B30Nota Fiscal Header/Table for Goods - IN68 - 421MMCOCompanyStringGeneric Edit50
632F76B31Nota Fiscal Detail/Table for Goods - IN68 - 421IMCOCompanyStringGeneric Edit50
633F76B40Nota Fiscal Header/Table for Services - IN68 - 421MSCOCompanyStringGeneric Edit50
634F76B401DIRF WorkTable - BRA - 76B7DICOCompanyStringGeneric Edit50
635F76B41Nota Fiscal Detail/Table for Services - IN68 - 421ISCOCompanyStringGeneric Edit50
636F76B50Item Ledger Table - IN68 - 421CECOCompanyStringGeneric Edit50
637F76B51Inventory Records Table - IN68 - 421RICOCompanyStringGeneric Edit50
638F76B60Products Table - IN68 - 301PRCOCompanyStringGeneric Edit50
639F76B61Packing and Raw Material Table - IN68 - 301IECOCompanyStringGeneric Edit50
640F76B62Fixed Assets Table - IN68 - 121BICOCompanyStringGeneric Edit50
641F76B63Information for Depreciation on Hold Table - IN68 - 121BDCOCompanyStringGeneric Edit50
642F76B64Balances/JEs w/ Currency Correction Table - IN68 - 121BSCOCompanyStringGeneric Edit50
643F76B8200IN86-Work Table for Fixed Assets - 1226FACOCompanyStringGeneric Edit50
644F76B8602IN86-Work Table for Suppliers and Customers - 0422PRCOCompanyStringGeneric Edit50
645F76B902IN86-Work Table for Account Balance - 0914BCCOCompanyStringGeneric Edit50
646F76B911IN86-Work Table for Journal Entries - 0918BDCOCompanyStringGeneric Edit50
TOP76C: Colombia
647F76C0003VAT Certificates Retention - COL - 76C1CRCOCompanyStringGeneric Edit50
648F76C031AA/R Customer ledger As Of - F76C031A - COL - 0414RPCOCompanyStringGeneric Edit50
649F76C034AA/R Check Detail file As Of - COL - 03B18RZCOCompanyStringGeneric Edit50
650F76C0902Debits and Credits T/B by object account - COL - 76C7GBCOCompanyStringGeneric Edit50
651F76C1201Adjustment By Inflation to the Cost / Deferred Charge - 76C1ACCOCompanyStringGeneric Edit50
652F76C1202Adjustment By Inflation Depreciation/Amortization - C - 76C1ADCOCompanyStringGeneric Edit50
653F76C575Work File Magnetic Media - COL - 045Q1COCompanyStringGeneric Edit50
654F76C9415Workfile for Dialy Book - COL - 092LDCOCompanyStringGeneric Edit50
655F76CT1Tributary Information - COL - 76C5TICOCompanyStringGeneric Edit50
656F76CT2Sales/Use/V.A.T. Tax File - COL - 76C1CTCOCompanyStringGeneric Edit50
657F76CT3VAT Certificates Retention - Work File - COL - 76C1T3COCompanyStringGeneric Edit50
658F76CUI01Account Master - Work File - COL - 76C1GMCOCompanyStringGeneric Edit50
659F76CUI02Tax Detail - Work File - COL - 76C54TDCOCompanyStringGeneric Edit50
660F76CUI03Account Cat. Code - Work File - COL - 76C1GMCOCompanyStringGeneric Edit50
661F76CUI04Tax Detail for Distribution - Work File - COL - 76C55TDCOCompanyStringGeneric Edit50
TOP76E: Ecuador
662F76E4010Withholding Certificate Information - EC - 042CECOCompanyStringGeneric Edit50
TOP76H: Chile
663F76H010Legal Company - CHI - 00 - 76H2LCCOCompanyStringGeneric Edit50
664F76H218Taxes by Sales Order Line - CHI - 42 - 76H10TDCOCompanyStringGeneric Edit50
665F76H902TAccount Balances Tag File - CHI - 09 - 76H38ATCOCompanyStringGeneric Edit50
TOP76M: Mexico
666F76M003Withholding Percentage - MX - 76M1WPCOCompanyStringGeneric Edit50
667F76M005Generic Constants - MX - 76M1GCCOCompanyStringGeneric Edit50
668F76M010Company Additional Info1LRCOCompanyStringGeneric Edit50
669F76M0314Receipt Detail Tag File - Mexico17MACOCompanyStringGeneric Edit50
670F76M0414F0414 - Payment Detail Tag File - Mexico3RTCOCompanyStringGeneric Edit50
671F76M311AR Soft Rounding VAT - Mexico9MBCOCompanyStringGeneric Edit50
672F76M411Soft Rounding VAT Calculation6RSCOCompanyStringGeneric Edit50
673F76M930AR VAT on Gain/loss MEX - 76M17APCOCompanyStringGeneric Edit50
674F76M940AP VAT on Gain/loss - MEX - 76M14APCOCompanyStringGeneric Edit50
675F76M990GL VAT on Gain/loss MEX - 76M15GLCOCompanyStringGeneric Edit50
TOP76P: Peru
676F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P4CZCOCompanyStringGeneric Edit50
677F76P405IGV Withholding Percentage - PER - 04 - 76P1IGCOCompanyStringGeneric Edit50
678F76P410SPOT Withholdings Percentage - PER - 04 - 76P1SPCOCompanyStringGeneric Edit50
679F76P501Default Assets Revaluation Accounts - PER - 12 - 76P1DACOCompanyStringGeneric Edit50
TOP76V: Venezuela
680F76V0401Relation Invoice/Retention Code - VEN - 76V1RECOCompanyStringGeneric Edit50
681F76V4010Tributary Unit Setup - 04 - VE1ISCOCompanyStringGeneric Edit50
682F76V4020ISLR Withholdings Setup - VEN - 041WSCOCompanyStringGeneric Edit50
683F76V4021ISLR Withholdings Setup Tag File - VEN - 041WTCOCompanyStringGeneric Edit50
684F76V4025IM Withholdings Setup - VEN - 041WSCOCompanyStringGeneric Edit50
685F76V4030VAT Withholdings Setup - VEN - 041VWCOCompanyStringGeneric Edit50
686F76V410Tributary Unit Setup - VEN - 041TUCOCompanyStringGeneric Edit50
687F76V4581Withholding Historical File - VEN - 046HRCOCompanyStringGeneric Edit50
688F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 041TDCOCompanyStringGeneric Edit50
689F76VTARTTemporal Table for Withholdings - VEN -04 - 76V1TRCOCompanyStringGeneric Edit50
TOP77: Payroll (Canadian)
690F77100Canadian Year-End Control - F771004J0COCompanyStringGeneric Edit50
691F77173ROE Summary History Work File3JFCOCompanyStringGeneric Edit50
692F77200Canadian Employee Year-End Form Header - F772006J5COCompanyStringGeneric Edit50
693F77201TNegative Amount Print6NACOCompanyStringGeneric Edit50
694F77210Canadian Employee Year-End Form Detail - F722105J6COCompanyStringGeneric Edit50
TOP79A: Greenhouse Gas Accounting
695F79A77GHG Company Constants1CCCOCompanyStringGeneric Edit50
TOP80D: Plant Manager Dashboard
696F80D010Sales Order Fact9SFCOCompanyStringGeneric Edit50
697F80D110PMD Search By Saved Query2SQCOCompanyStringGeneric Edit50
698F80D111FMD Default Search By Query2FQCOCompanyStringGeneric Edit50
699F80D272Most Profitable Customers Aggregate2PCCOCompanyStringGeneric Edit50
700F80D273Most Profitable Products Aggregate2PPCOCompanyStringGeneric Edit50
701F80D274Most Profitable Brands Aggregate2PBCOCompanyStringGeneric Edit50
TOP83: Management Reporting - FASTR
702F83UI001Balance Audit Work File - (Financial Reporting)7R1COCompanyStringGeneric Edit50
TOP89: Conversion Programs
703F42140ACopy from F42140 to Temp Table F42140A2CMCOCompanyStringGeneric Edit50
704F43199ATemp F43199 for ERP 9.0 Upgrade7OLCOCompanyStringGeneric Edit50
705F75I101ATDS Ceritificate Master Tabel Extension1QBCOCompanyStringGeneric Edit50
TOP90CA: CRM Foundation
706F90CA080Customer Table45UUCOCompanyStringGeneric Edit50
707F90CA63EActivity Customer Associative Table (FOR CRM UPGRADE)2ACCOCompanyStringGeneric Edit50
TOP90CB: CRM Sales Force Automation
708F90CB02EOpportunity_Employee Table37OECOCompanyStringGeneric Edit50
TOPF31: Lean Transactions
709FF31011TransactionID Master File37EHCOCompanyStringGeneric Edit50
710FF31011SPurge - TransactionID Master File37ERCOCompanyStringGeneric Edit50
TOPH92: Interactive Engine/OL
711F9890Version Master File3VFCOCompanyStringGeneric Edit50
TOPH95: Tech Resources/Applications
712F00166Media Object Categories15GTCOCompanyStringGeneric Edit50
713F00921User Display Preferences3ULCOCompanyStringGeneric Edit50
714F91300Schedule Job Master30SJCOCompanyStringGeneric Edit50