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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

148 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
83F74Q0165WF do R74Q01656WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
84F74T101Check History Table4CHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
85F74T531Customer Ledger Tranaction File8CTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
86F74T532Supplier Ledger Transaction File8SLDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
87F74T550General Ledger Work File - Turkish19DKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74: EMEA Localization
88F74030HADutch-Next Batch Number and Sequence Number4STDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
89F74412Customer / Supplier Balance Workfile (A/R and A/P)9RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
90F74900Foreign Receivables and Payables - EMEA12RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74P: Poland
91F74P03BWA/R Trial Balance - POL - 03B - 74P11P3DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
92F74P04WA/P Trial Balance Work Table - POL - 04 - 74P11P2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
93F74P9100Cash Desk Transaction - POL - 74P7CDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74R: CIS
94F74R0018Russian Tax File - 74R14TDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
95F74R0100Petty Cash Transactions - RUS - 00 - 74R8PCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74U: United Kingdom Localizations
96F74U0205Payment Profile - 1522P8DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
97F74U0212Accounting Billing Profile - 1520P8DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
98F74U0213Weekly Accounting Profile - 1521PWDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP74Y: Italy - Reporting System Only
99F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy17TIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75C: China - Reporting System Only
100F75C4203Chinese VAT on Free Goods Cross Reference - China8FCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75T: Taiwan
101F75T004GUI/VAT Transaction Header - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
102F75T0049GUI/VAT Transaction Header History - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
103F75T004PGUI/VAT Transaction Header POS - 75T10THDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
104F75T004ZGUI/VAT Transaction Header - Work - 75T10ZHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP75Z: New Zealand - Reporting System Only
105F75Z0002New Zealand Ledger Detail7Z2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
106F75Z0009New Zealand Tax Detail Work File7TXDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
107F75Z0010New Zealand Tax Detail Tag Table7TDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76A: Argentina
108F76A09Invoice Total - ARG - 00 - 0031TTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
109F76A09PInvoice Total Purge - ARG - 03B - 76A31TTDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
110F76A392Calculated costs header - 76A10C2DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
111F76A41CERG G/L - Lot Detail - ARG - 09 - - 096LDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
112F76A42CERG G/L - Work File - ARG - 09 - 094TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
113F76A8500Tag File F03B14 - ARG - 03B - 76A3TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
114F76A8510Tag File F76A60 - ARG - 03B - 76A8TFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
115F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A13BEDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
116F76AUI81Draft - Invoices Work File - ARG - 03B - 76A20WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
117F76AUI82Draft - Drafts Work File - ARG - 03B - 03B18WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
118F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A28WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76B: Brazil - Reporting System Only
119F76B006IN86-Work Table for Business Unit - 093BBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
120F76B0403Service Taxes Paid Externally - 044STDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
121F76B0411Voucher Additional Information Brazil - 048VBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
122F76B10Account Ledger - IN68 - 092ARDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
123F76B11Account Balances - IN68 - 092ABDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
124F76B20Account Payable and Receivable Table - IN68 - 03B4PRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
125F76B400FIN86-Work Table for Transaction Nature - 422TNDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
126F76B400GIN86-Work Table for Item Number and Service Code - 412ISDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
127F76B473TF04573 Brazilian Temp WH File - BR - 0410W3DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
128F76B64Balances/JE's w/ Currency Correction Table - IN68 - 129BSDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
129F76B8601IN86-Work Table for Individuals and Legal Entities - 041FJDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
130F76B8602IN86-Work Table for Suppliers and Customers - 046PRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
131F76B901IN86- Work Table for Account Master - 097BADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
132F76B902IN86-Work Table for Account Balance - 092BCDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
133F76B911IN86-Work Table for Journal Entries - 092BDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76C: Colombia
134F76C031AA/R Customer ledger As Of - F76C031A - COL - 046RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
135F76C034AA/R Check Detail file As Of - COL - 76C11RZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
136F76C0411A/P Tag File - COL - 76C7RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
137F76C575Work File Magnetic Media - COL - 0413Q1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
138F76C9415Workfile for Dialy Book - COL - 0913LDDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
139F76CT1Tributary Information - COL - 76C12TIDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76E: Ecuador
140F76E4010Withholding Certificate Information - EC - 049CEDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
141F76E4020Withholding Certificate Information w/ SRI - EC - 048CRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76H: Chile
142F76H6001Actual Cost Process Header - CHI - 41 - 76H21PHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
143F76H6201Replacement Cost Process Header - CHI - 4111RHDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
144F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H11WFDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76M: Mexico
145F76M0314Receipt Detail Tag File - Mexico8MADGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOP76V: Venezuela
146F76VLO01Withholdings Temporal Table - VEN -04 - 76V1LODGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
147F76VTARTTemporal Table for Withholdings - VEN -04 - 76V6TRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
TOPF31: Lean Transactions
148FF31201Cross Reference7CRDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60