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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

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