JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

285 columns | Print definition?920 | CRR

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes54TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
2F0087Conversion Constants File for Euro5EUCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
3F0911Account Ledger28GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP03: Accounts Receivable
4F0311Accounts Receivable Ledger33RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
5F0312A/R Batch Cash Application30RUCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP03B: Enhanced Accounts Receivable
6F03B11Customer Ledger34RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
7F03B112Invoice Revisions36RWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
8F03B112PInvoice Revisions Purge File36RWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
9F03B117Revenue Recognition GL Info61RLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
10F03B119Revenue Recognition GL Info Audit60RNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
11F03B11PCustomer Ledger Purge File34RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
12F03B11Z1Batch Invoices51VJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
13F03B11Z2F03B11 Interoperability Table47SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
14F03B13Receipts Header27RYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
15F03B13PReceipts Header Purge File27RYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
16F03B13Z1Electronic Receipts Input36RUCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
17F03B13Z2F03B13 Interoperability Table40SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
18F03B14Receipts Detail34RZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
19F03B14PReceipts Detail Purge File34RZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
20F03B14Z2F03B14 Interoperability Table47SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
21F03B22A/R Fee Journal History15RSCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
22F03B23A/R Fee Journal History Detail15RTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
23F03B465A/R Netting Workfile26ROCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
24F03B575Auto Debit Invoice Select and Build37RDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
25F03B672Draft Remittance30RDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
26F09UI011Receipt Prepost Work File21GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP04: Accounts Payable
27F0411Accounts Payable Ledger35RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
28F0411AWF - 'As Of' Accounts Payable Ledger35RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
29F0411PPurge - Accounts Payable Ledger35RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
30F0411Z1Voucher Transactions - Batch Upload53VLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
31F0411Z3F0411 Interoperability Table58SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
32F0414Accounts Payable Matching Document Detail17RNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
33F0414AWF - 'As Of' Accounts Payable Payment Detail17RNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
34F0414PPurge - Accounts Payable Matching Document Detail17RNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
35F0414Z1F0414 Interoperability Table30SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
36F04572A/P Payment Processing - Summary46KKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
37F04573A/P Payment Processing - Detail14KICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
38F09UI005Tax Offsets User Index27GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
39F09UI006Tax (F0018) Replica54TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP05: Time Accounting and HRM Base
40F0618Employee Transaction History113YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP05T: Time Entry
41F06116Employee Transaction Detail File164YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
42F06116Z1Employee Transactions - Batch File177VLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
43F06116Z2ESS Timecard History177VMCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
44F063951Payroll Journal (Compressed) File31GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP06: Payroll (old) - Obsolete-do not reuse
45F0618TATemp table for F0618T for conversion8YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP07: Payroll
46F05290WF - Payroll Journal (Detail)31JRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
47F0716702Employee Assignment Rates10EACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP09: General Accounting
48F0911PPurge - Account Ledger28GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
49F0911Z1Journal Entry Transactions - Batch File45VNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
50F0911Z4F0911 Interoperability Table50SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
51F09UI015Indexed Computations Multi-Tiered Entries28GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP09E: Expense Reimbursment
52F09E150Credit Card Transaction Interface Table17CICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
53F20112Expense Report Detail53EDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP11: Multi Currency
54F0015Currency Exchange Rates9CXCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
55F0015Z1External Currency Exchange Rates31ZECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
56F1113Currency Restatement Rates File5C1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
57F1114Company Conversions Parameter File15C2CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP15: Real Estate Management
58F15012BTenant E.P. Class Master89NSCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
59F15013BSales Overage Master File87NOCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
60F15014BProduct Scales Master51NPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
61F15015BMin/Max Rents And Recoveries Master52NQCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
62F15016BTenant Escalation Master82NUCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
63F15017Lease Master Detail55NWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
64F1501BLease Master Header58NECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
65F1502BRecurring Billings Master82NFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
66F1502WBEstimated EP Recurring Billings46N4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
67F1511Tenant/Lease Billings Detail44NJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
68F1511BLease Billings Master44NJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
69F1511HTenant/Lease Billings Detail History44N#CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
70F1511HBLease Billings History44NCCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
71F1513BFASB 13 Lease Control69O3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
72F151991G/L Transaction A/R Application Work File18NBCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
73F1538BEP Billing Register118NZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
74F1540BSales Report Control49NRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
75F15410Tenant Weekly Sales39N9CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
76F1541BTenant Sales History49N8CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
77F1541BWSales History Work File61OWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
78F1542Projected Sales44OJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
79F1543BTenant Sales Analysis Reporting File77OACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
80F1548BEscalation Billing Register71N1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
81F1565Security Deposit Master27JFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP15L: Adv Real Estate Forecasting
82F15L301AREF Projected Sales47PSCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP17: Customer Service Management
83F1720Contract Header47CHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
84F1721Contract Detail108CDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
85F1775Claim Temporary Table34TCCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
86F4801TZ2Warranty Claim/Supplier Recovery processing106WQCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP17C: Call Management
87F1755Case Master175ZACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
88F1760Time Entry89ZBCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP18: Timecard Automation
89F186602Labor Rules Tag File170TFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP31P: Engineer To Order
90F31P10Project Quote Header9PQCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP39: Advanced Stock Valuation
91F39062Valuation Layers Table21STCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP40: Inventory/OP Base
92F4001ZBatch Receiver File - Order Headings96SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
93F4011ZBatch Receiver File - Order Details208SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
94F4201Z1Sales Order Header Unedited Transaction File85SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
95F4207Price by Item30PMCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
96F4211Z1Sales Order Detail Unedited Transaction File187SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
97F43800Summary Voucher Match19PRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
98F49211Sales Order Detail File - Tag File59UDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
99F49211Z1Sales Order Detail Tag Unedited Transaction File72S1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
100F49219Sales Order Detail - Tag History File59UDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP41: Inventory Management
101F4118Container Deposit File19CNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
102F41181Container Transaction File27CMCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
103F41291ZLanded Cost Cache Table21IGCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP41F: Apparel Management
104FCW38Price List Exchange Rate4TRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
105FCW84Exchange Rate for Outsource Operations4TRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP42: Sales Management
106F4201Sales Order Header File72SHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
107F42019Sales Order Header History File72SHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
108F4211Sales Order Detail File174SDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
109F42119Sales Order History File174SDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
110F42199S.O. Detail Ledger File174SLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
111F42565Invoice Print File88IWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
112F42800GSales Update G Batch Workfile20SGCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
113F42800G1Sales Update G Batch Detail Workfile55DGCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
114F42UI01SO Header Cache File (MBF)77ZHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
115F42UI11SO Detail Cache File (MBF)109ZDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
116F42UI520Pick Slips Header File27S8CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
117F42UI521Pick Slips Detail File118S9CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
118F42UI800Sales Detail Work File - Sales Update15SDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP42B: Sales Order Entry
119F49299S.O. Detail Tag Ledger File59UDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP43: Procurement
120F4301Purchase Order Header69PHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
121F4301ZPO Header Work File73PACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
122F4301Z1Purchase Order Header Unedited Transaction Table82SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
123F43080Approvals Fields Constants167PDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
124F4311Purchase Order Detail File167PDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
125F4311ZPurchase Order Generator File171PWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
126F4311Z1Purchase Order Detail Unedited Transaction Table180SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
127F43121Purchase Order Receiver File87PRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
128F43121ZReceiver workfile60PWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
129F43121Z1Receipts Unedited Transaction Table104SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
130F43147Freight Distribution Workfile32FDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
131F4314ZVoucher Match Selection File187PNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
132F43199P.O. Detail Ledger File - Flexible Version167OLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
133F4343Purchase Rebate History20RHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
134F4371Suggested Reorder Stock Items8PDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
135F43UI50HPO Print Header Work File32PACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP43E: Requisition Self Service
136F43E11Requisition Detail22RDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP43Q: Strategic Sourcing
137F43Q15Event Currencies6ECCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
138F43Q40Response Header11RACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP44H: Homebuilder Management
139F44H601Bid Header43BHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
140F44H611Bid Details69BDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
141F44H611WBid Details Work File73BWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
142F44H711Lot Start Workfile84SWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
143F44H711ZHB Lot Start Unedited Transaction File97SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
144F44H71W1Lot Start Generation Workfile84GWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
145F44H73W1Lot Start - P.O. / Committment Generation Work File54CGCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP45: Advanced Pricing
146F4576Z1Ship and Debit Claims Unedited Transaction Table154Z1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP47: Electronic Commerce
147F47011EDI Purchase Order Header - Inbound83SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
148F47012EDI Purchase Order Detail - Inbound209SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
149F47016EDI Purchase Order Header - Outbound84SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
150F47017EDI Purchase Order Detail - Outbound170SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
151F47021EDI P.O. Acknowledgment Header - Inbound84SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
152F47022EDI P.O. Acknowledgment Detail - Inbound170SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
153F47026EDI P.O. Acknowledgment Header - Outbound79SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
154F47027EDI P.O. Acknowledgment Detail - Outbound209SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
155F47031EDI Shipping Notice Header - Inbound79SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
156F47032EDI Shipping Notice Detail - Inbound110SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
157F47037EDI Shipping Notice Detail - Outbound158SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
158F470371EDI Shipping Notice Detail - Outbound177SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
159F47041EDI Invoice Header - Inbound33SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
160F47042EDI Invoice Detail - Inbound70SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
161F47044EDI Invoice Summary - Inbound36SWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
162F47046EDI Invoice Header (Sales) - Outbound79SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
163F47047EDI Invoice Detail (Sales) - Outbound209SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
164F47056EDI Payment Order Header - Outbound32D1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
165F47056WEDI Payment Order Header - Work32D1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
166F47057EDI Payment Order Remittance Advice - Outbound32D3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
167F47057WEDI Payment Order Remittance Advice - Work32D3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
168F47071EDI Receiving Advice Header - Inbound85SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
169F47072EDI Receiving Advice Detail - Inbound171SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
170F47076EDI Receiving Advice Header - Outbound85SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
171F47077EDI Receiving Advice Detail - Outbound171SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
172F47081EDI Price Sales Catalog Header - Inbound31FVCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
173F47091EDI Request for Quote Header - Inbound83SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
174F47092EDI Request for Quote Detail - Inbound209SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
175F47096EDI Request for Quote Header - Outbound84SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
176F47097EDI Request for Quote Detail - Outbound170SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
177F47101EDI Response to RFQ Header - Inbound84SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
178F47102EDI Response to RFQ Detail - Inbound170SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
179F47106EDI Response to RFQ Header - Outbound79SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
180F47107EDI Response to RFQ Detail - Outbound208SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
181F47113EDI Lockbox/Payment Detail - Batch24Z3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
182F47122EDI Product Activity Data Detail - Inbound66MJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
183F47127EDI Product Activity Data Detail - Outbound66MJCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
184F47131EDI Purchase Order Change Header - Inbound80SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
185F47132EDI Purchase Order Change Detail - Inbound210SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
186F47136EDI Purchase Order Change Header - Outbound84SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
187F47137EDI Purchase Order Change Detail - Outbound171SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
188F47141EDI P.O. Change Acknowledgment Header - Inbound85SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
189F47142EDI P.O. Change Acknowledgment Detail - Inbound172SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
190F47146EDI P.O. Change Acknowledgment Header - Outbound80SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
191F47147EDI P.O. Change Acknowledgment Detail - Outbound211SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
192F47156EDI Shipping Schedule Header - Outbound88SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
193F47157EDI Shipping Schedule Detail - Outbound193SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP48: Work Order Processing
194F4801STPurge - Work Order Master Tag File93WACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
195F4801TWork Order Master Tag File93WACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
196F4817Service Order Extension55SRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP48S: Service Billing
197F4812Billing Detail Workfile110WDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
198F4812HBilling Workfile History110WDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
199F4812HSBilling Workfile History Purged Save110WDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
200F4822Invoice Summary Work File90W4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
201F4823Voucher Summary62W0CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
202F48S0618Payroll Reclassification Workfile113YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
203F48S910Billing Detail Journal Workfile44W2CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
204F48S911Summarized Journal Workfile28W3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
205F48SUI01Billing Detail Print Workfile110WDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP52: Contract Billing
206F5201Contract Master69G4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
207F5202Contract Billing Line Detail74G6CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP52G: Proj & Gov Contract Accounting
208F4822HInvoice Summary History90IHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
209F52G01MAdvanced Contracts Modifications89CMCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP53: Change Management
210F5301BChange Request Master Table43DICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
211F5301BZ1Change Request Master Table Workfile47DICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
212F5311Change Request Details Table142DKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
213F5311Z1Change Request Details Table Workfile147DKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
214F5314Planned Change Order Master Table41D2CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
215F5315Change Order Master Table40D3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP54R: Rental Management
216F54R099Rental Contract Header Ledger75HLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
217F54R10Rental Contract Header73CHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
218F54R11Rental Contract Detail120CDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
219F54R199Rental Contract Detail Ledger116DLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP70: Multi-National Products
220F704001Payment WH Info TEMP - COMM - 0453PTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
221F704002Payment WH Info - COMM - 0452PFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
222F704002PPayment WH Info Purge - COMM - 0452PFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74: EMEA Localization
223F740018DData extraction ESL - 7429DECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
224F740018WData extraction ESL - Workfile - 7429DECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
225F74093Worktable for Printing IVA Summary - Italy53HCCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
226F7430030Legal Document Header (Print Info) - COMM - 03B12PICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
227F74411Withholding Tax Detail - Italy22RSCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
228F74412Customer / Supplier Balance Worktable (A/P and A/R)18RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
229F74900Foreign Receivables and Payables - EMEA41RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74H: Hungary
230F74H309Gains & Losses Unrealized Account ing - HUN - 03B10GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
231F74H409A/P Gains & Losses Unrealized Accounting - HUN - 0410GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74R: Russia
232F74R0018Russian Tax File - 74R46TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
233F74R311Prepayment Detail Tax File - RUS - 03B23DECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
234F74R410Tax on Hold - RUS - 0410THCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74S: Spain
235F74S55Expenses and Exchange Rate for Payments - Spain - 0414Q5CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74U: United Kingdom Localizations
236F74U0212Accounting Billing Profile - 1510P8CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
237F74U0213Weekly Accounting Profile - 1511PWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
238F74U0405SPC Certificate Holding Table - UK - 4316CHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
239F74U0420SPC - Application Master - UK - 4353SECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
240F74U0425SPC - Certificate Master - UK - 4355SFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
241F74U25BTInterest Tag Table - 1512PKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP74W: Sweden
242F74W203Debit Advice Invoice File - 74W7K3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
243F74W210A/P Automatic Payments Spot Rate - 74W5K5CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP75C: China
244F75C001Chinese GUI cross reference file12CRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
245F75C010WAP & AR XML Workfile - China -75C14AACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP75I: India
246F75I701Bill of Entry - Header94QHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP75T: Taiwan
247F75T004GUI/VAT Transaction Header - 75T27THCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
248F75T0049GUI/VAT Transaction Header History - 75T27THCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
249F75T004PGUI/VAT Transaction Header POS - 75T28THCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
250F75T004ZGUI/VAT Transaction Header - Work - 75T25ZHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
251F75T005GUI/VAT Transaction Detail - 75T24TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
252F75T0059GUI/VAT Transaction Detail History - 75T24TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
253F75T005PGUI/VAT Transaction Detail POS - 75T30TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
254F75T005TGUI/VAT Transaction Detail Temp - 75T24TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
255F75T005ZGUI/VAT Transaction Detail - Work - 75T31ZDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
256F75T1113Taiwan Exchange Rate Update5TRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
257F75T42WWork file with union of F4211 and F4211938SWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP76A: Argentina
258F760473APCG Detail Information Tag Table - ARG - 04 - 76A11E5CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
259F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A52HFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
260F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A52HFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
261F76A0440Check details RG 1547 - ARG - 04 - 76A9CDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
262F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A13IHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
263F76A21PCredit Invoice Header Purge - ARG - 03B - 76A13IHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
264F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A8IECRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
265F76A8500Tag File F03B14 - ARG - 03B - 76A18TFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
266F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A52HFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
267F76AUI81Draft - Invoices Work File - ARG - 03B - 76A17WFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
268F76AUI82Draft - Drafts Work File - ARG - 03B - 03B38WFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
269F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A24WFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
270F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A17WFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP76B: Brazil
271F76B473TF04573 Brazilian Temp WH File - BR - 0419W3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP76C: Colombia
272F76C031AA/R Customer ledger As Of - F76C031A - COL - 0433RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
273F76C034AA/R Check Detail file As Of - COL - 03B39RZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP76H: Chile
274F76H218Taxes by Sales Order Line - CHI - 42 - 76H26TDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
275F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H35PICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP76P: Peru
276F76P473TF04573 Tag File - PER - 04 - 76P11K3CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP79A: Greenhouse Gas Accounting
277F79A11GHG Ledger50GRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
278F79A11Z1GHG Ledger - Batch File58GLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
279F79A12GHG Ledger Audit51GRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
280F79AU11GHG Ledger Work Table54GRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
TOP89: Conversion Programs
281F0086Conversion Audit File for Euro Conversion6AUCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
282F06116TNeeded for upgrade from Xe to B911YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
283F06116TZNeeded for upgrade from Xe to B912VLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
284F0618TNeeded for upgrade from Xe to B911YTCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150
285F43199ATemp F43199 for ERP 9.0 Upgrade167OLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150