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

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