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

92 columns | Print definition?910 | SFXE

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository8EDSFXEPay Item Extension NumberNumericGeneric Edit20
2F0911Account Ledger140GLSFXEPay Item Extension NumberNumericGeneric Edit20
TOP03B: Enhanced Accounts Receivable
3F03B112Invoice Revisions5RWSFXEPay Item Extension NumberNumericGeneric Edit20
4F03B112PInvoice Revisions Purge File5RWSFXEPay Item Extension NumberNumericGeneric Edit20
TOP04: Accounts Payable
5F0411Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
6F0411AWF - As Of Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
7F0411PPurge - Accounts Payable Ledger5RPSFXEPay Item Extension NumberNumericGeneric Edit20
8F0411Z1Voucher Transactions - Batch Upload23VLSFXEPay Item Extension NumberNumericGeneric Edit20
9F0411Z3F0411 Interoperability Table27SZSFXEPay Item Extension NumberNumericGeneric Edit20
10F0414Accounts Payable Matching Document Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
11F0414AWF - As Of Accounts Payable Payment Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
12F0414PPurge - Accounts Payable Matching Document Detail8RNSFXEPay Item Extension NumberNumericGeneric Edit20
13F0414Z1F0414 Interoperability Table21SZSFXEPay Item Extension NumberNumericGeneric Edit20
14F04573A/P Payment Processing - Detail26KISFXEPay Item Extension NumberNumericGeneric Edit20
15F09UI005Tax Offsets User Index47GLSFXEPay Item Extension NumberNumericGeneric Edit20
TOP09: General Accounting
16F0911PPurge - Account Ledger140GLSFXEPay Item Extension NumberNumericGeneric Edit20
17F0911RWF - Account Ledger Reconciliation78GLSFXEPay Item Extension NumberNumericGeneric Edit20
18F0911Z1Journal Entry Transactions - Batch File192VNSFXEPay Item Extension NumberNumericGeneric Edit20
19F0911Z4F0911 Interoperability Table167SZSFXEPay Item Extension NumberNumericGeneric Edit20
TOP40G: Grower Management
20F40G95Pay On Proceeds Log File43PPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP43: Procurement
21F43121TPurchase Order Receiver Tag File11PRSFXEPay Item Extension NumberNumericGeneric Edit20
TOP43A: Purchase Order Receipt/Routing
22F43126TPurchase Order Receiver Multiple Account Tag File13P4SFXEPay Item Extension NumberNumericGeneric Edit20
TOP45: Advanced Pricing
23F4576Ship and Debit Claims35ACSFXEPay Item Extension NumberNumericGeneric Edit20
24F4576TMPShip and Debit Claims- Temp Table35ACSFXEPay Item Extension NumberNumericGeneric Edit20
25F4576Z1Ship and Debit Claims Unedited Transaction Table48Z1SFXEPay Item Extension NumberNumericGeneric Edit20
TOP47: Electronic Commerce
26F47057EDI Payment Order Remittance Advice - Outbound37D3SFXEPay Item Extension NumberNumericGeneric Edit20
27F47057WEDI Payment Order Remittance Advice - Work37D3SFXEPay Item Extension NumberNumericGeneric Edit20
TOP70: Multi-National Products - obsolete-do not reuse
28F704001Payment WH Info TEMP - COMM - 0414PTSFXEPay Item Extension NumberNumericGeneric Edit20
29F704002Payment WH Info - COMM - 0413PFSFXEPay Item Extension NumberNumericGeneric Edit20
30F704002PPayment WH Info Purge - COMM - 0413PFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74: EMEA Localization
31F7404573Detail Payment Instructions EXT. for German Payments8KISFXEPay Item Extension NumberNumericGeneric Edit20
32F74900Foreign Receivables and Payables - EMEA6RPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74H: Hungary
33F74H1004VAT Declaration Detail - HUN -045VDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74R: CIS
34F74R0018Russian Tax File - 74R9TDSFXEPay Item Extension NumberNumericGeneric Edit20
35F74R0480Pay Item Differences - RUS - 04 - 74R5RPSFXEPay Item Extension NumberNumericGeneric Edit20
36F74R4014F0414 Tag File - RUS - 04 - 74R8TFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74U: United Kingdom Localizations
37F74U0116F0411 CIS Tag Table - 045TFSFXEPay Item Extension NumberNumericGeneric Edit20
38F74U0118Payment Voucher Status History - 045VHSFXEPay Item Extension NumberNumericGeneric Edit20
39F74U0120CiS Supp F0411 Tag File - UK - 045MVSFXEPay Item Extension NumberNumericGeneric Edit20
40F74U0205Payment Profile - 1520P8SFXEPay Item Extension NumberNumericGeneric Edit20
41F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 437RNSFXEPay Item Extension NumberNumericGeneric Edit20
42F74U4030CIS Withholding Verification Detail - UK - 045VDSFXEPay Item Extension NumberNumericGeneric Edit20
43F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 047DMSFXEPay Item Extension NumberNumericGeneric Edit20
44F74UCW02CIS Voucher Entry Workfile 2 - UK - 045CVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74W: Sweden - Reporting System Only
45F74W200A/P Payment Processing Sequence Numbers File - 74W8K0SFXEPay Item Extension NumberNumericGeneric Edit20
46F74W203Debit Advice Invoice File - 74W18K3SFXEPay Item Extension NumberNumericGeneric Edit20
TOP74Y: Italy - Reporting System Only
47F74Y171Contract Relations - IT - 007CRSFXEPay Item Extension NumberNumericGeneric Edit20
48F74Y415Vouchers Related to AP DN/CN - ITA - 045RVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP75A: Australia - Reporting System Only
49F75A0202GST - RCTI Adjustment Print Control Table6RASFXEPay Item Extension NumberNumericGeneric Edit20
TOP75I: India
50F75I055Vouchers Generated for Reverse Charge AP - IND - 045RPSFXEPay Item Extension NumberNumericGeneric Edit20
51F75I101TDS Certificate Work Maintenance48QBSFXEPay Item Extension NumberNumericGeneric Edit20
52F75I411F0411 Tag File - IN - 045TFSFXEPay Item Extension NumberNumericGeneric Edit20
53F75I741Service Tax A/P File - IND - 045STSFXEPay Item Extension NumberNumericGeneric Edit20
54F75I742Service Tax A/P File Additional Info - IND - 045STSFXEPay Item Extension NumberNumericGeneric Edit20
55F75IUI7Service Tax Credit Register - Work File - IND8WFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP75T: Taiwan
56F75T005GUI/VAT Transaction Detail - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
57F75T0059GUI/VAT Transaction Detail History - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
58F75T005PGUI/VAT Transaction Detail POS - 75T40TDSFXEPay Item Extension NumberNumericGeneric Edit20
59F75T005TGUI/VAT Transaction Detail Temp - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76A: Argentina
60F760411AA/P Ledger Tag Table - ARG - 04 - 76A5B2SFXEPay Item Extension NumberNumericGeneric Edit20
61F760414AA/P Payment Detail Tag Table - ARG - 04 - 76A8V1SFXEPay Item Extension NumberNumericGeneric Edit20
62F76A33Receipt Invoice - Audit Log ARG - 03B - 76A5X4SFXEPay Item Extension NumberNumericGeneric Edit20
63F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A5B2SFXEPay Item Extension NumberNumericGeneric Edit20
64F76A411QF76A411P Tag File Purge - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
65F76A411TF760411A A/P Tag File - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
66F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A8V1SFXEPay Item Extension NumberNumericGeneric Edit20
67F76AUI04A/P Legel Tax Tag Table - ARG - 04 - 76A5WCSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76B: Brazil - Reporting System Only
68F76B0411Voucher Additional Information Brazil - 045VBSFXEPay Item Extension NumberNumericGeneric Edit20
69F76B04BCVoucher Additional Information - Brazil - 045BCSFXEPay Item Extension NumberNumericGeneric Edit20
70F76B410HINSS-Work Table for Services Third Party Inbound NF H - 4222SISFXEPay Item Extension NumberNumericGeneric Edit20
71F76B415Withholding by City and Service Additional Info - BR - 045CSSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76C: Colombia
72F76C0411A/P Tag File - COL - 76C5RPSFXEPay Item Extension NumberNumericGeneric Edit20
73F76C4011A/P Ledger Tag Table - COL - 045VCSFXEPay Item Extension NumberNumericGeneric Edit20
74F76C4F02DIAN Formats File by Invoice - COL - 046FISFXEPay Item Extension NumberNumericGeneric Edit20
75F76CUI02Tax Detail - Work File - COL - 76C6TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76H: Chile
76F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H7LPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76M: Mexico
77F76M0414F0414 - Payment Detail Tag File - Mexico16RTSFXEPay Item Extension NumberNumericGeneric Edit20
78F76M411Soft Rounding VAT Calculation5RSSFXEPay Item Extension NumberNumericGeneric Edit20
79F76M411TF0411 A/P Tag File - MEX - 04 TF5TFSFXEPay Item Extension NumberNumericGeneric Edit20
80F76M573PCG Detail Withholding Amounts - MEX - 048WDSFXEPay Item Extension NumberNumericGeneric Edit20
81F76M930AR VAT on Gain/loss MEX - 76M9APSFXEPay Item Extension NumberNumericGeneric Edit20
82F76M940AP VAT on Gain/loss - MEX - 76M21APSFXEPay Item Extension NumberNumericGeneric Edit20
83F76M990GL VAT on Gain/loss MEX - 76M25GLSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76P: Peru
84F76P411TPeru AP Tag File - PER - 04 - 76P5T4SFXEPay Item Extension NumberNumericGeneric Edit20
85F76P414TF0414 Tag File - PER - 04 - 76P8P4SFXEPay Item Extension NumberNumericGeneric Edit20
86F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P8WFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76V: Venezuela
87F76V4581Withholding Historical File - VEN - 045HRSFXEPay Item Extension NumberNumericGeneric Edit20
88F76V4582Wittholding Documents Temporal - VEN - 04 - 76V5DRSFXEPay Item Extension NumberNumericGeneric Edit20
TOP79A: Greenhouse Gas Accounting
89F79A11GHG Ledger6GRSFXEPay Item Extension NumberNumericGeneric Edit20
90F79A11Z1GHG Ledger - Batch File24GLSFXEPay Item Extension NumberNumericGeneric Edit20
91F79A12GHG Ledger Audit7GRSFXEPay Item Extension NumberNumericGeneric Edit20
92F79AU11GHG Ledger Work Table9GRSFXEPay Item Extension NumberNumericGeneric Edit20