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

119 tables920 | 47

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0101GGL182Global location number for address bookFiles47: Electronic Commerce
2920F47002SV51Flat File Cross-Reference TableConstants Files47: Electronic CommerceBusiness Data
3920F47003SX181EDI Discrepancy Report Work FileRegular Work Files47: Electronic CommerceBusiness Data
4920F47006ST251EDI Order Header - Outbound Tax TableFiles42: Sales Management
5920F47007DT331EDI Order Detail - Outbound Tax TableFiles42: Sales Management
6920F47011SY2111EDI Purchase Order Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
7920F4701150PH91EDI Purchase Order Header Commission InboundFiles42B: Sales Order Entry
8920F47011TXST241EDI Purchase Order Header Tax - InboundBatch Input Files42B: Sales Order EntryBusiness Data
9920F47012SZ2671EDI Purchase Order Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
10920F4701260PD111EDI Purchase Order Detail Commission InboundFiles42B: Sales Order Entry
11920F47012TXDT301EDI Purchase Order Detail Tax - InboundBatch Input Files42B: Sales Order Entry
12920F47013SP571EDI Purchase Order Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryBusiness Data
13920F47016SY1521EDI Purchase Order Header - OutboundBatch Input Files43: ProcurementBusiness Data
14920F470161S3771EDI Purchase Order Additional Header - OutboundBatch Input Files43: ProcurementBusiness Data
15920F47017SZ2341EDI Purchase Order Detail - OutboundBatch Input Files43: ProcurementBusiness Data
16920F470171S4581EDI Purchase Order Additional Detail - OutboundBatch Input Files43: ProcurementBusiness Data
17920F47021SY1161EDI P.O. Acknowledgment Header - InboundBatch Input Files43: ProcurementBusiness Data
18920F47022SZ2261EDI P.O. Acknowledgment Detail - InboundBatch Input Files43: ProcurementBusiness Data
19920F47026SY1531EDI P.O. Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
20920F47027SZ2571EDI P.O. Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
21920F47031SY1101EDI Shipping Notice Header - InboundBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
22920F47032SZ1821EDI Shipping Notice Detail - InboundBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
23920F47032TSZ311EDI Shipping Notice Detail- Inbound TagBatch Input Files43A: Purchase Order Receipt/RoutingBusiness Data
24920F47036SY862EDI Shipping Notice Header - OutboundBatch Input Files49: Transportation ManagementBusiness Data
25920F47036XST201EDI Shipping Notice Header Tax - OutboundBatch Input Files49: Transportation Management
26920F47037SZ2171EDI Shipping Notice Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
27920F470371SZ2584EDI Shipping Notice Detail - OutboundBatch Input Files49: Transportation ManagementBusiness Data
28920F470371XDT341EDI Shipping Notice Detail Tax - OutboundBatch Input Files49: Transportation Management
29920F470372AI793EDI ASN Demand Scheduling DetailFiles47: Electronic Commerce
30920F470373AG662EDI ASN ShippingFiles47: Electronic Commerce
31920F470374AM391EDI ASN Demand AddressesFiles47: Electronic Commerce
32920F470375AK471EDI ASN Packaging DetailFiles47: Electronic Commerce
33920F47041SY691EDI Invoice Header - InboundBatch Input Files43: ProcurementBusiness Data
34920F47042SZ1101EDI Invoice Detail - InboundBatch Input Files43: ProcurementBusiness Data
35920F47044SW561EDI Invoice Summary - InboundBatch Input Files43: ProcurementBusiness Data
36920F47046SY1583EDI Invoice Header (Sales) - OutboundBatch Input Files42: Sales Management
37920F470461S3672EDI Invoice Additional Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
38920F470462S5561EDI Invoice Expanded Header (Sales)Files42: Sales Management
39920F47047SZ2602EDI Invoice Detail (Sales) - OutboundBatch Input Files42: Sales Management
40920F470471S4501EDI Invoice Additional Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
41920F470472S6851EDI Invoice Expanded Detail (Sales)Files42: Sales Management
42920F470473S7511EDI Invoice Detail ChargesFiles42: Sales Management
43920F47056D1701EDI Payment Order Header - OutboundBatch Input Files04: Accounts PayableBusiness Data
44920F470561D2441EDI Payment Order Bank N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
45920F470561WD2441EDI Payment Order Bank N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
46920F470562D4441EDI Payment Order Vendor N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
47920F470562WD4441EDI Payment Order Vendor N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
48920F470563D5441EDI Payment Order Payee N & A - OutboundBatch Input Files04: Accounts PayableBusiness Data
49920F470563WD5441EDI Payment Order Payee N & A - WorkRegular Work Files04: Accounts PayableBusiness Data
50920F47056WD1701EDI Payment Order Header - WorkRegular Work Files04: Accounts PayableBusiness Data
51920F47057D31211EDI Payment Order Remittance Advice - OutboundBatch Input Files04: Accounts PayableBusiness Data
52920F47057WD31211EDI Payment Order Remittance Advice - WorkRegular Work Files04: Accounts PayableBusiness Data
53920F4706ZA342EDI Order Address InformationTransaction Files47: Electronic CommerceBusiness Data
54920F47061MJ421EDI Planning Schedule Header - InboundBatch Input Files34: Requirements PlanningBusiness Data
55920F47062MY381EDI Planning Schedule Detail - InboundBatch Input Files34: Requirements PlanningBusiness Data
56920F47066MJ421EDI Planning Schedule Header - OutboundBatch Input Files34: Requirements PlanningBusiness Data
57920F47067MY381EDI Planning Schedule Detail - OutboundBatch Input Files34: Requirements PlanningBusiness Data
58920F47071SY1161EDI Receiving Advice Header - InboundBatch Input Files43: ProcurementBusiness Data
59920F47072SZ2591EDI Receiving Advice Detail - InboundBatch Input Files43: ProcurementBusiness Data
60920F47076SY1141EDI Receiving Advice Header - OutboundBatch Input Files43: ProcurementBusiness Data
61920F47077SZ2451EDI Receiving Advice Detail - OutboundBatch Input Files43: ProcurementBusiness Data
62920F47081FV421EDI Price Sales Catalog Header - InboundBatch Input Files43: ProcurementBusiness Data
63920F47082FY871EDI Price Sales Catalog Detail - InboundBatch Input Files43: ProcurementBusiness Data
64920F47091SY1501EDI Request for Quote Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
65920F4709150QH91EDI Request for Quote Header Commission - InboundFiles42B: Sales Order Entry
66920F47091TXST241EDI Request for Quote Header Tax - InboundBatch Input Files42B: Sales Order Entry
67920F47092SZ2581EDI Request for Quote Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
68920F4709260QD111EDI Request for Quote Detail Commission - InboundFiles42B: Sales Order Entry
69920F47093SP571EDI Request for Quote Detail (SDQ) - InboundBatch Input Files42B: Sales Order EntryBusiness Data
70920F47096SY1131EDI Request for Quote Header - OutboundBatch Input Files43: ProcurementBusiness Data
71920F47097SZ2251EDI Request for Quote Detail - OutboundBatch Input Files43: ProcurementBusiness Data
72920F47098SZ231EDI RFQ Detail Quantity - OutboundBatch Input Files43: ProcurementBusiness Data
73920F47101SY1111EDI Response to RFQ Header - InboundBatch Input Files43: ProcurementBusiness Data
74920F47102SZ2211EDI Response to RFQ Detail - InboundBatch Input Files43: ProcurementBusiness Data
75920F47103SZ221EDI Response to RFQ Detail Quantity - InboundBatch Input Files43: ProcurementBusiness Data
76920F47106SY1511EDI Response to RFQ Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
77920F471061S3671EDI Response to RFQ Additional Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
78920F47107SZ2571EDI Response to RFQ Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
79920F471071S4501EDI Response to RFQ Additional Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
80920F47111Z1262EDI Lockbox/Payment Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
81920F47112Z2371EDI Lockbox Header - TransactionBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
82920F47113Z3401EDI Lockbox/Payment Detail - BatchBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
83920F47114Z4451EDI Lockbox/Payment Detail - PaymentBatch Input Files03B: Enhanced Accounts ReceivableBusiness Data
84920F47121M1311EDI Product Activity Data Header - InboundBatch Input Files41: Inventory ManagementBusiness Data
85920F47122MJ901EDI Product Activity Data Detail - InboundBatch Input Files41: Inventory ManagementBusiness Data
86920F47123MK571EDI Product Activity Data (SDQ) - InboundBatch Input Files41: Inventory ManagementBusiness Data
87920F47126M1311EDI Product Activity Data Header - OutboundBatch Input Files41: Inventory ManagementBusiness Data
88920F47127MJ891EDI Product Activity Data Detail - OutboundBatch Input Files41: Inventory ManagementBusiness Data
89920F47128MK571EDI Product Activity Data (SDQ) - OutboundBatch Input Files41: Inventory ManagementBusiness Data
90920F47131SY1731EDI Purchase Order Change Header - InboundBatch Input Files42B: Sales Order EntryBusiness Data
91920F4713150CH91EDI Purchase Order Change Header Commission - InboundFiles42B: Sales Order Entry
92920F47131TXST241EDI Purchase Order Change Header Tax - InboundBatch Input Files42B: Sales Order Entry
93920F47132SZ2591EDI Purchase Order Change Detail - InboundBatch Input Files42B: Sales Order EntryBusiness Data
94920F4713260PD111EDI Purchase Order Change Detail Commission - InboundFiles42B: Sales Order Entry
95920F47132TXDT301EDI Purchase Order Change Detail Tax - InboundBatch Input Files42B: Sales Order Entry
96920F47136SY1161EDI Purchase Order Change Header - OutboundBatch Input Files43: ProcurementBusiness Data
97920F47137SZ1921EDI Purchase Order Change Detail - OutboundBatch Input Files43: ProcurementBusiness Data
98920F4714ZT221EDI Order Text Lines - HeaderExtra Features Files47: Electronic CommerceBusiness Data
99920F47141SY1161EDI P.O. Change Acknowledgment Header - InboundBatch Input Files43: ProcurementBusiness Data
100920F471411SZ151Purchase Order Edit Object Log TableBatch Input Files43: ProcurementBusiness Data
101920F47142SZ2281EDI P.O. Change Acknowledgment Detail - InboundBatch Input Files43: ProcurementBusiness Data
102920F47146SY1511EDI P.O. Change Acknowledgment Header - OutboundBatch Input Files42: Sales ManagementBusiness Data
103920F47147SZ2591EDI P.O. Change Acknowledgment Detail - OutboundBatch Input Files42: Sales ManagementBusiness Data
104920F4715ZD221EDI Order Text Lines - DetailExtra Features Files47: Electronic CommerceBusiness Data
105920F47156SY1083EDI Shipping Schedule Header - OutboundTransaction Files31: Shop Floor ControlBusiness Data
106920F47157SZ2222EDI Shipping Schedule Detail - OutboundTransaction Files31: Shop Floor ControlBusiness Data
107920F4716SZ301EDI Item Text - Inbound/OutboundBatch Input Files43: ProcurementBusiness Data
108920F47181EH281EDI Consumption Header (FUTURE)Files41: Inventory Management
109920F47182ED371EDI Consumption Detail (FUTURE)Files41: Inventory Management
110920F47191AH581EDI Acknowledgement HeaderFiles47: Electronic Commerce
111920F47192AE271EDI Acknowledgement Error DetailFiles47: Electronic CommerceBusiness Data
112920F47194AR201EDI Acknowledgement ReferencesFiles47: Electronic CommerceBusiness Data
113920F47196AA221EDI Acknowledgement Name And AddressFiles47: Electronic CommerceBusiness Data
114920F47198AN201EDI Acknowledgement NotesFiles47: Electronic CommerceBusiness Data
115920F4722PZ121EDI Tolerance RulesConstants Files47: Electronic CommerceBusiness Data
116920F4780AX231Address Cross-ReferenceExtra Features Files45: Advanced PricingBusiness Data
117920F47CTLZ5291EDI Lockbox/Payment Work FileWork Files03B: Enhanced Accounts ReceivableBusiness Data
118920F47HLHL181Hierarchical ConfigurationSecondary Master Files49: Transportation ManagementBusiness Data
119920F47UI001SZ601ASN Extract Work FileBatch Input Files42: Sales ManagementBusiness Data