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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

119 columns | Print definition?812 | PN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger23GLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP03: Accounts Receivable
2F0311Accounts Receivable Ledger14RPPNPeriod Number - General LedgerNumericGeneric Edit20
TOP03B: Enhanced Accounts Receivable
3F03B08Credit/Collection Date Pattern4RDPNPeriod Number - General LedgerNumericGeneric Edit20
4F03B11Customer Ledger13RPPNPeriod Number - General LedgerNumericGeneric Edit20
5F03B112Invoice Revisions13RWPNPeriod Number - General LedgerNumericGeneric Edit20
6F03B112PInvoice Revisions Purge File13RWPNPeriod Number - General LedgerNumericGeneric Edit20
7F03B11PCustomer Ledger Purge File13RPPNPeriod Number - General LedgerNumericGeneric Edit20
8F03B11Z1Invoice Transactions - Batch File31VJPNPeriod Number - General LedgerNumericGeneric Edit20
9F03B11Z2F03B11 Interoperability Table26SYPNPeriod Number - General LedgerNumericGeneric Edit20
10F03B13Receipts Header File16RYPNPeriod Number - General LedgerNumericGeneric Edit20
11F03B13PReceipts Header Purge File16RYPNPeriod Number - General LedgerNumericGeneric Edit20
12F03B13Z2F03B13 Interoperability Table29SYPNPeriod Number - General LedgerNumericGeneric Edit20
13F03B14A/R Check Detail File17RZPNPeriod Number - General LedgerNumericGeneric Edit20
14F03B14PReceipts Detail Purge File17RZPNPeriod Number - General LedgerNumericGeneric Edit20
15F03B14Z2F03B14 Interoperability Table30SZPNPeriod Number - General LedgerNumericGeneric Edit20
16F03B16A/R Statistical History5RVPNPeriod Number - General LedgerNumericGeneric Edit20
17F03B465A/R Netting Workfile20ROPNPeriod Number - General LedgerNumericGeneric Edit20
18F03B575Auto Debit Invoice Select and Build16RDPNPeriod Number - General LedgerNumericGeneric Edit20
19F03B672Draft Remittance Work File - One World Only19RDPNPeriod Number - General LedgerNumericGeneric Edit20
20F09UI011Receipt Prepost Work File17GLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP04: Accounts Payable
21F0411Accounts Payable Ledger17RPPNPeriod Number - General LedgerNumericGeneric Edit20
22F0411AWF - As Of - Accounts Payable Ledger17RPPNPeriod Number - General LedgerNumericGeneric Edit20
23F0411PPurge - Accounts Payable Ledger17RPPNPeriod Number - General LedgerNumericGeneric Edit20
24F0411Z1Voucher Transactions - Batch File35VLPNPeriod Number - General LedgerNumericGeneric Edit20
25F0411Z3F0411 Interoperability Table39SZPNPeriod Number - General LedgerNumericGeneric Edit20
26F0414Accounts Payable Matching Document Detail21RNPNPeriod Number - General LedgerNumericGeneric Edit20
27F0414AWF - As Of - Accounts Payable Payment Detail21RNPNPeriod Number - General LedgerNumericGeneric Edit20
28F0414PPurge - Accounts Payable Matching Document Detail21RNPNPeriod Number - General LedgerNumericGeneric Edit20
29F0414Z1F0414 Interoperability Table34SZPNPeriod Number - General LedgerNumericGeneric Edit20
30F09UI005Tax Offsets User Index13GLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP05: Time Accounting and HRM Base
31F0618Employee Transaction History68YTPNPeriod Number - General LedgerNumericGeneric Edit20
TOP05T: Time Entry
32F06116Employee Transaction Detail File68YTPNPeriod Number - General LedgerNumericGeneric Edit20
33F06116Z1Employee Transactions - Batch File82VLPNPeriod Number - General LedgerNumericGeneric Edit20
34F06278Retro Timecard Detail File68YTPNPeriod Number - General LedgerNumericGeneric Edit20
35F06290Payroll Accounting Journal Work File14YRPNPeriod Number - General LedgerNumericGeneric Edit20
36F063951Payroll Journal (Compressed) File16GLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP07: Payroll
37F05290WF - Payroll Journal (Detail)16JRPNPeriod Number - General LedgerNumericGeneric Edit20
38F07491Payroll - Accounts Payable Summary File22J6PNPeriod Number - General LedgerNumericGeneric Edit20
39F07UI200Timecard History Work File71THPNPeriod Number - General LedgerNumericGeneric Edit20
TOP09: General Accounting
40F0911PPurge - Account Ledger23GLPNPeriod Number - General LedgerNumericGeneric Edit20
41F0911RWF - Acct Ledger File for Reconciliation23GLPNPeriod Number - General LedgerNumericGeneric Edit20
42F0911Z1Journal Entry Transactions - Batch File40VNPNPeriod Number - General LedgerNumericGeneric Edit20
43F0911Z4F0911 Interoperability Table45SZPNPeriod Number - General LedgerNumericGeneric Edit20
44F0912Cost Allocations/Flex Budgeting39RJPNPeriod Number - General LedgerNumericGeneric Edit20
45F0912AIndex Computation Entry File34RIPNPeriod Number - General LedgerNumericGeneric Edit20
46F09UI015Indexed Computations Multi-Tiered Entries23GLPNPeriod Number - General LedgerNumericGeneric Edit20
47F09UI016Account Balance Compare Exceptions8GWPNPeriod Number - General LedgerNumericGeneric Edit20
48F70UI001Work File for G/L by Cat. Code Localization3WAPNPeriod Number - General LedgerNumericGeneric Edit20
49F740911Work File for G/L Report by Category Code Localization3WAPNPeriod Number - General LedgerNumericGeneric Edit20
TOP10: Financial Reporting
50F1001Multi-Site Consolidation Transfer File Header11GPPNPeriod Number - General LedgerNumericGeneric Edit20
51F1001Z1Unedited MSC Interoperability Header Table21IAPNPeriod Number - General LedgerNumericGeneric Edit20
TOP15L: Adv Real Estate Forecasting
52F15L38AREF EP Billing Register9NZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP16: Profit Management (EPS)
53F1611Cost Calculation Transactions13CTPNPeriod Number - General LedgerNumericGeneric Edit20
TOP18: Resource Scheduling
54F186602Labor Rules Tag File78TFPNPeriod Number - General LedgerNumericGeneric Edit20
TOP39: Advanced Stock Valuation
55F39120Temporary Period Build File for Stock Valuation22TFPNPeriod Number - General LedgerNumericGeneric Edit20
TOP41: Inventory Management
56F41UI001Inventory Transactions Detail File158ITPNPeriod Number - General LedgerNumericGeneric Edit20
TOP42: Sales Management
57F42800G1Sales Update G Batch Detail Workfile18DGPNPeriod Number - General LedgerNumericGeneric Edit20
58F42UI800Sales Detail Work File - Sales Update32SDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP43: Procurement
59F43080Approvals Fields Constants40PDPNPeriod Number - General LedgerNumericGeneric Edit20
60F4311Purchase Order Detail File32PDPNPeriod Number - General LedgerNumericGeneric Edit20
61F4311ZPurchase Order Generator File36PWPNPeriod Number - General LedgerNumericGeneric Edit20
62F4311Z1Purchase Order Detail Unedited Transaction Table45SZPNPeriod Number - General LedgerNumericGeneric Edit20
63F4316Purchase Order Multiple Account File15P3PNPeriod Number - General LedgerNumericGeneric Edit20
64F43199P.O. Detail Ledger File - Flexible Version32OLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP43E: Requisition Self Service
65F43E16Requisition Multiple Account File16P3PNPeriod Number - General LedgerNumericGeneric Edit20
TOP44H: Homebuilder Management
66F44H611Bid Details31BDPNPeriod Number - General LedgerNumericGeneric Edit20
67F44H611WBid Details Work File35BWPNPeriod Number - General LedgerNumericGeneric Edit20
68F44H711Lot Start Workfile38SWPNPeriod Number - General LedgerNumericGeneric Edit20
69F44H711ZHB Lot Start Unedited Transaction File51SZPNPeriod Number - General LedgerNumericGeneric Edit20
70F44H71W1Lot Start Generation Workfile38GWPNPeriod Number - General LedgerNumericGeneric Edit20
TOP47: Electronic Commerce
71F47017EDI Purchase Order Detail - Outbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
72F47022EDI P.O. Acknowledgment Detail - Inbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
73F47056EDI Payment Order Header - Outbound37D1PNPeriod Number - General LedgerNumericGeneric Edit20
74F47056WEDI Payment Order Header - Work37D1PNPeriod Number - General LedgerNumericGeneric Edit20
75F47072EDI Receiving Advice Detail - Inbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
76F47077EDI Receiving Advice Detail - Outbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
77F47097EDI Request for Quote Detail - Outbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
78F47102EDI Response to RFQ Detail - Inbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
79F47137EDI Purchase Order Change Detail - Outbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
80F47142EDI P.O. Change Acknowledgment Detail - Inbound47SZPNPeriod Number - General LedgerNumericGeneric Edit20
81F47157EDI Shipping Schedule Detail - Outbound47SZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP48S: Service Billing
82F4812Billing Detail Workfile19WDPNPeriod Number - General LedgerNumericGeneric Edit20
83F4812HBilling Workfile - History19WDPNPeriod Number - General LedgerNumericGeneric Edit20
84F4812HSBilling Workfile History Purged Save19WDPNPeriod Number - General LedgerNumericGeneric Edit20
85F48S0618Payroll Reclassification Workfile68YTPNPeriod Number - General LedgerNumericGeneric Edit20
86F48S910Billing Detail Journal File9W2PNPeriod Number - General LedgerNumericGeneric Edit20
87F48S911Compressed Journal File10W3PNPeriod Number - General LedgerNumericGeneric Edit20
88F48SUI01Billing Detail Print Workfile19WDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP52: Contract Billing
89F5280Contract Revenue Summary File8GWPNPeriod Number - General LedgerNumericGeneric Edit20
90F5280WContract Revenue Summary Work File8GYPNPeriod Number - General LedgerNumericGeneric Edit20
TOP55: Reserved for Clients
91F74T101Check History Table6CHPNPeriod Number - General LedgerNumericGeneric Edit20
92F74T205Checks Collected5CCPNPeriod Number - General LedgerNumericGeneric Edit20
93F74T190Check/Draft Book Seq Number4SNPNPeriod Number - General LedgerNumericGeneric Edit20
94F74T531Customer Ledger Tranaction File7CTPNPeriod Number - General LedgerNumericGeneric Edit20
95F74T532Supplier Ledger Transaction File7SLPNPeriod Number - General LedgerNumericGeneric Edit20
96F74T550General Ledger Work File - Turkish26DKPNPeriod Number - General LedgerNumericGeneric Edit20
97F74T550BGeneral Ledger PO Work File - Turkish5POPNPeriod Number - General LedgerNumericGeneric Edit20
TOP74: EMEA Localization
98F74900Foreign Receivables and Payables - EMEA19RPPNPeriod Number - General LedgerNumericGeneric Edit20
99F74UI92WF - Account Cell Value - EMEA - 7425CVPNPeriod Number - General LedgerNumericGeneric Edit20
TOP74U: United Kingdom Localizations
100F74U0205Payment Profile - 1529P8PNPeriod Number - General LedgerNumericGeneric Edit20
TOP74Y: Italy - Reporting System Only
101F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy6TIPNPeriod Number - General LedgerNumericGeneric Edit20
TOP76A: Argentina
102F76A392Calculated costs header - 76A4C2PNPeriod Number - General LedgerNumericGeneric Edit20
103F76A393Calculated costs detail - 76A4C3PNPeriod Number - General LedgerNumericGeneric Edit20
104F76A394Adjustments - 76A4C4PNPeriod Number - General LedgerNumericGeneric Edit20
TOP76B: Brazil - Reporting System Only
105F76B0411Voucher Additional Information Brazil - 049VBPNPeriod Number - General LedgerNumericGeneric Edit20
106F76B473TF04573 Brazilian Temp WH File - BR - 0411W3PNPeriod Number - General LedgerNumericGeneric Edit20
TOP76C: Colombia
107F76C0003VAT Certificates Retention - COL - 76C4CRPNPeriod Number - General LedgerNumericGeneric Edit20
108F76C031AA/R Customer ledger As Of - F76C031A - COL - 0413RPPNPeriod Number - General LedgerNumericGeneric Edit20
109F76C034AA/R Check Detail file As Of - COL - 76C17RZPNPeriod Number - General LedgerNumericGeneric Edit20
110F76C0902Debits and Credits T/B by object account - COL - 76C4GBPNPeriod Number - General LedgerNumericGeneric Edit20
111F76C575Work File Magnetic Media - COL - 0412Q1PNPeriod Number - General LedgerNumericGeneric Edit20
112F76C9415Workfile for Dialy Book - COL - 0920LDPNPeriod Number - General LedgerNumericGeneric Edit20
113F76CT1Tributary Information - COL - 76C11TIPNPeriod Number - General LedgerNumericGeneric Edit20
114F76CT3VAT Certificates Retention - Work File - COL - 76C2T3PNPeriod Number - General LedgerNumericGeneric Edit20
TOP76P: Peru
115F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P3CZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP76V: Venezuela
116F76V4581Withholding Historical File - VEN - 049HRPNPeriod Number - General LedgerNumericGeneric Edit20
117F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 045TDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP83: Management Reporting - FASTR
118F83UI001Balance Audit Work File - (Financial Reporting)9R1PNPeriod Number - General LedgerNumericGeneric Edit20
TOP89: Conversion Programs
119F43199ATemp F43199 for ERP 9.0 Upgrade32OLPNPeriod Number - General LedgerNumericGeneric Edit20