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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

107 tables812 | 47

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F47002SV51Flat File Cross-Reference TableConstants Files47: Electronic CommerceAS400 Coexistence Tables
2812F47003SX181EDI Discrepancy Report Work FileRegular Work Files47: Electronic CommerceAS400 Coexistence Tables
3812F47011SY1651EDI Purchase Order Header - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
4812F4701150PH91EDI Purchase Order Header Commission InboundFiles42B: Sales Order Entry
5812F47012SZ2521EDI Purchase Order Detail - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
6812F4701260PD111EDI Purchase Order Detail Commission InboundFiles42B: Sales Order Entry
7812F47013SP471EDI Purchase Order Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
8812F47016SY1111EDI Purchase Order Header - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
9812F470161S3761EDI Purchase Order Additional Header - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
10812F47017SZ2211EDI Purchase Order Detail - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
11812F470171S4571EDI Purchase Order Additional Detail - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
12812F47021SY1101EDI P.O. Acknowledgment Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
13812F47022SZ2211EDI P.O. Acknowledgment Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
14812F47026SY1431EDI P.O. Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
15812F47027SZ2521EDI P.O. Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
16812F47031SY1051EDI Shipping Notice Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
17812F47032SZ1751EDI Shipping Notice Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
18812F47032TSZ311EDI Shipping Notice Detail- Inbound TagBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
19812F47036SY812EDI Shipping Notice Header - OutboundBatch Input Files49: Transportation ManagementAS400 Coexistence Tables
20812F47037SZ2131EDI Shipping Notice Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
21812F470371SZ2524EDI Shipping Notice Detail - OutboundBatch Input Files49: Transportation ManagementNo
22812F470372AI793EDI ASN Demand Scheduling DetailFiles47: Electronic Commerce
23812F470373AG662EDI ASN ShippingFiles47: Electronic Commerce
24812F470374AM391EDI ASN Demand AddressesFiles47: Electronic Commerce
25812F470375AK471EDI ASN Packaging DetailFiles47: Electronic Commerce
26812F47041SY651EDI Invoice Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
27812F47042SZ1041EDI Invoice Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
28812F47044SW551EDI Invoice Summary - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
29812F47046SY1483EDI Invoice Header (Sales) - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
30812F470461S3662EDI Invoice Additional Header - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
31812F470462S5541EDI Invoice Expanded Header (Sales)Files42: Sales Management
32812F47047SZ2522EDI Invoice Detail (Sales) - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
33812F470471S4491EDI Invoice Additional Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
34812F470472S6831EDI Invoice Expanded Detail (Sales)Files42: Sales Management
35812F470473S7511EDI Invoice Detail ChargesFiles42: Sales Management
36812F47056D1701EDI Payment Order Header - OutboundBatch Input Files04: Accounts PayableAS400 Coexistence Tables
37812F470561D2441EDI Payment Order Bank N and A - OutboundBatch Input Files04: Accounts PayableAS400 Coexistence Tables
38812F470561WD2441EDI Payment Order Bank N and A - WorkRegular Work Files04: Accounts PayableAS400 Coexistence Tables
39812F470562D4441EDI Payment Order Vendor N and A - OutboundBatch Input Files04: Accounts PayableAS400 Coexistence Tables
40812F470562WD4441EDI Payment Order Vendor N and A - WorkRegular Work Files04: Accounts PayableAS400 Coexistence Tables
41812F470563D5441EDI Payment Order Payee N and A - OutboundBatch Input Files04: Accounts PayableAS400 Coexistence Tables
42812F470563WD5441EDI Payment Order Payee N and A - WorkRegular Work Files04: Accounts PayableAS400 Coexistence Tables
43812F47056WD1701EDI Payment Order Header - WorkRegular Work Files04: Accounts PayableAS400 Coexistence Tables
44812F47057D31211EDI Payment Order Remittance Advice - OutboundBatch Input Files04: Accounts PayableAS400 Coexistence Tables
45812F47057WD31211EDI Payment Order Remittance Advice - WorkRegular Work Files04: Accounts PayableAS400 Coexistence Tables
46812F4706ZA332EDI Order Address InformationTransaction Files47: Electronic CommerceAS400 Coexistence Tables
47812F47061MJ411EDI Planning Schedule Header - InboundBatch Input Files34: Requirements PlanningAS400 Coexistence Tables
48812F47062MY381EDI Planning Schedule Detail - InboundBatch Input Files34: Requirements PlanningAS400 Coexistence Tables
49812F47066MJ411EDI Planning Schedule Header - OutboundBatch Input Files34: Requirements PlanningAS400 Coexistence Tables
50812F47067MY381EDI Planning Schedule Detail - OutboundBatch Input Files34: Requirements PlanningAS400 Coexistence Tables
51812F47071SY1111EDI Receiving Advice Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
52812F47072SZ2531EDI Receiving Advice Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
53812F47076SY1101EDI Receiving Advice Header - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
54812F47077SZ2391EDI Receiving Advice Detail - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
55812F47081FV421EDI Price Sales Catalog Header - InboundBatch Input Files43: ProcurementBusiness Data
56812F47082FY871EDI Price Sales Catalog Detail - InboundBatch Input Files43: ProcurementBusiness Data
57812F47091SY1401EDI Request for Quote Header - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
58812F4709150QH91EDI Request for Quote Header Commission - InboundFiles42B: Sales Order Entry
59812F47092SZ2521EDI Request for Quote Detail - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
60812F4709260QD111EDI Request for Quote Detail Commission - InboundFiles42B: Sales Order Entry
61812F47093SP471EDI Request for Quote Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
62812F47096SY1091EDI Request for Quote Header - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
63812F47097SZ2211EDI Request for Quote Detail - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
64812F47098SZ221EDI RFQ Detail Quantity - OutboundBatch Input Files43: ProcurementBusiness Data
65812F47101SY1111EDI Response to RFQ Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
66812F47102SZ2211EDI Response to RFQ Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
67812F47103SZ221EDI Response to RFQ Detail Quantity - InboundBatch Input Files43: ProcurementBusiness Data
68812F47106SY1431EDI Response to RFQ Header - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
69812F471061S3661EDI Response to RFQ Additional Header - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
70812F47107SZ2521EDI Response to RFQ Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
71812F471071S4491EDI Response to RFQ Additional Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
72812F47111Z1262EDI Lockbox/Payment Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
73812F47112Z2371EDI Lockbox Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
74812F47113Z3401EDI Lockbox/Payment Detail - BatchBatch Input Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
75812F47114Z4451EDI Lockbox/Payment Detail - PaymentBatch Input Files03B: Enhanced Accounts ReceivableAS400 Coexistence Tables
76812F47121M1301EDI Product Activity Data Header - InboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
77812F47122MJ861EDI Product Activity Data Detail - InboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
78812F47123MK571EDI Product Activity Data (SDQ) - InboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
79812F47126M1301EDI Product Activity Data Header - OutboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
80812F47127MJ881EDI Product Activity Data Detail - OutboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
81812F47128MK571EDI Product Activity Data (SDQ) - OutboundBatch Input Files41: Inventory ManagementAS400 Coexistence Tables
82812F47131SY1621EDI Purchase Order Change Header - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
83812F4713150CH91EDI Purchase Order Change Header Commission - InboundFiles42B: Sales Order Entry
84812F47132SZ2531EDI Purchase Order Change Detail - InboundBatch Input Files42B: Sales Order EntryAS400 Coexistence Tables
85812F4713260PD111EDI Purchase Order Change Detail Commission - InboundFiles42B: Sales Order Entry
86812F47136SY1111EDI Purchase Order Change Header - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
87812F47137SZ1891EDI Purchase Order Change Detail - OutboundBatch Input Files43: ProcurementAS400 Coexistence Tables
88812F4714ZT221EDI Order Text Lines - HeaderExtra Features Files47: Electronic CommerceAS400 Coexistence Tables
89812F47141SY1111EDI P.O. Change Acknowledgment Header - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
90812F471411SZ151Purchase Order Edit Object Log TableBatch Input Files43: ProcurementBusiness Data
91812F47142SZ2231EDI P.O. Change Acknowledgment Detail - InboundBatch Input Files43: ProcurementAS400 Coexistence Tables
92812F47146SY1431EDI P.O. Change Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
93812F47147SZ2541EDI P.O. Change Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementAS400 Coexistence Tables
94812F4715ZD221EDI Order Text Lines - DetailExtra Features Files47: Electronic CommerceAS400 Coexistence Tables
95812F47156SY1043EDI Shipping Schedule Header - OutboundTransaction Files31: Shop Floor ControlNo
96812F47157SZ2182EDI Shipping Schedule Detail - OutboundTransaction Files31: Shop Floor ControlNo
97812F4716SZ301EDI Item Text - Inbound/OutboundBatch Input Files43: ProcurementBusiness Data
98812F47191AH561EDI Acknowledgement HeaderFiles47: Electronic Commerce
99812F47192AE271EDI Acknowledgement Error DetailFiles47: Electronic CommerceBusiness Data
100812F47194AR201EDI Acknowledgement ReferencesFiles47: Electronic CommerceBusiness Data
101812F47196AA221EDI Acknowledgement Name And AddressFiles47: Electronic CommerceBusiness Data
102812F47198AN201EDI Acknowledgement NotesFiles47: Electronic CommerceBusiness Data
103812F4722PZ111EDI Tolerance RulesConstants Files47: Electronic CommerceAS400 Coexistence Tables
104812F4780AX231Address Cross-ReferenceExtra Features Files45: Advanced PricingNo
105812F47CTLZ5291EDI Lockbox/Payment Work FileWork Files03B: Enhanced Accounts ReceivableNo
106812F47HLHL181Hierarchical ConfigurationSecondary Master Files49: Transportation ManagementNo
107812F47UI001SZ561ASN Extract Work FileBatch Input Files42: Sales ManagementNo