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

97 columns | Print definition?920 | 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
28F700411Localizations Additional Fields Accounts Payable Ledger - 045LASFXEPay Item Extension NumberNumericGeneric Edit20
29F704001Payment WH Info TEMP - COMM - 0414PTSFXEPay Item Extension NumberNumericGeneric Edit20
30F704002Payment WH Info - COMM - 0413PFSFXEPay Item Extension NumberNumericGeneric Edit20
31F704002PPayment WH Info Purge - COMM - 0413PFSFXEPay Item Extension NumberNumericGeneric Edit20
32F704100Suspended VAT AP - COMM - 705VASFXEPay Item Extension NumberNumericGeneric Edit20
33F704200Final VAT AP - COMM - 705FVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74: EMEA Localization
34F7404573Detail Payment Instructions EXT. for German Payments8KISFXEPay Item Extension NumberNumericGeneric Edit20
35F74900Foreign Receivables and Payables - EMEA6RPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74H: Hungary
36F74H1004VAT Declaration Detail - HUN -045VDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74R: Russia
37F74R0018Russian Tax File - 74R9TDSFXEPay Item Extension NumberNumericGeneric Edit20
38F74R0480Pay Item Differences - RUS - 04 - 74R5RPSFXEPay Item Extension NumberNumericGeneric Edit20
39F74R4014F0414 Tag File - RUS - 04 - 74R8TFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74S: Spain
40F74S342Suspended VAT Declaration Mark File - ESP - 005SVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74U: United Kingdom Localizations
41F74U0116F0411 CIS Tag Table - 045TFSFXEPay Item Extension NumberNumericGeneric Edit20
42F74U0118Payment Voucher Status History - 045VHSFXEPay Item Extension NumberNumericGeneric Edit20
43F74U0120CiS Supp F0411 Tag File - UK - 045MVSFXEPay Item Extension NumberNumericGeneric Edit20
44F74U0205Payment Profile - 1520P8SFXEPay Item Extension NumberNumericGeneric Edit20
45F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 437RNSFXEPay Item Extension NumberNumericGeneric Edit20
46F74U4030CIS Withholding Verification Detail - UK - 045VDSFXEPay Item Extension NumberNumericGeneric Edit20
47F74U4053Subcontractor Documents Detail - CIS Monthly Return - UK- 047DMSFXEPay Item Extension NumberNumericGeneric Edit20
48F74UCW02CIS Voucher Entry Workfile 2 - UK - 045CVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP74W: Sweden
49F74W200A/P Payment Processing Sequence Numbers File - 74W8K0SFXEPay Item Extension NumberNumericGeneric Edit20
50F74W203Debit Advice Invoice File - 74W18K3SFXEPay Item Extension NumberNumericGeneric Edit20
TOP74Y: Italy
51F74Y171Contract Relations - IT - 007CRSFXEPay Item Extension NumberNumericGeneric Edit20
52F74Y415Vouchers Related to AP DN/CN - ITA - 045RVSFXEPay Item Extension NumberNumericGeneric Edit20
TOP75A: Australia
53F75A0202GST - RCTI Adjustment Print Control Table6RASFXEPay Item Extension NumberNumericGeneric Edit20
TOP75I: India
54F75I055Vouchers Generated for Reverse Charge AP - IND - 045RPSFXEPay Item Extension NumberNumericGeneric Edit20
55F75I101TDS Certificate Work Maintenance48QBSFXEPay Item Extension NumberNumericGeneric Edit20
56F75I411F0411 Tag File - IN - 045TFSFXEPay Item Extension NumberNumericGeneric Edit20
57F75I741Service Tax A/P File - IND - 045STSFXEPay Item Extension NumberNumericGeneric Edit20
58F75I742Service Tax A/P File Additional Info - IND - 045STSFXEPay Item Extension NumberNumericGeneric Edit20
59F75IUI7Service Tax Credit Register - Work File - IND8WFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP75T: Taiwan
60F75T005GUI/VAT Transaction Detail - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
61F75T0059GUI/VAT Transaction Detail History - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
62F75T005PGUI/VAT Transaction Detail POS - 75T40TDSFXEPay Item Extension NumberNumericGeneric Edit20
63F75T005TGUI/VAT Transaction Detail Temp - 75T41TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76A: Argentina
64F760411AA/P Ledger Tag Table - ARG - 04 - 76A5B2SFXEPay Item Extension NumberNumericGeneric Edit20
65F760414AA/P Payment Detail Tag Table - ARG - 04 - 76A8V1SFXEPay Item Extension NumberNumericGeneric Edit20
66F76A33Receipt Invoice - Audit Log ARG - 03B - 76A5X4SFXEPay Item Extension NumberNumericGeneric Edit20
67F76A40Withholding Certificates Legal Number - 76A9WCSFXEPay Item Extension NumberNumericGeneric Edit20
68F76A411PPurge A/P Tag Ledger Tag - ARG - 04 - 76A5B2SFXEPay Item Extension NumberNumericGeneric Edit20
69F76A411QF76A411P Tag File Purge - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
70F76A411TF760411A A/P Tag File - ARG - 04 - 76A5B1SFXEPay Item Extension NumberNumericGeneric Edit20
71F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A8V1SFXEPay Item Extension NumberNumericGeneric Edit20
72F76AUI04A/P Legel Tax Tag Table - ARG - 04 - 76A5WCSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76B: Brazil
73F76B0411Voucher Additional Information Brazil - 045VBSFXEPay Item Extension NumberNumericGeneric Edit20
74F76B04BCVoucher Additional Information - Brazil - 045BCSFXEPay Item Extension NumberNumericGeneric Edit20
75F76B410HINSS-Work Table for Services Third Party Inbound NF H - 4222SISFXEPay Item Extension NumberNumericGeneric Edit20
76F76B415Withholding by City and Service Additional Info - BR - 045CSSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76C: Colombia
77F76C0411A/P Tag File - COL - 76C5RPSFXEPay Item Extension NumberNumericGeneric Edit20
78F76C4011A/P Ledger Tag Table - COL - 045VCSFXEPay Item Extension NumberNumericGeneric Edit20
79F76C4F02DIAN Formats File by Invoice - COL - 046FISFXEPay Item Extension NumberNumericGeneric Edit20
80F76CUI02Tax Detail - Work File - COL - 76C6TDSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76H: Chile
81F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H7LPSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76M: Mexico
82F76M0414F0414 - Payment Detail Tag File - Mexico16RTSFXEPay Item Extension NumberNumericGeneric Edit20
83F76M411Soft Rounding VAT Calculation5RSSFXEPay Item Extension NumberNumericGeneric Edit20
84F76M411TF0411 A/P Tag File - MEX - 04 TF5TFSFXEPay Item Extension NumberNumericGeneric Edit20
85F76M573PCG Detail Withholding Amounts - MEX - 048WDSFXEPay Item Extension NumberNumericGeneric Edit20
86F76M930AR VAT on Gain/loss MEX - 76M9APSFXEPay Item Extension NumberNumericGeneric Edit20
87F76M940AP VAT on Gain/loss - MEX - 76M21APSFXEPay Item Extension NumberNumericGeneric Edit20
88F76M990GL VAT on Gain/loss MEX - 76M25GLSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76P: Peru
89F76P411TPeru AP Tag File - PER - 04 - 76P5T4SFXEPay Item Extension NumberNumericGeneric Edit20
90F76P414TF0414 Tag File - PER - 04 - 76P8P4SFXEPay Item Extension NumberNumericGeneric Edit20
91F76PUI45Workfile VAT Purchasing Ledger - PER - 04 - 76P8WFSFXEPay Item Extension NumberNumericGeneric Edit20
TOP76V: Venezuela
92F76V4581Withholding Historical File - VEN - 045HRSFXEPay Item Extension NumberNumericGeneric Edit20
93F76V4582Wittholding Documents Temporal - VEN - 04 - 76V5DRSFXEPay Item Extension NumberNumericGeneric Edit20
TOP79A: Greenhouse Gas Accounting
94F79A11GHG Ledger6GRSFXEPay Item Extension NumberNumericGeneric Edit20
95F79A11Z1GHG Ledger - Batch File24GLSFXEPay Item Extension NumberNumericGeneric Edit20
96F79A12GHG Ledger Audit7GRSFXEPay Item Extension NumberNumericGeneric Edit20
97F79AU11GHG Ledger Work Table9GRSFXEPay Item Extension NumberNumericGeneric Edit20