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

86 COLUMNS | 2 INDEXES | Print definition?920 | 49 | F49631 TABLE

49: Transportation Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F49631TO862Load In-transit LedgerTransaction Files49: Transportation Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT TODOC, TODCT, TOKCO, TOJELN, TOVMCU, TOLDNM, TOTRPL, TOSHPN, TOITLT, TOVEHI, TORLNO, TOCMPN, TOVTYP, TOCNNV, TOOSEQ, TOPVEH, TOPRLO, TOLCMP, TOCARS, TOMOT, TODGL, TOICU, TODOCO, TODCTO, TOKCOO, TOLNID, TOSRCO, TOTRDJ, TORCD, TOGLRS, TOMCU, TOITM, TOLOTN, TOAN8, TOLOCN, TOLOTT, TORITM, TOKTFG, TOACLQ, TOTRUM, TOSTUM, TOBUM6, TOTEMP, TOSTPU, TODEND, TODNTP, TODETP, TODTPU, TOAMBR, TOBUM3, TOSTOK, TOBUM4, TOWGTR, TOBUM5, TOVCF, TOUNCS, TOECST, TODMCT, TODMCS, TOBALU, TOCMOO, TORDTM, TODTE, TOMETN, TOOPNR, TOPNCR, TOBFWT, TOBWTU, TOAFWT, TOAWTU, TOSVPF, TOSVPD, TOLMCU, TOLTRP, TOSHAN, TOUKID, TOURCD, TOURDT, TOURAT, TOURAB, TOURRF, TOUSER, TOPID, TOJOBN, TOUPMJ, TOTDAY FROM F49631

TOP920 | 49 | F49631 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1TODOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2TODCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
3TOKCODocument CompanyStringGeneric Edit50 Allow NULL? 
4TOJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
5TOVMCUDepot - TripStringGeneric Edit120 Allow NULL? 
6TOLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
7TOTRPLLoad Leg NumberNumericGeneric Edit30 Allow NULL? 
8TOSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
9TOITLTRecord Type - Intransit LedgerNumericUDC (49 IT)20 Allow NULL? 
10TOVEHIVehicle IDStringGeneric Edit120 Allow NULL? 
11TORLNORegistration/License NumberStringGeneric Edit130 Allow NULL? 
12TOCMPNCompartment NumberNumericGeneric Edit20 Allow NULL? 
13TOVTYPVehicle TypeStringGeneric Edit120 Allow NULL? 
14TOCNNVConnected Vehicle (Y/N)CharacterGeneric Edit10 Allow NULL? 
15TOOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
16TOPVEHPrimary Vehicle IdStringGeneric Edit120 Allow NULL? 
17TOPRLOPrimary Veh Registration/License NumberStringGeneric Edit130 Allow NULL? 
18TOLCMPLogical Compartment NumberNumericGeneric Edit50 Allow NULL? 
19TOCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
20TOMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
21TODGLDate - For G/L (and Voucher)DateGeneric Edit60
22TOICUBatch NumberNumericGeneric Edit80 Allow NULL? 
23TODOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
24TODCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
25TOKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
26TOLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
27TOSRCOSource of OrderCharacterUDC (49 BD)10 Allow NULL? 
28TOTRDJDate - Order/TransactionDateGeneric Edit60
29TORCDReason CodeStringUDC (42 RC)30 Allow NULL? 
30TOGLRSGain/Loss ReasonStringUDC (41B RS)20 Allow NULL? 
31TOMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
32TOITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
33TOLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
34TOAN8Address NumberNumericGeneric Edit80 Allow NULL? 
35TOLOCNLocationStringGeneric Edit200 Allow NULL? 
36TOLOTTLotStringGeneric Edit300 Allow NULL? 
37TORITMItem Number - RelatedNumericGeneric Edit80 Allow NULL? 
38TOKTFGKit FlagCharacterGeneric Edit10 Allow NULL? 
39TOACLQQuantity - Actual LoadNumericGeneric Edit150 Allow NULL? 
40TOTRUMUnit of Measure - TransactionStringUDC (00 UM)20 Allow NULL? 
41TOSTUMQuantity - Primary Stock Accounting UnitNumericGeneric Edit150 Allow NULL? 
42TOBUM6Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
43TOTEMPTemperatureNumericGeneric Edit72 Allow NULL? 
44TOSTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
45TODENDDisplay DensityNumericGeneric Edit104 Allow NULL? 
46TODNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
47TODETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
48TODTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
49TOAMBRVolume - AmbientNumericGeneric Edit150 Allow NULL? 
50TOBUM3Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
51TOSTOKVolume - StandardNumericGeneric Edit150 Allow NULL? 
52TOBUM4Unit of Measure 4StringUDC (00 UM)20 Allow NULL? 
53TOWGTRWeight ResultNumericGeneric Edit150 Allow NULL? 
54TOBUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
55TOVCFVolume Correction FactorNumericGeneric Edit75 Allow NULL? 
56TOUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
57TOECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
58TODMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
59TODMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
60TOBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
61TOCMOOCommingled Other OwnerCharacterGeneric Edit10 Allow NULL? 
62TORDTMTime - ReadingNumericGeneric Edit60 Allow NULL? 
63TODTEDateDateGeneric Edit60
64TOMETNMeter NumberStringGeneric Edit100 Allow NULL? 
65TOOPNRUnits - Beginning Throughput Qty.NumericGeneric Edit150 Allow NULL? 
66TOPNCRClosing ReadingNumericGeneric Edit150 Allow NULL? 
67TOBFWTWeight - Before LoadingNumericGeneric Edit150 Allow NULL? 
68TOBWTUUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
69TOAFWTWeight - After LoadingNumericGeneric Edit150 Allow NULL? 
70TOAWTUUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
71TOSVPFStock Valuation PostedCharacterGeneric Edit10 Allow NULL? 
72TOSVPDDate - Stock Valuation PostedDateGeneric Edit60
73TOLMCUDepot - Prior TripStringGeneric Edit120 Allow NULL? 
74TOLTRPPrior Trip NumberNumericGeneric Edit80 Allow NULL? 
75TOSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
76TOUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
77TOURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
78TOURDTUser Reserved DateDateGeneric Edit60
79TOURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
80TOURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
81TOURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
82TOUSERUser IDStringGeneric Edit100 Allow NULL? 
83TOPIDProgram IDStringGeneric Edit100 Allow NULL? 
84TOJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
85TOUPMJDate - UpdatedDateGeneric Edit60
86TOTDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 49 | F49631 INDEXES

NumberDescription
1UniqueKeyID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2Co Date Stock Val Flags
ElementAliasDescriptionSequence
1KCODocument CompanyAscending
2DGLDate - For G/L (and Voucher)Ascending
3SVPFStock Valuation PostedAscending
4SVPDDate - Stock Valuation PostedAscending