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
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

162 tables920 | 40

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3002IX8116Bill of Material Master FileMaster Files30: Product Data Management
2920F30026IE343Item Cost Component Add-OnsSecondary Master Files30A: Product CostingBusiness Data
3920F3003IR7712Routing Master FileMaster Files30: Product Data ManagementBusiness Data
4920F3009IA501Job Shop Manufacturing ConstantsConstants Files30: Product Data ManagementBusiness Data
5920F3011IZ823Bill of Materials Change FileHistory Files30: Product Data ManagementBusiness Data
6920F3013CY558ECO Parts List DetailSecondary Master Files30: Product Data ManagementBusiness Data
7920F3015CQ134Component Locator FileSecondary Master Files30: Product Data ManagementBusiness Data
8920F30UI001WF331Component Locators Work File"T" Work Files30: Product Data ManagementBusiness Data
9920F30UI002IX143Bill of Material Structure Analysis Work File"T" Work Files30: Product Data ManagementBusiness Data
10920F30UI004WF734Bill of Material Update Work File"T" Work Files30: Product Data ManagementBusiness Data
11920F30UI006IL286Lot Tracking Work FileRegular Work Files41: Inventory ManagementBusiness Data
12920F3405MU72Forecast Consumption PeriodsMaster Files34: Requirements PlanningBusiness Data
13920F3462MB144Forecast Shipment SummaryMaster Files34: Requirements PlanningBusiness Data
14920F4001ZSY1491Batch Receiver File - Order HeadingsBatch Input Files42B: Sales Order EntryBusiness Data
15920F4001Z50HC91Batch Receiver File - Order Headings CommissionsFiles42B: Sales Order Entry
16920F4001ZTXRT91Recurring Order Header Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
17920F40039DT541Document Type MasterSecondary Master Files41: Inventory ManagementBusiness Data
18920F40051RD704Return Material AuthorizationMaster Files42B: Sales Order EntryBusiness Data
19920F40052RV302Return Material Authorization DefaultsTransaction Files42B: Sales Order EntryBusiness Data
20920F4006OA221Order Address InformationTransaction Files40: Inventory/OP BaseBusiness Data
21920F4006ZOY211Batch Order Receiver - Order Address InformationBatch Input Files42B: Sales Order EntryBusiness Data
22920F40070PF172Preference Master FileMaster Files42: Sales ManagementBusiness Data
23920F40071CU132Customer Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
24920F40072GI132Item Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
25920F40073HY332Preference Hierarchy FileSecondary Master Files42: Sales ManagementBusiness Data
26920F4009CP501Distribution/Manufacturing ConstantsConstants Files41: Inventory ManagementBusiness Data
27920F40095DL81Default Locations/PrintersConstants Files41: Inventory ManagementBusiness Data
28920F40096DQ31Default Print QueuesConstants Files41: Inventory ManagementBusiness Data
29920F4009T1CT101Distribution/Manufacturing Constant Tag TableConstants Files41: Inventory Management
30920F4011ZSZ2511Batch Receiver File - Order DetailsBatch Input Files42B: Sales Order EntryBusiness Data
31920F4011Z60DC111Batch Receiver File - Order Details CommissionsFiles42B: Sales Order Entry
32920F4011ZTXZT201Recurring Order Detail Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
33920F4012ZSP381Batch Receiver File - Destination QuantityBatch Input Files42B: Sales Order EntryBusiness Data
34920F4012ZWSP431WF - Destination QuantityRegular Work Files42B: Sales Order EntryBusiness Data
35920F4013SX101Order Processing Cross Reference FileExtra Features Files40: Inventory/OP BaseBusiness Data
36920F4013ZKS211Kit Components Batch FileBatch Input Files42B: Sales Order EntryBusiness Data
37920F4015OT172Order TemplatesTransaction Files40: Inventory/OP BaseBusiness Data
38920F4016TU113Print MessagesExtra Features Files41: Inventory ManagementBusiness Data
39920F4017TV101Print Message Report DefaultsExtra Features Files41: Inventory ManagementBusiness Data
40920F40203FS151Order Activity RulesConstants Files40: Inventory/OP BaseBusiness Data
41920F40205LF381Line Type Control Constants FileConstants Files40: Inventory/OP BaseBusiness Data
42920F40205TOI192Line Type Control Constants Tag FileConstants Files40: Inventory/OP BaseBusiness Data
43920F40241CD21UNSPSC Commodity CodeFiles43B: Voucher Match and Landed Cost
44920F40241DCA91UNSPSC Code Alternate DescriptionFiles43B: Voucher Match and Landed Cost
45920F40243CR42Commodity RelationshipFiles43B: Voucher Match and Landed Cost
46920F40300RPM312Preference Resolution History - MasterExtra Features Files42: Sales ManagementBusiness Data
47920F40301PT261Preference Profile - Payment TermsExtra Features Files42B: Sales Order Entry
48920F40301RPT262Preference Resolution Ledger - Payment TermsExtra Features Files42B: Sales Order EntryBusiness Data
49920F40302PU261Preference Profile - Unit of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
50920F40302RPU242Preference Resolution Ledger - Pricing Unit Of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
51920F40303RV261Preference Profile - Revenue Cost CenterExtra Features Files42B: Sales Order EntryBusiness Data
52920F40303RRV242Preference Resolution Ledger - Revenue Business UnitExtra Features Files42B: Sales Order EntryBusiness Data
53920F40304PE241Preference Profile - End UseExtra Features Files42B: Sales Order EntryBusiness Data
54920F40304RPE252Preference Resolution Ledger - End UseExtra Features Files42B: Sales Order EntryBusiness Data
55920F40305RM301Preference Profile - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
56920F40305RRM262Preference Resolution Ledger - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
57920F40306SR311Preference Profile - Inventory SourcingExtra Features Files42: Sales ManagementBusiness Data
58920F40307LA291Preference Profile - Product AllocationsExtra Features Files42B: Sales Order EntryBusiness Data
59920F40308GS271Preference Profile - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
60920F40308RGS282Preference Resolution Ledger - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
61920F40309DY291Preference Profile - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
62920F40309RDY302Preference Resolution Ledger - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
63920F40310LB231Preference Profile - Line of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
64920F40310RLB242Preference Resolution Ledger - Line Of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
65920F40311P1231Preference Profile - Price Code 1Extra Features Files42B: Sales Order EntryBusiness Data
66920F40311RP1242Preference Resolution Ledger - User Defined Price Code #1Extra Features Files42B: Sales Order EntryBusiness Data
67920F40312P2231Preference Profile - Price Code 2Extra Features Files42B: Sales Order EntryBusiness Data
68920F40312RP2242Preference Resolution Ledger - User Defined Price Code #2Extra Features Files42B: Sales Order EntryBusiness Data
69920F40313P3231Preference Profile - Price Code 3Extra Features Files42B: Sales Order EntryBusiness Data
70920F40313RP3242Preference Resolution Ledger - User Defined Price Code #3Extra Features Files42B: Sales Order EntryBusiness Data
71920F40314PJ241Preference Profile - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
72920F40314RPJ262Preference Resolution Ledger - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
73920F40315PI241Preference Profile - Invoice CyclingExtra Features Files42: Sales ManagementBusiness Data
74920F40315RPI262Preference Resolution Ledger - Invoice CycleExtra Features Files42: Sales ManagementBusiness Data
75920F40316OP261Preference Profile - Order PreparationExtra Features Files42B: Sales Order EntryBusiness Data
76920F40316ROP272Preference Resolution Ledger - Order Preparation DaysExtra Features Files42B: Sales Order EntryBusiness Data
77920F40318RQC712Preference Resolution Ledger - Quality ManagementExtra Features Files37: Quality ManagementBusiness Data
78920F40320LP412Preference Profile - Multi Shipping/Receiving LocationsExtra Features Files46: Warehouse ManagementBusiness Data
79920F40320RLP423Preference Resolution Ledger - Multi ShiP/Rec LocationsExtra Features Files46: Warehouse ManagementBusiness Data
80920F40329DD281Preference Profile - Document DistributionExtra Features Files49: Transportation ManagementBusiness Data
81920F40330DG311Preference Profile - Document SetExtra Features Files49: Transportation ManagementBusiness Data
82920F40331OE251Preference Profile - Options and EquipmentExtra Features Files49: Transportation ManagementBusiness Data
83920F40332CF321Preference Profile - Customer FreightExtra Features Files49: Transportation ManagementBusiness Data
84920F40333CA362Preference Profile - CarrierExtra Features Files49: Transportation ManagementBusiness Data
85920F40334MT321Preference Profile - Mode of TransportExtra Features Files49: Transportation ManagementBusiness Data
86920F40338PT251Preference Profile - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
87920F40338RPT272Preference Resolution Ledger - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
88920F40339LA291Preference Profile - Product Allocations (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
89920F40341NS271Preference Profile - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
90920F40341RNS292Preference Resolution Ledger - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
91920F40344SA311Preference Profile - Sales CommissionExtra Features Files42: Sales ManagementBusiness Data
92920F40344RSA312Preference Resolution Ledger - Sales CommissionExtra Features Files42B: Sales Order EntryBusiness Data
93920F40345CR241Preference Profile - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
94920F40345RCR262Preference Resolution Ledger - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
95920F40347RI261Preference Profile - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
96920F40347RRI282Preference Resolution Ledger - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
97920F40349RV261Preference Profile - Revenue Business Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
98920F40349RRV282Preference Resolution Ledger - Revenue Bus Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
99920F40350OQ281Preference Profiles - Conatiner Deposit/RentalExtra Features Files41: Inventory ManagementBusiness Data
100920F40500CC254Commodity Structure DefinitionsFiles40: Inventory/OP Base
101920F40510UC92UNSPSC and Commodity Structure RelationshipFiles40: Inventory/OP Base
102920F40520SC93Supplier and Commodity Structure RelationshipFiles40: Inventory/OP Base
103920F40530SX104Supplier Commodity Structure Cross ReferenceFiles40: Inventory/OP Base
104920F40540IC82Item and Commodity Structure RelationshipFiles40: Inventory/OP Base
105920F40551GL92G/L Account and Commodity Structure RelationshipFiles40: Inventory/OP Base
106920F40711PD132Preference Values DefinitionFiles45: Advanced PricingBusiness Data
107920F40721PV152Preference Values DetailFiles45: Advanced PricingBusiness Data
108920F40741PH181Preference Adjustment HistoryFiles40: Inventory/OP BaseBusiness Data
109920F4080RO448Related Order Cross Reference TableFiles31P: Engineer To Order
110920F4090MK41Distribution/Manufacturing - AAI Record TypeConstants Files40: Inventory/OP BaseBusiness Data
111920F4091KF501Category Code Key Position FileMaster Files40: Inventory/OP BaseBusiness Data
112920F4092GP131Group Code Key Definition TableMaster Files45: Advanced PricingBusiness Data
113920F4093GD131Item/Customer Group RelationshipMaster Files45: Advanced PricingBusiness Data
114920F4094KI112Item/Customer Key ID Master FileMaster Files45: Advanced PricingBusiness Data
115920F40941IK122Item Key ID Master FileFiles45: Advanced PricingBusiness Data
116920F40942CK122Customer Key ID Master FileFiles45: Advanced PricingBusiness Data
117920F40943OK102Order Group Key ID Master FileFiles45: Advanced PricingBusiness Data
118920F4095ML91Distribution/Manufacturing - AAI ValuesConstants Files40: Inventory/OP BaseBusiness Data
119920F40P01PH263Promotion Header FileFiles40: Inventory/OP BaseBusiness Data
120920F40P011PD462Promotion Deal Detail FileFiles40: Inventory/OP BaseBusiness Data
121920F40UI002UT191Supplier History Rebuild -workfileRegular Work Files43: ProcurementBusiness Data
122920F40UI00TPN291Tax Work FileRegular Work Files40: Inventory/OP BaseBusiness Data
123920F40UI17ZG221Allocation Work FileRegular Work Files42B: Sales Order EntryBusiness Data
124920F40UI74AW811Price Adjustment History Work FileRegular Work Files45: Advanced PricingBusiness Data
125920F40UI801ZB172Generic Error TableBatch Input Files40: Inventory/OP BaseBusiness Data
126920F4100LM626Location MasterMaster Files41: Inventory ManagementBusiness Data
127920F41001CI1082Inventory ConstantsConstants Files41: Inventory ManagementBusiness Data
128920F41002UM166Item Units of Measure Conversion FactorsConstants Files41: Inventory ManagementBusiness Data
129920F41003UC101Unit of Measure standard conversionConstants Files41: Inventory ManagementBusiness Data
130920F41011PK371Bulk Item MasterMaster Files41B: Bulk Stock ManagementBusiness Data
131920F41015BA122Item Duplication Work FileMaster Files41: Inventory ManagementBusiness Data
132920F41022PN241Bulk Depot/Product InformationMaster Files41B: Bulk Stock ManagementBusiness Data
133920F4104IV305Item Cross Reference FileExtra Features Files41: Inventory ManagementBusiness Data
134920F4106BP327Item Base Price FileMaster Files45: Advanced PricingBusiness Data
135920F4106NCSZ321Base Price ExtractionFiles45: Advanced PricingBusiness Data
136920F4108IO626Lot MasterSecondary Master Files41: Inventory ManagementBusiness Data
137920F41112IN492Item ASOF FileTransaction Files41: Inventory ManagementBusiness Data
138920F41500PP624Tank Master FileMaster Files41B: Bulk Stock ManagementBusiness Data
139920F41508PC247Default Tank InformationTransaction Files41B: Bulk Stock ManagementBusiness Data
140920F4170I081Lot Status Activity RulesFiles41: Inventory ManagementBusiness Data
141920F4171I1161Critical Hold ManagementFiles41: Inventory ManagementBusiness Data
142920F42008HC122Order Hold ConstantsConstants Files40: Inventory/OP BaseBusiness Data
143920F4201Z1SY1453Sales Order Header Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
144920F4207PM332Price by ItemExtra Features Files45: Advanced PricingBusiness Data
145920F4208PG92Price by CustomerExtra Features Files45: Advanced PricingBusiness Data
146920F4209HO277Held OrdersTransaction Files40: Inventory/OP BaseBusiness Data
147920F4211AUAU581Sales Order Detail Audit FileHistory Files42: Sales ManagementBusiness Data
148920F4211DTDT581Sales Order Detail Date Tracking FileHistory Files42B: Sales Order EntryBusiness Data
149920F4211Z1SZ2533Sales Order Detail Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
150920F4215XH747Shipment HeaderTransaction Files49: Transportation ManagementBusiness Data
151920F4217XI135Shipment Reference NumbersTransaction Files49: Transportation ManagementBusiness Data
152920F4220SW336Basic Serial NumbersExtra Features Files42: Sales ManagementBusiness Data
153920F4231EF122RT Event Filter DetailsFiles42: Sales Management
154920F4314JM71Sales Order/Purchasing Text Detail LinesExtra Features Files40: Inventory/OP BaseBusiness Data
155920F43800PR271Summary Voucher MatchTransaction Files43B: Voucher Match and Landed CostBusiness Data
156920F46010IP292Item ProfileSecondary Master Files46: Warehouse ManagementBusiness Data
157920F49080IC51Invoice Cycle CalculationExtra Features Files42: Sales ManagementBusiness Data
158920F49085ID52Scheduled Invoice DateExtra Features Files42: Sales ManagementBusiness Data
159920F49190DS171Document Definition File (Conversion from World File)Extra Features Files49: Transportation ManagementBusiness Data
160920F49211UD1454Sales Order Detail File - Tag FileExtra Features Files42: Sales ManagementBusiness Data
161920F49211Z1S11603Sales Order Detail Tag Unedited Transaction FileExtra Features Files42: Sales ManagementBusiness Data
162920F49219UD1181Sales Order Detail - Tag History FileExtra Features Files42: Sales ManagementBusiness Data