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

58 columns | Print definition?812 | SFXE

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository8EDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP03B: Enhanced Accounts Receivable
2F03B112Invoice Revisions5RWSFXEPay Item Extension NumberNumericGeneric Edit20
3F03B112PInvoice Revisions Purge File5RWSFXEPay Item Extension NumberNumericGeneric Edit20
TOP04: Accounts Payable
4F0411Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
5F0411AWF - As Of - Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
6F0411PPurge - Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
7F0411Z1Voucher Transactions - Batch File23VLSFXEPay Item Extension NumberNumericGeneric Edit20
8F0411Z3F0411 Interoperability Table27SZSFXEPay Item Extension NumberNumericGeneric Edit20
9F0414Accounts Payable Matching Document Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
10F0414AWF - As Of - Accounts Payable Payment Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
11F0414PPurge - Accounts Payable Matching Document Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
12F0414Z1F0414 Interoperability Table21SZSFXEPay Item Extension NumberNumericGeneric Edit20
13F04573A/P Payment Processing - Detail File26KISFXEPay Item Extension NumberNumericGeneric Edit20
TOP43: Procurement
14F43121TPurchase Order Receiver Tag File11PRSFXEPay Item Extension NumberNumericGeneric Edit20
TOP43A: Purchase Order Receipt/Routing
15F43126TPurchase Order Receiver Multiple Account Tag File13P4SFXEPay Item Extension NumberNumericGeneric Edit20
TOP45: Advanced Pricing
16F4576Ship and Debit Claims35ACSFXEPay Item Extension NumberNumericGeneric Edit20
17F4576TMPShip and Debit Claims- Temp Table35ACSFXEPay Item Extension NumberNumericGeneric Edit20
18F4576Z1Ship and Debit Claims Unedited Transaction Table48Z1SFXEPay Item Extension NumberNumericGeneric Edit20
TOP47: Electronic Commerce
19F47057EDI Payment Order Remittance Advice - Outbound37D3SFXEPay Item Extension NumberNumericGeneric Edit20
20F47057WEDI Payment Order Remittance Advice - Work37D3SFXEPay Item Extension NumberNumericGeneric Edit20
TOP74: EMEA Localization
21F7404573Detail Payment Instructions EXT. for German Payments8KISFXEPay Item Extension NumberNumericGeneric Edit20
22F74900Foreign Receivables and Payables - EMEA6RPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74H: Hungary
23F74H1004VAT Declaration Detail5VDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74R: CIS
24F74R0018Russian Tax File - 74R9TDSFXEPay Item Extension NumberNumericGeneric Edit20
25F74R0480Pay Item Differences - RUS - 04 - 74R5RPSFXEPay Item Extension NumberNumericGeneric Edit20
26F74R4014F0414 Tag File - RUS - 04 - 74R8TFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74U: United Kingdom Localizations
27F74U0116F0411 CIS Tag File5TFSFXEPay Item Extension NumberNumericGeneric Edit20
28F74U0118Payment Voucher Status History5VHSFXEPay Item Extension NumberNumericGeneric Edit20
29F74U0205Payment Profile - 1520P8SFXEPay Item Extension NumberNumericGeneric Edit20
30F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 047DMSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74W: Sweden - Reporting System Only
31F74W200A/P Payment Processing Sequence Numbers File - 74W8K0SFXEPay Item Extension NumberNumericGeneric Edit20
32F74W203Debit Advice Invoice File - 74W18K3SFXEPay Item Extension NumberNumericGeneric Edit20
TOP75A: Australia - Reporting System Only
33F75A0202GST - RCTI Adjustment Print Control Table6RASFXEPay Item Extension NumberNumericGeneric Edit20
TOP75T: Taiwan
34F75T005GUI/VAT Transaction Detail - 75T28TDSFXEPay Item Extension NumberNumericGeneric Edit20
35F75T0059GUI/VAT Transaction Detail History - 75T28TDSFXEPay Item Extension NumberNumericGeneric Edit20
36F75T005PGUI/VAT Transaction Detail POS - 75T28TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76A: Argentina
37F760411AA/P Tag Ledger Tag File - ARG5B2SFXEPay Item Extension NumberNumericGeneric Edit20
38F760414AA/P Payment Detail Tag File - ARG - 048V1SFXEPay Item Extension NumberNumericGeneric Edit20
39F76A33Receipt Invoice - Audit Log AGR5X4SFXEPay Item Extension NumberNumericGeneric Edit20
40F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A5B2SFXEPay Item Extension NumberNumericGeneric Edit20
41F76A411QF76A411P Tag File Purge - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
42F76A411TF760411A A/P Tag File - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
43F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A8V1SFXEPay Item Extension NumberNumericGeneric Edit20
44F76AUI04A/P Tag Legel Tax File - ARG - WF5WCSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76B: Brazil - Reporting System Only
45F76B0411Voucher Additional Information Brazil - 045VBSFXEPay Item Extension NumberNumericGeneric Edit20
46F76B04BCVoucher Additional Information - Brazil - 045BCSFXEPay Item Extension NumberNumericGeneric Edit20
47F76B410HINSS-Work Table for Services Third Party Inbound NF H - 4222SISFXEPay Item Extension NumberNumericGeneric Edit20
TOP76C: Colombia
48F76C0411A/P Tag File - COL - 76C5RPSFXEPay Item Extension NumberNumericGeneric Edit20
49F76C4011A/P Ledger Tag Table - COL - 045VCSFXEPay Item Extension NumberNumericGeneric Edit20
50F76CUI02Tax Detail - Work File - COL - 76C6TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76H: Chile
51F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H7LPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76M: Mexico
52F76M0414F0414 - Payment Detail Tag File - Mexico16RTSFXEPay Item Extension NumberNumericGeneric Edit20
53F76M411Soft Rounding VAT Calculation5RSSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76P: Peru
54F76P411TPeru AP Tag File - PER - 04 - 76P5T4SFXEPay Item Extension NumberNumericGeneric Edit20
55F76P414TF0414 Tag File - PER - 04 - 76P8P4SFXEPay Item Extension NumberNumericGeneric Edit20
56F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P8WFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76V: Venezuela
57F76V4581Withholding Historical File - VEN - 045HRSFXEPay Item Extension NumberNumericGeneric Edit20
58F76V4582Wittholding Documents Temporal - VEN - 04 - 76V5DRSFXEPay Item Extension NumberNumericGeneric Edit20