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

161 tables910 | 40

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F3002IX8115Bill of Material Master FileMaster Files30: Product Data Management
2910F30026IE343Item Cost Component Add-OnsSecondary Master Files30A: Product CostingBusiness Data
3910F3003IR7711Routing Master FileMaster Files30: Product Data ManagementBusiness Data
4910F3009IA501Job Shop Manufacturing ConstantsConstants Files30: Product Data ManagementBusiness Data
5910F3011IZ823Bill of Materials Change FileHistory Files30: Product Data ManagementBusiness Data
6910F3013CY558ECO Parts List DetailSecondary Master Files30: Product Data ManagementBusiness Data
7910F3015CQ134Component Locator FileSecondary Master Files30: Product Data ManagementBusiness Data
8910F30UI001WF331Component Locators Work File"T" Work Files30: Product Data ManagementBusiness Data
9910F30UI002IX143Bill of Material Structure Analysis Work File"T" Work Files30: Product Data ManagementBusiness Data
10910F30UI004WF712Bill of Material Update Work File"T" Work Files30: Product Data ManagementBusiness Data
11910F30UI006IL286Lot Tracking Work FileRegular Work Files41: Inventory ManagementBusiness Data
12910F3405MU72Forecast Consumption PeriodsMaster Files34: Requirements PlanningBusiness Data
13910F3462MB144Forecast Shipment SummaryMaster Files34: Requirements PlanningBusiness Data
14910F4001ZSY1491Batch Receiver File - Order HeadingsBatch Input Files42B: Sales Order EntryBusiness Data
15910F4001Z50HC91Batch Receiver File - Order Headings CommissionsFiles42B: Sales Order Entry
16910F4001ZTXRT91Recurring Order Header Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
17910F40039DT541Document Type MasterSecondary Master Files41: Inventory ManagementBusiness Data
18910F40051RD704Return Material AuthorizationMaster Files42B: Sales Order EntryBusiness Data
19910F40052RV302Return Material Authorization DefaultsTransaction Files42B: Sales Order EntryBusiness Data
20910F4006OA221Order Address InformationTransaction Files40: Inventory/OP BaseBusiness Data
21910F4006ZOY211Batch Order Receiver - Order Address InformationBatch Input Files42B: Sales Order EntryBusiness Data
22910F40070PF172Preference Master FileMaster Files42: Sales ManagementBusiness Data
23910F40071CU132Customer Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
24910F40072GI132Item Preference GroupsSecondary Master Files42: Sales ManagementBusiness Data
25910F40073HY332Preference Hierarchy FileSecondary Master Files42: Sales ManagementBusiness Data
26910F4009CP501Distribution/Manufacturing ConstantsConstants Files41: Inventory ManagementBusiness Data
27910F40095DL81Default Locations/PrintersConstants Files41: Inventory ManagementBusiness Data
28910F40096DQ31Default Print QueuesConstants Files41: Inventory ManagementBusiness Data
29910F4009T1CT101Distribution/Manufacturing Constant Tag TableConstants Files41: Inventory Management
30910F4011ZSZ2511Batch Receiver File - Order DetailsBatch Input Files42B: Sales Order EntryBusiness Data
31910F4011Z60DC111Batch Receiver File - Order Details CommissionsFiles42B: Sales Order Entry
32910F4011ZTXZT201Recurring Order Detail Tax TableBatch Input Files42B: Sales Order EntryBusiness Data
33910F4012ZSP381Batch Receiver File - Destination QuantityBatch Input Files42B: Sales Order EntryBusiness Data
34910F4012ZWSP431WF - Destination QuantityRegular Work Files42B: Sales Order EntryBusiness Data
35910F4013SX101Order Processing Cross Reference FileExtra Features Files40: Inventory/OP BaseBusiness Data
36910F4013ZKS211Kit Components Batch FileBatch Input Files42B: Sales Order EntryBusiness Data
37910F4015OT172Order TemplatesTransaction Files40: Inventory/OP BaseBusiness Data
38910F4016TU113Print MessagesExtra Features Files41: Inventory ManagementBusiness Data
39910F4017TV101Print Message Report DefaultsExtra Features Files41: Inventory ManagementBusiness Data
40910F40203FS151Order Activity RulesConstants Files40: Inventory/OP BaseBusiness Data
41910F40205LF381Line Type Control Constants FileConstants Files40: Inventory/OP BaseBusiness Data
42910F40241CD21UNSPSC Commodity CodeFiles43B: Voucher Match and Landed Cost
43910F40241DCA91UNSPSC Code Alternate DescriptionFiles43B: Voucher Match and Landed Cost
44910F40243CR42Commodity RelationshipFiles43B: Voucher Match and Landed Cost
45910F40300RPM312Preference Resolution History - MasterExtra Features Files42: Sales ManagementBusiness Data
46910F40301PT261Preference Profile - Payment TermsExtra Features Files42B: Sales Order Entry
47910F40301RPT262Preference Resolution Ledger - Payment TermsExtra Features Files42B: Sales Order EntryBusiness Data
48910F40302PU261Preference Profile - Unit of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
49910F40302RPU242Preference Resolution Ledger - Pricing Unit Of MeasureExtra Features Files42B: Sales Order EntryBusiness Data
50910F40303RV261Preference Profile - Revenue Cost CenterExtra Features Files42B: Sales Order EntryBusiness Data
51910F40303RRV242Preference Resolution Ledger - Revenue Business UnitExtra Features Files42B: Sales Order EntryBusiness Data
52910F40304PE241Preference Profile - End UseExtra Features Files42B: Sales Order EntryBusiness Data
53910F40304RPE252Preference Resolution Ledger - End UseExtra Features Files42B: Sales Order EntryBusiness Data
54910F40305RM301Preference Profile - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
55910F40305RRM262Preference Resolution Ledger - Print MessagesExtra Features Files42: Sales ManagementBusiness Data
56910F40306SR311Preference Profile - Inventory SourcingExtra Features Files42: Sales ManagementBusiness Data
57910F40307LA291Preference Profile - Product AllocationsExtra Features Files42B: Sales Order EntryBusiness Data
58910F40308GS271Preference Profile - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
59910F40308RGS282Preference Resolution Ledger - Grade and PotencyExtra Features Files42B: Sales Order EntryBusiness Data
60910F40309DY291Preference Profile - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
61910F40309RDY302Preference Resolution Ledger - Delivery DateExtra Features Files42B: Sales Order EntryBusiness Data
62910F40310LB231Preference Profile - Line of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
63910F40310RLB242Preference Resolution Ledger - Line Of BusinessExtra Features Files42B: Sales Order EntryBusiness Data
64910F40311P1231Preference Profile - Price Code 1Extra Features Files42B: Sales Order EntryBusiness Data
65910F40311RP1242Preference Resolution Ledger - User Defined Price Code #1Extra Features Files42B: Sales Order EntryBusiness Data
66910F40312P2231Preference Profile - Price Code 2Extra Features Files42B: Sales Order EntryBusiness Data
67910F40312RP2242Preference Resolution Ledger - User Defined Price Code #2Extra Features Files42B: Sales Order EntryBusiness Data
68910F40313P3231Preference Profile - Price Code 3Extra Features Files42B: Sales Order EntryBusiness Data
69910F40313RP3242Preference Resolution Ledger - User Defined Price Code #3Extra Features Files42B: Sales Order EntryBusiness Data
70910F40314PJ241Preference Profile - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
71910F40314RPJ262Preference Resolution Ledger - Price Adjustment ScheduleExtra Features Files42B: Sales Order EntryBusiness Data
72910F40315PI241Preference Profile - Invoice CyclingExtra Features Files42: Sales ManagementBusiness Data
73910F40315RPI262Preference Resolution Ledger - Invoice CycleExtra Features Files42: Sales ManagementBusiness Data
74910F40316OP261Preference Profile - Order PreparationExtra Features Files42B: Sales Order EntryBusiness Data
75910F40316ROP272Preference Resolution Ledger - Order Preparation DaysExtra Features Files42B: Sales Order EntryBusiness Data
76910F40318RQC712Preference Resolution Ledger - Quality ManagementExtra Features Files37: Quality ManagementBusiness Data
77910F40320LP412Preference Profile - Multi Shipping/Receiving LocationsExtra Features Files46: Warehouse ManagementBusiness Data
78910F40320RLP423Preference Resolution Ledger - Multi ShiP/Rec LocationsExtra Features Files46: Warehouse ManagementBusiness Data
79910F40329DD281Preference Profile - Document DistributionExtra Features Files49: Transportation ManagementBusiness Data
80910F40330DG311Preference Profile - Document SetExtra Features Files49: Transportation ManagementBusiness Data
81910F40331OE251Preference Profile - Options and EquipmentExtra Features Files49: Transportation ManagementBusiness Data
82910F40332CF321Preference Profile - Customer FreightExtra Features Files49: Transportation ManagementBusiness Data
83910F40333CA362Preference Profile - CarrierExtra Features Files49: Transportation ManagementBusiness Data
84910F40334MT321Preference Profile - Mode of TransportExtra Features Files49: Transportation ManagementBusiness Data
85910F40338PT251Preference Profile - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
86910F40338RPT272Preference Resolution Ledger - Payment Terms (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
87910F40339LA291Preference Profile - Product Allocations (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
88910F40341NS271Preference Profile - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
89910F40341RNS292Preference Resolution Ledger - Next Order StatusExtra Features Files42B: Sales Order EntryBusiness Data
90910F40344SA311Preference Profile - Sales CommissionExtra Features Files42: Sales ManagementBusiness Data
91910F40344RSA312Preference Resolution Ledger - Sales CommissionExtra Features Files42B: Sales Order EntryBusiness Data
92910F40345CR241Preference Profile - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
93910F40345RCR262Preference Resolution Ledger - Customer CurrencyExtra Features Files42B: Sales Order EntryBusiness Data
94910F40347RI261Preference Profile - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
95910F40347RRI282Preference Resolution Ledger - Pricing UOM (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
96910F40349RV261Preference Profile - Revenue Business Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
97910F40349RRV282Preference Resolution Ledger - Revenue Bus Unit (Branch)Extra Features Files42B: Sales Order EntryBusiness Data
98910F40350OQ281Preference Profiles - Conatiner Deposit/RentalExtra Features Files41: Inventory ManagementBusiness Data
99910F40500CC254Commodity Structure DefinitionsFiles40: Inventory/OP Base
100910F40510UC92UNSPSC and Commodity Structure RelationshipFiles40: Inventory/OP Base
101910F40520SC93Supplier and Commodity Structure RelationshipFiles40: Inventory/OP Base
102910F40530SX104Supplier Commodity Structure Cross ReferenceFiles40: Inventory/OP Base
103910F40540IC82Item and Commodity Structure RelationshipFiles40: Inventory/OP Base
104910F40551GL92G/L Account and Commodity Structure RelationshipFiles40: Inventory/OP Base
105910F40711PD132Preference Values DefinitionFiles45: Advanced PricingBusiness Data
106910F40721PV152Preference Values DetailFiles45: Advanced PricingBusiness Data
107910F40741PH181Preference Adjustment HistoryFiles40: Inventory/OP BaseBusiness Data
108910F4080RO448Related Order Cross Reference TableFiles31P: Engineer To Order
109910F4090MK41Distribution/Manufacturing - AAI Record TypeConstants Files40: Inventory/OP BaseBusiness Data
110910F4091KF501Category Code Key Position FileMaster Files40: Inventory/OP BaseBusiness Data
111910F4092GP131Group Code Key Definition TableMaster Files45: Advanced PricingBusiness Data
112910F4093GD131Item/Customer Group RelationshipMaster Files45: Advanced PricingBusiness Data
113910F4094KI112Item/Customer Key ID Master FileMaster Files45: Advanced PricingBusiness Data
114910F40941IK122Item Key ID Master FileFiles45: Advanced PricingBusiness Data
115910F40942CK122Customer Key ID Master FileFiles45: Advanced PricingBusiness Data
116910F40943OK102Order Group Key ID Master FileFiles45: Advanced PricingBusiness Data
117910F4095ML91Distribution/Manufacturing - AAI ValuesConstants Files40: Inventory/OP BaseBusiness Data
118910F40P01PH263Promotion Header FileFiles40: Inventory/OP BaseBusiness Data
119910F40P011PD462Promotion Deal Detail FileFiles40: Inventory/OP BaseBusiness Data
120910F40UI002UT191Supplier History Rebuild -workfileRegular Work Files43: ProcurementBusiness Data
121910F40UI00TPN291Tax Work FileRegular Work Files40: Inventory/OP BaseBusiness Data
122910F40UI17ZG221Allocation Work FileRegular Work Files42B: Sales Order EntryBusiness Data
123910F40UI74AW811Price Adjustment History Work FileRegular Work Files45: Advanced PricingBusiness Data
124910F40UI801ZB172Generic Error TableBatch Input Files40: Inventory/OP BaseBusiness Data
125910F4100LM626Location MasterMaster Files41: Inventory ManagementBusiness Data
126910F41001CI1082Inventory ConstantsConstants Files41: Inventory ManagementBusiness Data
127910F41002UM166Item Units of Measure Conversion FactorsConstants Files41: Inventory ManagementBusiness Data
128910F41003UC101Unit of Measure standard conversionConstants Files41: Inventory ManagementBusiness Data
129910F41011PK371Bulk Item MasterMaster Files41B: Bulk Stock ManagementBusiness Data
130910F41015BA122Item Duplication Work FileMaster Files41: Inventory ManagementBusiness Data
131910F41022PN241Bulk Depot/Product InformationMaster Files41B: Bulk Stock ManagementBusiness Data
132910F4104IV305Item Cross Reference FileExtra Features Files41: Inventory ManagementBusiness Data
133910F4106BP327Item Base Price FileMaster Files45: Advanced PricingBusiness Data
134910F4106NCSZ321Base Price ExtractionFiles45: Advanced PricingBusiness Data
135910F4108IO626Lot MasterSecondary Master Files41: Inventory ManagementBusiness Data
136910F41112IN492Item ASOF FileTransaction Files41: Inventory ManagementBusiness Data
137910F41500PP624Tank Master FileMaster Files41B: Bulk Stock ManagementBusiness Data
138910F41508PC247Default Tank InformationTransaction Files41B: Bulk Stock ManagementBusiness Data
139910F4170I081Lot Status Activity RulesFiles41: Inventory ManagementBusiness Data
140910F4171I1161Critical Hold ManagementFiles41: Inventory ManagementBusiness Data
141910F42008HC122Order Hold ConstantsConstants Files40: Inventory/OP BaseBusiness Data
142910F4201Z1SY1453Sales Order Header Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
143910F4207PM332Price by ItemExtra Features Files45: Advanced PricingBusiness Data
144910F4208PG92Price by CustomerExtra Features Files45: Advanced PricingBusiness Data
145910F4209HO277Held OrdersTransaction Files40: Inventory/OP BaseBusiness Data
146910F4211AUAU581Sales Order Detail Audit FileHistory Files42: Sales ManagementBusiness Data
147910F4211DTDT581Sales Order Detail Date Tracking FileHistory Files42B: Sales Order EntryBusiness Data
148910F4211Z1SZ2533Sales Order Detail Unedited Transaction FileTransaction Files42: Sales ManagementBusiness Data
149910F4215XH747Shipment HeaderTransaction Files49: Transportation ManagementBusiness Data
150910F4217XI135Shipment Reference NumbersTransaction Files49: Transportation ManagementBusiness Data
151910F4220SW336Basic Serial NumbersExtra Features Files42: Sales ManagementBusiness Data
152910F4231EF122RT Event Filter DetailsFiles42: Sales Management
153910F4314JM71Sales Order/Purchasing Text Detail LinesExtra Features Files40: Inventory/OP BaseBusiness Data
154910F43800PR271Summary Voucher MatchTransaction Files43B: Voucher Match and Landed CostBusiness Data
155910F46010IP292Item ProfileSecondary Master Files46: Warehouse ManagementBusiness Data
156910F49080IC51Invoice Cycle CalculationExtra Features Files42: Sales ManagementBusiness Data
157910F49085ID52Scheduled Invoice DateExtra Features Files42: Sales ManagementBusiness Data
158910F49190DS171Document Definition File (Conversion from World File)Extra Features Files49: Transportation ManagementBusiness Data
159910F49211UD1454Sales Order Detail File - Tag FileExtra Features Files42: Sales ManagementBusiness Data
160910F49211Z1S11603Sales Order Detail Tag Unedited Transaction FileExtra Features Files42: Sales ManagementBusiness Data
161910F49219UD1181Sales Order Detail - Tag History FileExtra Features Files42: Sales ManagementBusiness Data