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

103 tables812 | 49

49: Transportation Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4215TXT182Shipment Header Tag FileTransaction Files49: Transportation ManagementNo
2812F47500WFSZ91Inbound Transaction Processor WorkfileFiles49: Transportation Management
3812F49002TX351Transportation ConstantsConstants Files49: Transportation ManagementNo
4812F49003LT281Load Type ConstantsConstants Files49: Transportation ManagementNo
5812F49004CT231Mode of Transport ConstantsConstants Files49: Transportation ManagementNo
6812F49005TG151Generate Tracking NumberConstants Files49: Transportation ManagementNo
7812F490051XG231Generate Tracking Number SegmentConstants Files49: Transportation ManagementNo
8812F490052YG181Generate Tracking Segment Next NumberConstants Files49: Transportation ManagementNo
9812F490053ZG164Generate Tracking Number SeparatorConstants Files49: Transportation ManagementNo
10812F49010VM451Vehicle Master (Conversion from World File)Master Files49: Transportation ManagementAS400 Coexistence Tables
11812F49012VO131Vehicle Compartments (Conversion from World File)Secondary Master Files49: Transportation ManagementAS400 Coexistence Tables
12812F49015ST92Vehicle StatusSecondary Master Files49: Transportation ManagementAS400 Coexistence Tables
13812F4902TV171Vehicle Current LoadBalance Files49: Transportation ManagementAS400 Coexistence Tables
14812F49020VL212Vehicle/Staff License InformationSecondary Master Files49: Transportation ManagementNo
15812F49025CV181Connected Vehicles (Conversion from World File)Secondary Master Files49: Transportation ManagementAS400 Coexistence Tables
16812F49030VE101Vehicle Equipment (Conversion from World File)Secondary Master Files49: Transportation ManagementAS400 Coexistence Tables
17812F49040VS121Vehicle Staff (Conversion from World File)Secondary Master Files49: Transportation ManagementAS400 Coexistence Tables
18812F49041VS121Depot/Vehicle StaffMaster Files49: Transportation ManagementNo
19812F4906CM171Carrier MasterMaster Files49: Transportation ManagementNo
20812F49075PM83Product MixExtra Features Files49: Transportation ManagementNo
21812F4908II241Item Shipping InformationSecondary Master Files49: Transportation ManagementNo
22812F49110BW834Transportation Bill of Lading WorkfileWork Files49: Transportation ManagementNo
23812F49111CD171Carton Detail Shipment WorkfileFiles49: Transportation ManagementBusiness Data
24812F49130BW441Shipment Document WorkfileWork Files49: Transportation ManagementNo
25812F49140BW491SSCC Print Label WorkfileWork Files49: Transportation ManagementNo
26812F49141PW391Packing List WorkfileWork Files49: Transportation ManagementNo
27812F49160NN161Document Next NumberExtra Features Files49: Transportation ManagementAS400 Coexistence Tables
28812F49170NN31Load Next NumbersConstants Files49: Transportation ManagementAS400 Coexistence Tables
29812F4918LT182Load Tender HistoryTransaction Files49: Transportation ManagementNo
30812F49191DS241Document DefinitionMaster Files49: Transportation ManagementNo
31812F49195DU71Document Set - Keys Doc Code - Doc Set (Conversion from World)Extra Features Files49: Transportation ManagementAS400 Coexistence Tables
32812F49196DU72Document SetSecondary Master Files49: Transportation ManagementNo
33812F49197OQ181Depot Document Print Set Up (Conversion from World File)Secondary Master Files49: Transportation ManagementAS400 Coexistence Tables
34812F49198OQ251Depot Document Print SetupSecondary Master Files49: Transportation ManagementNo
35812F4930VM332Vehicle MasterMaster Files49: Transportation ManagementNo
36812F49301VO171Vehicle CompartmentsMaster Files49: Transportation ManagementNo
37812F49302VE162Vehicle EquipmentMaster Files49: Transportation ManagementNo
38812F4931VG451Vehicle TypeMaster Files49: Transportation ManagementNo
39812F4935VH221Connected Vehicle HeaderMaster Files49: Transportation ManagementNo
40812F4936CW172Connected Vehicle DetailMaster Files49: Transportation ManagementNo
41812F49380SU184Seal NumbersTransaction Files49: Transportation ManagementNo
42812F4941RS916Shipment Routing StepsTransaction Files49: Transportation ManagementNo
43812F4942IS344Shipment DetailTransaction Files49: Transportation ManagementNo
44812F4943SP286Shipment PiecesTransaction Files49: Transportation ManagementNo
45812F4944OE211Shipment/Load Options and EquipmentTransaction Files49: Transportation ManagementNo
46812F4945SC458Shipment ChargesTransaction Files49: Transportation ManagementNo
47812F4947ST202Shipment Status CodesTransaction Files49: Transportation ManagementNo
48812F49490TQ275Document SelectionBatch Input Files49: Transportation ManagementNo
49812F4950RT5311Routing EntriesMaster Files49: Transportation ManagementNo
50812F49501RD351Intermodal Detail Routing EntriesMaster Files49: Transportation ManagementNo
51812F4951ZN181Carrier Zone DefinitionsMaster Files49: Transportation ManagementNo
52812F4952RE291Routing RestrictionsMaster Files49: Transportation ManagementNo
53812F4953RG71Routing HierarchyConstants Files49: Transportation ManagementNo
54812F4956IX181Option and Equipment Inclusions/ExclusionsMaster Files49: Transportation ManagementNo
55812F4957BC252Transportation Confirmed Batch ShipmentConstants Files49: Transportation ManagementNo
56812F49590DB151Document Print Batch HeaderBatch Input Files49: Transportation ManagementNo
57812F49591DB253Document Print - Batch SelectionWork Files49: Transportation ManagementNo
58812F49592DH372Document Print Batch Document HeaderWork Files49: Transportation ManagementNo
59812F49594DI402Document Print - Document DetailWork Files49: Transportation ManagementNo
60812F49595DK353Document Print - Document SummaryTransaction Files49: Transportation ManagementNo
61812F4960TM794Load HeaderTransaction Files49: Transportation ManagementNo
62812F4961LL331Load LegsTransaction Files49: Transportation ManagementNo
63812F49611LD221Load Stop SequenceTransaction Files49: Transportation ManagementNo
64812F49612TD182Load VehiclesTransaction Files49: Transportation ManagementNo
65812F49614TS141Load StaffTransaction Files49: Transportation ManagementNo
66812F4962TE312Load CompartmentsTransaction Files49: Transportation ManagementNo
67812F49621TD462Load Compartment DetailTransaction Files49: Transportation ManagementNo
68812F4963TI361Load In-transitTransaction Files49: Transportation ManagementNo
69812F49631TO862Load In-transit LedgerTransaction Files49: Transportation ManagementNo
70812F49632LB403Load In-transit Left on BoardTransaction Files49: Transportation ManagementNo
71812F49633IQ381Load In-Transit Confirmed QuantitiesFiles49: Transportation Management
72812F49634QD291Load In-Transit Confirmed Quantities DetailFiles49: Transportation Management
73812F49695DR351Document RegisterWork Files49: Transportation ManagementNo
74812F49696DJ272Document Register DetailWork Files49: Transportation ManagementNo
75812F49697DN243Document Register SummaryExtra Features Files49: Transportation ManagementNo
76812F4970FT101Freight Rate ScheduleMaster Files49: Transportation ManagementNo
77812F4971RD491Freight Rate DefinitionMaster Files49: Transportation ManagementNo
78812F49711RV201Freight Rate Definition - Tag FileMaster Files49: Transportation ManagementNo
79812F4972RX2910Rate DetailMaster Files49: Transportation ManagementNo
80812F49721QS181Spot Quote DetailMaster Files49: Transportation ManagementNo
81812F4973TL144Rate Structure DefinitionMaster Files49: Transportation ManagementNo
82812F4977MR302Rate ParametersMaster Files49: Transportation ManagementNo
83812F4978CG161Charge Code DefinitionsMaster Files49: Transportation ManagementNo
84812F4981FH9411Freight Audit HistoryHistory Files49: Transportation ManagementBusiness Data
85812F49T00ICIntegration ConstantsFiles49: Transportation Management
86812F49T01CRCross ReferenceFiles49: Transportation Management
87812F49T05OROTM Record ReservationFiles49: Transportation Management
88812F49T10ORSales Order Release Staging TableFiles49: Transportation Management
89812F49T100OBProcurement Freight Request staging tableFiles49: Transportation Management
90812F49T11ITItem Staging TableFiles49: Transportation Management
91812F49T20SSShipment Staging TableFiles49: Transportation Management
92812F49T211TPSales Order Detail File - Secondary Tag TableFiles49: Transportation Management
93812F49T30SOSales Confirm Staging TableFiles49: Transportation Management
94812F49T311TPPurchase Order Detail - OTMFiles49: Transportation Management
95812F49T380SOSeal NumbersFiles49: Transportation Management
96812F49T40TCShipment Freight Cost Staging TableFiles49: Transportation Management
97812F49T50LOOrder Release Location StagingFiles49: Transportation Management
98812F49T60IVVoucher Cross ReferenceFiles49: Transportation Management
99812F49T70CSCorporations Staging TableFiles49: Transportation Management
100812F49T70WCWCorporations Staging Work TableFiles49: Transportation Management
101812F49T80LCLocations Staging TableFiles49: Transportation Management
102812F49T80WLWLocations Staging Work TableFiles49: Transportation Management
103812F49T90ITInbound TransmissionsFiles49: Transportation Management