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

158 columns | Print definition?812 | DGJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00189WF - Tax Reconciliation11TGDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
2F0018RTax Reconciliation Repository9EDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
3F0911Account Ledger4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
4F0911TAccount Ledger Tag File4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP03: Accounts Receivable
5F0311Accounts Receivable Ledger11RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
6F0312A/R Batch Cash Application49RUDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
7F03B11Customer Ledger6RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
8F03B112Invoice Revisions15RWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
9F03B112PInvoice Revisions Purge File15RWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
10F03B11PCustomer Ledger Purge File6RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
11F03B11Z1Invoice Transactions - Batch File24VJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
12F03B11Z2F03B11 Interoperability Table19SYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
13F03B13Receipts Header File6RYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
14F03B13PReceipts Header Purge File6RYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
15F03B13Z1Electronic Receipts Input22RUDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
16F03B13Z2F03B13 Interoperability Table19SYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
17F03B14A/R Check Detail File11RZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
18F03B14PReceipts Detail Purge File11RZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
19F03B14Z2F03B14 Interoperability Table24SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
20F03B21A/R Notification History Detail11ZSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
21F03B22A/R Fee Journal History24RSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
22F03B41A/R Deduction Activity15RCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
23F03B41Z1Inteoperability - Deductions Management18SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
24F03B465A/R Netting Workfile12RODGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
25F03B571Auto Debit Batch Control17RCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
26F03B575Auto Debit Invoice Select and Build9RDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
27F03B672Draft Remittance Work File - One World Only9RDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
28F09UI011Receipt Prepost Work File4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP04: Accounts Payable
29F0411Accounts Payable Ledger14RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
30F0411AWF - As Of - Accounts Payable Ledger14RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
31F0411PPurge - Accounts Payable Ledger14RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
32F0411Z1Voucher Transactions - Batch File32VLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
33F0411Z3F0411 Interoperability Table36SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
34F04514WF - 1099 Combined Workfile (Merge of F045141 and F045143)23G1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
35F045141WF - 1099 G/L Workfile23G1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
36F045143WF - 1099 A/P WorkFile23G1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
37F04572A/P Payment Processing - Summary File27KKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
38F04573A/P Payment Processing - Detail File44KIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
39F09UI005Tax Offsets User Index12GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP05T: Time Entry
40F06290Payroll Accounting Journal Work File15YRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
41F063951Payroll Journal (Compressed) File15GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP07: Payroll
42F05290WF - Payroll Journal (Detail)15JRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
43F06492Payroll - Accounts Payable Control10JCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
44F07492Payroll - Accounts Payable Control File10JCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP09: General Accounting
45F0911PPurge - Account Ledger4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
46F0911RWF - Acct Ledger File for Reconciliation4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
47F0911Z1Journal Entry Transactions - Batch File21VNDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
48F0911Z4F0911 Interoperability Table26SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
49F0912Cost Allocations/Flex Budgeting27RJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
50F0912AIndex Computation Entry File23RIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
51F0912BVariable Allocation File6R#DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
52F0917Bank Statement Detail34GDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
53F09218Online Consolidations Set-up File15LSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
54F09617Auto Bank Statement Detail32GMDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
55F09UI015Indexed Computations Multi-Tiered Entries4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
56F70UI001Work File for G/L by Cat. Code Localization6WADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
57F740911Work File for G/L Report by Category Code Localization9WADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP12: Fixed Assets
58F12911ERPost G/L to FA Exceptions Work File4GLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP15: Property Management
59F151991G/L Transaction A/R Application Work File11NBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
60F1532BExpense Participation Audit File3NTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
61F1548Escalation Billing Register28N1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
62F1548BEscalation Billing Register29N1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP31: Shop Floor Control
63F3106W.O. Cross Reference File4SDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
64F3108Summarized WO Cross-Reference5SJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP39: Advanced Stock Valuation
65F39042Company G/L Update Method Master3SCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
66F3910G/L Adjustment Table6SCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
67F39120WPeriod Detail Work File18TWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP47: Electronic Commerce
68F47041EDI Invoice Header - Inbound25SYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
69F47056EDI Payment Order Header - Outbound34D1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
70F47056WEDI Payment Order Header - Work34D1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
71F47112EDI Lockbox Header - Transaction17Z2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP48S: Service Billing
72F4812Billing Detail Workfile154WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
73F4812GRetro Adjustment Workfile17WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
74F4812HBilling Workfile - History154WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
75F4812HSBilling Workfile History Purged Save154WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
76F48S910Billing Detail Journal File8W2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
77F48S911Compressed Journal File9W3DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
78F48S912G/L Link File20W6DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
79F48SUI01Billing Detail Print Workfile154WDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP49: Transportation Management
80F4981Freight Audit History49FHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP51: Job Costing
81F51911Draw Reporting Master3GKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
82F51911EXDraw Explanation Table4GKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP55: Reserved for Clients
83F5574T14New Credit Analysis Report -BO7CADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
84F55CS001Check/Draft Integrity Report3CSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
85F55IF120Period Detail Work File Copy18TWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
86F55IFP04Pozycje Budżetowe WF8WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
87F55IFSCHCust / Supp Balance Workfile - Copia estesa di F744127RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
88F55IFVALOutput File di R55IFVALOR9FADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
89F59BO001Cash Journal Master File13CJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
90F59PO001Cash Journal Master File13CJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
91F74Q0165WF do R74Q01656WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
92F74T101Check History Table4CHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
93F74T531Customer Ledger Tranaction File8CTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
94F74T532Supplier Ledger Transaction File8SLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
95F74T550General Ledger Work File - Turkish19DKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
96F59BF001B Formlar? Tablosu10BFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
97F59BN01Garanti Bankasi Cek/Senet Entegrasyon Tablosu24BNDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74: EMEA Localization
98F74030HADutch-Next Batch Number and Sequence Number4STDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
99F74412Customer / Supplier Balance Workfile (A/R and A/P)9RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
100F74900Foreign Receivables and Payables - EMEA12RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74P: Poland
101F74P03BWA/R Trial Balance - POL - 03B - 74P11P3DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
102F74P04WA/P Trial Balance Work Table - POL - 04 - 74P11P2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
103F74P9100Cash Desk Transaction - POL - 74P7CDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74R: CIS
104F74R0018Russian Tax File - 74R14TDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
105F74R0100Petty Cash Transactions - RUS - 00 - 74R8PCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74U: United Kingdom Localizations
106F74U0205Payment Profile - 1522P8DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
107F74U0212Accounting Billing Profile - 1520P8DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
108F74U0213Weekly Accounting Profile - 1521PWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74Y: Italy - Reporting System Only
109F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy17TIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75C: China - Reporting System Only
110F75C4203Chinese VAT on Free Goods Cross Reference - China8FCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75T: Taiwan
111F75T004GUI/VAT Transaction Header - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
112F75T0049GUI/VAT Transaction Header History - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
113F75T004PGUI/VAT Transaction Header POS - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
114F75T004ZGUI/VAT Transaction Header - Work - 75T10ZHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75Z: New Zealand - Reporting System Only
115F75Z0002New Zealand Ledger Detail7Z2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
116F75Z0009New Zealand Tax Detail Work File7TXDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
117F75Z0010New Zealand Tax Detail Tag Table7TDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76A: Argentina
118F76A09Invoice Total - ARG - 00 - 0031TTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
119F76A09PInvoice Total Purge - ARG - 03B - 76A31TTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
120F76A392Calculated costs header - 76A10C2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
121F76A41CERG G/L - Lot Detail - ARG - 09 - - 096LDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
122F76A42CERG G/L - Work File - ARG - 09 - 094TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
123F76A8500Tag File F03B14 - ARG - 03B - 76A3TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
124F76A8510Tag File F76A60 - ARG - 03B - 76A8TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
125F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A13BEDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
126F76AUI81Draft - Invoices Work File - ARG - 03B - 76A20WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
127F76AUI82Draft - Drafts Work File - ARG - 03B - 03B18WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
128F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A28WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76B: Brazil - Reporting System Only
129F76B006IN86-Work Table for Business Unit - 093BBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
130F76B0403Service Taxes Paid Externally - 044STDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
131F76B0411Voucher Additional Information Brazil - 048VBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
132F76B10Account Ledger - IN68 - 092ARDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
133F76B11Account Balances - IN68 - 092ABDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
134F76B20Account Payable and Receivable Table - IN68 - 03B4PRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
135F76B400FIN86-Work Table for Transaction Nature - 422TNDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
136F76B400GIN86-Work Table for Item Number and Service Code - 412ISDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
137F76B473TF04573 Brazilian Temp WH File - BR - 0410W3DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
138F76B64Balances/JE's w/ Currency Correction Table - IN68 - 129BSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
139F76B8601IN86-Work Table for Individuals and Legal Entities - 041FJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
140F76B8602IN86-Work Table for Suppliers and Customers - 046PRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
141F76B901IN86- Work Table for Account Master - 097BADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
142F76B902IN86-Work Table for Account Balance - 092BCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
143F76B911IN86-Work Table for Journal Entries - 092BDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76C: Colombia
144F76C031AA/R Customer ledger As Of - F76C031A - COL - 046RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
145F76C034AA/R Check Detail file As Of - COL - 76C11RZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
146F76C0411A/P Tag File - COL - 76C7RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
147F76C575Work File Magnetic Media - COL - 0413Q1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
148F76C9415Workfile for Dialy Book - COL - 0913LDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
149F76CT1Tributary Information - COL - 76C12TIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76E: Ecuador
150F76E4010Withholding Certificate Information - EC - 049CEDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
151F76E4020Withholding Certificate Information w/ SRI - EC - 048CRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76H: Chile
152F76H6001Actual Cost Process Header - CHI - 41 - 76H21PHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
153F76H6201Replacement Cost Process Header - CHI - 4111RHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
154F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H11WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76M: Mexico
155F76M0314Receipt Detail Tag File - Mexico8MADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76V: Venezuela
156F76VLO01Withholdings Temporal Table - VEN -04 - 76V1LODGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
157F76VTARTTemporal Table for Withholdings - VEN -04 - 76V6TRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOPF31: Lean Transactions
158FF31201Cross Reference7CRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60