JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

147 columns | Print definition?910 | 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
8F03B11Z1Batch Invoices31VJPNPeriod Number - General LedgerNumericGeneric Edit20
9F03B11Z2F03B11 Interoperability Table26SYPNPeriod Number - General LedgerNumericGeneric Edit20
10F03B13Receipts Header16RYPNPeriod Number - General LedgerNumericGeneric Edit20
11F03B13PReceipts Header Purge File16RYPNPeriod Number - General LedgerNumericGeneric Edit20
12F03B13Z2F03B13 Interoperability Table29SYPNPeriod Number - General LedgerNumericGeneric Edit20
13F03B14Receipts Detail17RZPNPeriod 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 Remittance19RDPNPeriod 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 Upload35VLPNPeriod 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
34F06116Z2ESS Timecard History82VMPNPeriod Number - General LedgerNumericGeneric Edit20
35F06278Retro Timecard Detail File68YTPNPeriod Number - General LedgerNumericGeneric Edit20
36F06290Payroll Accounting Journal Work File14YRPNPeriod Number - General LedgerNumericGeneric Edit20
37F063951Payroll Journal (Compressed) File16GLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP07: Payroll
38F05290WF - Payroll Journal (Detail)16JRPNPeriod Number - General LedgerNumericGeneric Edit20
39F07491Payroll - Accounts Payable Summary File22J6PNPeriod Number - General LedgerNumericGeneric Edit20
40F07UI200Timecard History Work File71THPNPeriod Number - General LedgerNumericGeneric Edit20
TOP09: General Accounting
41F0911PPurge - Account Ledger23GLPNPeriod Number - General LedgerNumericGeneric Edit20
42F0911RWF - Account Ledger Reconciliation23GLPNPeriod Number - General LedgerNumericGeneric Edit20
43F0911Z1Journal Entry Transactions - Batch File40VNPNPeriod Number - General LedgerNumericGeneric Edit20
44F0911Z4F0911 Interoperability Table45SZPNPeriod Number - General LedgerNumericGeneric Edit20
45F0912Cost Allocations/Flex Budgeting39RJPNPeriod Number - General LedgerNumericGeneric Edit20
46F0912AIndex Computation Entry File34RIPNPeriod Number - General LedgerNumericGeneric Edit20
47F09UI015Indexed Computations Multi-Tiered Entries23GLPNPeriod Number - General LedgerNumericGeneric Edit20
48F09UI016Account Balance Compare Exceptions8GWPNPeriod Number - General LedgerNumericGeneric Edit20
49F09UI123Advanced Variable Numerator Worktable18VWPNPeriod Number - General LedgerNumericGeneric Edit20
50F52G11Burdening Detail Ledger17BDPNPeriod Number - General LedgerNumericGeneric Edit20
51F52G11WFTemporary Burdened Detail Ledger Workfile17BWPNPeriod Number - General LedgerNumericGeneric Edit20
52F70UI001Work File for G/L by Cat. Code Localization3WAPNPeriod Number - General LedgerNumericGeneric Edit20
53F740911Work File for G/L Report by Category Code Localization3WAPNPeriod Number - General LedgerNumericGeneric Edit20
TOP10: Financial Reporting
54F1001Multi-Site Consolidation Transfer File Header11GPPNPeriod Number - General LedgerNumericGeneric Edit20
55F1001Z1Unedited MSC Interoperability Header Table21IAPNPeriod Number - General LedgerNumericGeneric Edit20
TOP15L: Adv Real Estate Forecasting
56F15L38AREF EP Billing Register10NZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP16: Profit Management (EPS)
57F1611Cost Calculation Transactions13CTPNPeriod Number - General LedgerNumericGeneric Edit20
TOP18: Resource Scheduling
58F186602Labor Rules Tag File78TFPNPeriod Number - General LedgerNumericGeneric Edit20
TOP39: Advanced Stock Valuation
59F39120Temporary Period Build File for Stock Valuation22TFPNPeriod Number - General LedgerNumericGeneric Edit20
TOP41: Inventory Management
60F41UI001Inventory Transactions Detail File158ITPNPeriod Number - General LedgerNumericGeneric Edit20
TOP42: Sales Management
61F42800G1Sales Update G Batch Detail Workfile18DGPNPeriod Number - General LedgerNumericGeneric Edit20
62F42UI800Sales Detail Work File - Sales Update32SDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP43: Procurement
63F43080Approvals Fields Constants40PDPNPeriod Number - General LedgerNumericGeneric Edit20
64F4311Purchase Order Detail File32PDPNPeriod Number - General LedgerNumericGeneric Edit20
65F4311ZPurchase Order Generator File36PWPNPeriod Number - General LedgerNumericGeneric Edit20
66F4311Z1Purchase Order Detail Unedited Transaction Table45SZPNPeriod Number - General LedgerNumericGeneric Edit20
67F4316Purchase Order Multiple Account File15P3PNPeriod Number - General LedgerNumericGeneric Edit20
68F43199P.O. Detail Ledger File - Flexible Version32OLPNPeriod Number - General LedgerNumericGeneric Edit20
TOP43E: Requisition Self Service
69F43E16Requisition Multiple Account File16P3PNPeriod Number - General LedgerNumericGeneric Edit20
TOP44H: Homebuilder Management
70F44H611Bid Details31BDPNPeriod Number - General LedgerNumericGeneric Edit20
71F44H611WBid Details Work File35BWPNPeriod Number - General LedgerNumericGeneric Edit20
72F44H711Lot Start Workfile38SWPNPeriod Number - General LedgerNumericGeneric Edit20
73F44H711ZHB Lot Start Unedited Transaction File51SZPNPeriod Number - General LedgerNumericGeneric Edit20
74F44H71W1Lot Start Generation Workfile38GWPNPeriod Number - General LedgerNumericGeneric Edit20
TOP47: Electronic Commerce
75F47017EDI Purchase Order Detail - Outbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
76F47022EDI P.O. Acknowledgment Detail - Inbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
77F47056EDI Payment Order Header - Outbound37D1PNPeriod Number - General LedgerNumericGeneric Edit20
78F47056WEDI Payment Order Header - Work37D1PNPeriod Number - General LedgerNumericGeneric Edit20
79F47072EDI Receiving Advice Detail - Inbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
80F47077EDI Receiving Advice Detail - Outbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
81F47097EDI Request for Quote Detail - Outbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
82F47102EDI Response to RFQ Detail - Inbound45SZPNPeriod Number - General LedgerNumericGeneric Edit20
83F47137EDI Purchase Order Change Detail - Outbound46SZPNPeriod Number - General LedgerNumericGeneric Edit20
84F47142EDI P.O. Change Acknowledgment Detail - Inbound47SZPNPeriod Number - General LedgerNumericGeneric Edit20
85F47157EDI Shipping Schedule Detail - Outbound47SZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP48S: Service Billing
86F4812Billing Detail Workfile19WDPNPeriod Number - General LedgerNumericGeneric Edit20
87F4812HBilling Workfile History19WDPNPeriod Number - General LedgerNumericGeneric Edit20
88F4812HSBilling Workfile History Purged Save19WDPNPeriod Number - General LedgerNumericGeneric Edit20
89F48S0618Payroll Reclassification Workfile68YTPNPeriod Number - General LedgerNumericGeneric Edit20
90F48S910Billing Detail Journal Workfile9W2PNPeriod Number - General LedgerNumericGeneric Edit20
91F48S911Summarized Journal Workfile10W3PNPeriod Number - General LedgerNumericGeneric Edit20
92F48SUI01Billing Detail Print Workfile19WDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP52: Contract Billing
93F5280Contract Revenue Summary8GWPNPeriod Number - General LedgerNumericGeneric Edit20
94F5280WContract Revenue Summary Work File8GYPNPeriod Number - General LedgerNumericGeneric Edit20
TOP55: Reserved for Clients
95F550200Correspondent Accounts Report7WFPNPeriod Number - General LedgerNumericGeneric Edit20
96F55IF311As Of97RPPNPeriod Number - General LedgerNumericGeneric Edit20
97F55IFTAATarget Area of Businness2TAPNPeriod Number - General LedgerNumericGeneric Edit20
98F55IFTARCustomer Target and Share Info2TAPNPeriod Number - General LedgerNumericGeneric Edit20
99F74T101Check History Table6CHPNPeriod Number - General LedgerNumericGeneric Edit20
100F74T205Checks Collected5CCPNPeriod Number - General LedgerNumericGeneric Edit20
101F74T190Check/Draft Book Seq Number4SNPNPeriod Number - General LedgerNumericGeneric Edit20
102F74T531Customer Ledger Tranaction File7CTPNPeriod Number - General LedgerNumericGeneric Edit20
103F74T532Supplier Ledger Transaction File7SLPNPeriod Number - General LedgerNumericGeneric Edit20
104F74T550General Ledger Work File - Turkish26DKPNPeriod Number - General LedgerNumericGeneric Edit20
105F74T550BGeneral Ledger PO Work File - Turkish5POPNPeriod Number - General LedgerNumericGeneric Edit20
TOP70: Multi-National Products - obsolete-do not reuse
106F704001Payment WH Info TEMP - COMM - 0423PTPNPeriod Number - General LedgerNumericGeneric Edit20
107F704002Payment WH Info - COMM - 0422PFPNPeriod Number - General LedgerNumericGeneric Edit20
108F704002PPayment WH Info Purge - COMM - 0422PFPNPeriod Number - General LedgerNumericGeneric Edit20
109F704003Payment Done - Accum - COMM - 0410PDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP74: EMEA Localization
110F74900Foreign Receivables and Payables - EMEA19RPPNPeriod Number - General LedgerNumericGeneric Edit20
111F74UI92WF - Account Cell Value - EMEA - 7425CVPNPeriod Number - General LedgerNumericGeneric Edit20
TOP74U: United Kingdom Localizations
112F74U0205Payment Profile - 1529P8PNPeriod Number - General LedgerNumericGeneric Edit20
113F74U0420SPC - Application Master - UK - 4326SEPNPeriod Number - General LedgerNumericGeneric Edit20
114F74U0425SPC - Certificate Master - UK - 4327SFPNPeriod Number - General LedgerNumericGeneric Edit20
TOP74Y: Italy - Reporting System Only
115F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B6TIPNPeriod Number - General LedgerNumericGeneric Edit20
TOP75C: China - Reporting System Only
116F75C010WAP & AR XML Workfile - China -75C8AAPNPeriod Number - General LedgerNumericGeneric Edit20
117F75C015Cash Flow Data - China17CFPNPeriod Number - General LedgerNumericGeneric Edit20
118F75C910China Reports Balance -CNAO V23CFPNPeriod Number - General LedgerNumericGeneric Edit20
119F75C911CNAO - E1 Document Number mapping - China19DNPNPeriod Number - General LedgerNumericGeneric Edit20
120F75CUI05AP & AR Multiple Period XML Workfile - China -75C3MPPNPeriod Number - General LedgerNumericGeneric Edit20
TOP76A: Argentina
121F76A392Calculated costs header - 76A4C2PNPeriod Number - General LedgerNumericGeneric Edit20
122F76A393Calculated costs detail - 76A4C3PNPeriod Number - General LedgerNumericGeneric Edit20
123F76A394Adjustments - 76A4C4PNPeriod Number - General LedgerNumericGeneric Edit20
TOP76B: Brazil - Reporting System Only
124F76B0411Voucher Additional Information Brazil - 049VBPNPeriod Number - General LedgerNumericGeneric Edit20
125F76B0770ICMS Period Balance by State and Company5ICPNPeriod Number - General LedgerNumericGeneric Edit20
126F76B0771IPI Period Balance by Company4IPPNPeriod Number - General LedgerNumericGeneric Edit20
127F76B473TF04573 Brazilian Temp WH File - BR - 0411W3PNPeriod Number - General LedgerNumericGeneric Edit20
128F76B943SPED Job Output Detail - BR - 097ODPNPeriod Number - General LedgerNumericGeneric Edit20
129F76B944SPED Job Batches - BR - 092SBPNPeriod Number - General LedgerNumericGeneric Edit20
130F76B947SPED Job Hash Codes - BR - 093SHPNPeriod Number - General LedgerNumericGeneric Edit20
TOP76C: Colombia
131F76C0003VAT Certificates Retention - COL - 76C4CRPNPeriod Number - General LedgerNumericGeneric Edit20
132F76C031AA/R Customer ledger As Of - F76C031A - COL - 0413RPPNPeriod Number - General LedgerNumericGeneric Edit20
133F76C034AA/R Check Detail file As Of - COL - 03B17RZPNPeriod Number - General LedgerNumericGeneric Edit20
134F76C0902Debits and Credits T/B by object account - COL - 76C4GBPNPeriod Number - General LedgerNumericGeneric Edit20
135F76C575Work File Magnetic Media - COL - 0412Q1PNPeriod Number - General LedgerNumericGeneric Edit20
136F76C9415Workfile for Dialy Book - COL - 0920LDPNPeriod Number - General LedgerNumericGeneric Edit20
137F76CT1Tributary Information - COL - 76C11TIPNPeriod Number - General LedgerNumericGeneric Edit20
138F76CT3VAT Certificates Retention - Work File - COL - 76C2T3PNPeriod Number - General LedgerNumericGeneric Edit20
TOP76P: Peru
139F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P3CZPNPeriod Number - General LedgerNumericGeneric Edit20
TOP76V: Venezuela
140F76V4581Withholding Historical File - VEN - 049HRPNPeriod Number - General LedgerNumericGeneric Edit20
141F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 045TDPNPeriod Number - General LedgerNumericGeneric Edit20
TOP79A: Greenhouse Gas Accounting
142F79A11GHG Ledger20GRPNPeriod Number - General LedgerNumericGeneric Edit20
143F79A11Z1GHG Ledger - Batch File38GLPNPeriod Number - General LedgerNumericGeneric Edit20
144F79A12GHG Ledger Audit21GRPNPeriod Number - General LedgerNumericGeneric Edit20
145F79AU11GHG Ledger Work Table23GRPNPeriod Number - General LedgerNumericGeneric Edit20
TOP83: Management Reporting - FASTR
146F83UI001Balance Audit Work File - (Financial Reporting)9R1PNPeriod Number - General LedgerNumericGeneric Edit20
TOP89: Conversion Programs
147F43199ATemp F43199 for ERP 9.0 Upgrade32OLPNPeriod Number - General LedgerNumericGeneric Edit20