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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

75 COLUMNS | 4 INDEXES | Print definition?920 | 31B | F31B85 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B85WT754Weigh Tag MasterFiles31B: Blend 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 WTWVID, WTWTNUM, WTBLUID, WTMCU, WTUMWG1, WTQTRC, WTGRSWTIN, WTTRWTOUT, WTTBMETH, WTBINWGHT, WTNBIN, WTNBOUT, WTMACHHAR, WTLSTLOAD, WTINSPID, WTWGHMID, WTCARNAME, WTURAT, WTURCD, WTURDT, WTURAB, WTURRF, WTUSER, WTPID, WTMKEY, WTUPMJ, WTUPMT, WTDOCO, WTDCTO, WTKCOO, WTSFXO, WTLNID, WTNLIN, WTWTDOCNUM, WTAWTDOC, WTITM, WTMCU2, WTLOCN, WTLOTN, WTWCOST, WTCRPINSP, WTDIRH, WTCNTWGT, WTMISCWGT, WTBINWOUT, WTOWNFG, WTBLACT, WTMATYP, WTSQOR, WTUOM2, WTVARID, WTAPPID, WTGREGION, WTGDISTR, WTTLNUM, WTVLNUM, WTLOOPNUM, WTWVUM, WTGRECID, WTWOPID, WTTLNUM1, WTCMDCDE, WTDOC, WTBINTIN, WTBINTOUT, WTWLOTN, WTLOT1, WTLOT2, WTLOT3, WTRLOT, WTDRNAME, WTDLNUM, WTMIC, WTORIG, WTPRCPTF FROM F31B85

TOP920 | 31B | F31B85 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WTWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
2WTWTNUMWeigh Tag NumberStringGeneric Edit300 Allow NULL? 
3WTBLUIDBlock IdentifierNumericGeneric Edit80 Allow NULL? 
4WTMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5WTUMWG1Winery UOM Weight1StringUDC (31B UM)20 Allow NULL? 
6WTQTRCQuantity - ReceivedNumericGeneric Edit154 Allow NULL? 
7WTGRSWTINGross Weight InNumericGeneric Edit154 Allow NULL? 
8WTTRWTOUTTare Weight OutNumericGeneric Edit154 Allow NULL? 
9WTTBMETHTruck/Bin MethodCharacterUDC (31B T8)10 Allow NULL? 
10WTBINWGHTBin WeightNumericGeneric Edit154 Allow NULL? 
11WTNBINNumber Of Bins InNumericGeneric Edit150 Allow NULL? 
12WTNBOUTNumber Of Bins OutNumericGeneric Edit150 Allow NULL? 
13WTMACHHARMachine HarvestCharacterGeneric Edit10 Allow NULL? 
14WTLSTLOADLast LoadCharacterGeneric Edit10 Allow NULL? 
15WTINSPIDInspector IDNumericGeneric Edit80 Allow NULL? 
16WTWGHMIDWeighmaster IDNumericGeneric Edit80 Allow NULL? 
17WTCARNAMECarrier NameStringGeneric Edit300 Allow NULL? 
18WTURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
19WTURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
20WTURDTUser Reserved DateDateGeneric Edit60
21WTURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
22WTURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
23WTUSERUser IDStringGeneric Edit100 Allow NULL? 
24WTPIDProgram IDStringGeneric Edit100 Allow NULL? 
25WTMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
26WTUPMJDate - UpdatedDateGeneric Edit60
27WTUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
28WTDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
29WTDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
30WTKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
31WTSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
32WTLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
33WTNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
34WTWTDOCNUMWeigh Tag Document NumberNumericGeneric Edit80 Allow NULL? 
35WTAWTDOCAlternate Weigh Tag DocumentStringGeneric Edit300 Allow NULL? 
36WTITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
37WTMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
38WTLOCNLocationStringGeneric Edit200 Allow NULL? 
39WTLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
40WTWCOSTCost ComponentStringGeneric Edit120 Allow NULL? 
41WTCRPINSPCrop InspectedCharacterGeneric Edit10 Allow NULL? 
42WTDIRHDirected HarvestCharacterGeneric Edit10 Allow NULL? 
43WTCNTWGTContainer WeightNumericGeneric Edit154 Allow NULL? 
44WTMISCWGTMiscellaneous WeightNumericGeneric Edit154 Allow NULL? 
45WTBINWOUTBin Weight OutNumericGeneric Edit154 Allow NULL? 
46WTOWNFGOwnership FlagCharacterGeneric Edit10 Allow NULL? 
47WTBLACTBlend Not ActiveCharacterGeneric Edit10 Allow NULL? 
48WTMATYPMaterial Type CodeStringGeneric Edit40 Allow NULL? 
49WTSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
50WTUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
51WTVARIDVariety IDNumericGeneric Edit40 Allow NULL? 
52WTAPPIDAppellation IDNumericGeneric Edit80 Allow NULL? 
53WTGREGIONGrowing RegionStringUDC (40G GR)100 Allow NULL? 
54WTGDISTRGrowing DistrictStringUDC (40G GD)100 Allow NULL? 
55WTTLNUMTrailer Registration License NumberStringGeneric Edit120 Allow NULL? 
56WTVLNUMVehicle Registration License NumberStringGeneric Edit120 Allow NULL? 
57WTLOOPNUMLoop NumberNumericGeneric Edit80 Allow NULL? 
58WTWVUMQuantity UOMStringUDC (31B UM)30 Allow NULL? 
59WTGRECIDGrower Record IdentificationNumericGeneric Edit80 Allow NULL? 
60WTWOPIDOperation IDIntegerGeneric Edit110 Allow NULL? 
61WTTLNUM1Trailer Registration License Number 1StringGeneric Edit120 Allow NULL? 
62WTCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
63WTDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
64WTBINTINBin Type InCharacterUDC (31B BI)10 Allow NULL? 
65WTBINTOUTBin Type OutCharacterUDC (31B BI)10 Allow NULL? 
66WTWLOTNBlend Lot NumberStringGeneric Edit300 Allow NULL? 
67WTLOT1Memo Lot 1StringGeneric Edit300 Allow NULL? 
68WTLOT2Memo Lot 2StringGeneric Edit300 Allow NULL? 
69WTLOT3Memo Lot 3StringGeneric Edit300 Allow NULL? 
70WTRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
71WTDRNAMEDriver NameStringGeneric Edit400 Allow NULL? 
72WTDLNUMDriver License NumberStringGeneric Edit200 Allow NULL? 
73WTMICMatrix ControlledCharacterUDC (41 MA)10 Allow NULL? 
74WTORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
75WTPRCPTFPartial Receipts Control FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 31B | F31B85 INDEXES

NumberDescription
1VesselID (Primary/Unique)
ElementAliasDescriptionSequence
1WVIDVessel IDAscending
2TagNum
ElementAliasDescriptionSequence
1WTNUMWeigh Tag NumberAscending
3BlockID
ElementAliasDescriptionSequence
1BLUIDBlock IdentifierAscending
4Harvest
ElementAliasDescriptionSequence
1GRECIDGrower Record IdentificationAscending