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

116 COLUMNS | 5 INDEXES | Print definition?812 | 31B | F31B03 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F31B03BM1165Barrel Master TableFiles31B: 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 BMBATP, BMBATV, BMBPCO, BMMCU, BMBARID, BMBARCN, BMVBID, BMIDNOFR, BMRKNUM, BMIDMTHD, BMLOCN, BMWODOC, BMCTRO, BMOLOC, BMBCST, BMRECY, BMOYRC, BMBARCO, BMPOWN, BMSUPL, BMCPNUM, BMFORES, BMTLEV, BMTSTH, BMTOCAP, BMBCUOM, BMFCAP, BMNUMHP, BMSCTM, BMSTAVT, BMSDRM, BMSBDM, BMSDRL, BMSDDR, BMBSMK, BMGRAIN, BMBNMS, BMBAVC, BMAJRS, BMDAOS, BMBVST, BMSHAV, BMSHAVD, BMSHAVB, BMTSTR, BMDAFU, BMCUSE, BMNXUSE, BMNUMFL, BMMTDLT, BMDALT, BMDALS, BMBOWN, BMLEAS, BMLESTM, BMLESDT, BMLESDN, BMLESCO, BMLESCN, BMANUMW, BMWBPO, BMBRLC, BMIUOM, BMINUM, BMINSU, BMINLG, BMINWD, BMINHG, BMINGR, BMINQT, BMINTS, BMINFO, BMINMS, BMINUS, BMSYAR, BMINOO, BMISAR, BMIUMSA, BMISVR, BMDAFC, BMINSF, BMQTOR, BMQTRC, BMQTCU, BMURAT, BMURCD, BMURDT, BMURAB, BMURRF, BMUSER, BMDTE, BMTDAY, BMUPMJ, BMUPMT, BMJOBN, BMMKEY, BMPID, BMGECM, BMLDREF, BMBRLNUM, BMBPDESC, BMBRLCLA, BMRKNMR, BMSHAVEBY, BMWOTC, BMWRF, BMWCD, BMWAB, BMWNUM, BMWMDT, BMNXTUSEID, BMCURUSEID, BMWCG, BMCOOP, BMWCTRO, BMWVID FROM F31B03

TOP812 | 31B | F31B03 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1BMBATPBarrel TypeStringUDC (31B BT)40 Allow NULL? 
2BMBATVBarrel Type VariationStringUDC (31B BV)20 Allow NULL? 
3BMBPCOBarrel Profile CodeStringGeneric Edit120 Allow NULL? 
4BMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5BMBARIDBarrel IDStringGeneric Edit300 Allow NULL? 
6BMBARCNBarrel Collection NumberNumericGeneric Edit60 Allow NULL? 
7BMVBIDVirtual Barrel IDNumericGeneric Edit100 Allow NULL? 
8BMIDNOFRID Number FromNumericGeneric Edit60 Allow NULL? 
9BMRKNUMBarrel AgeNumericGeneric Edit80 Allow NULL? 
10BMIDMTHDID MethodStringGeneric Edit60 Allow NULL? 
11BMLOCNLocationStringGeneric Edit200 Allow NULL? 
12BMWODOCOriginal Document WineNumericGeneric Edit80 Allow NULL? 
13BMCTROOriginCountryStringUDC (00 CN)30 Allow NULL? 
14BMOLOCOrigin LocalityStringUDC (31B OL)60 Allow NULL? 
15BMBCSTBarrel Color StatusStringUDC (31B CB)100 Allow NULL? 
16BMRECYYear ReceivedNumericGeneric Edit40 Allow NULL? 
17BMOYRCOther Year CodeNumericGeneric Edit40 Allow NULL? 
18BMBARCOBarrel ConditionCharacterUDC (31B BC)10 Allow NULL? 
19BMPOWNPrevious OwnerNumericGeneric Edit80 Allow NULL? 
20BMSUPLBlend SupplierNumericGeneric Edit80 Allow NULL? 
21BMCPNUMCooper NumberNumericGeneric Edit80 Allow NULL? 
22BMFORESForestStringUDC (31B FO)80 Allow NULL? 
23BMTLEVToast LevelStringUDC (31B TL)30 Allow NULL? 
24BMTSTHBarrel Head ToastCharacterUDC (31B HT)10 Allow NULL? 
25BMTOCAPBarrel Total CapacityNumericGeneric Edit154 Allow NULL? 
26BMBCUOMBarrel Capacity UOMStringUDC (31B UM)20 Allow NULL? 
27BMFCAPFermentation CapacityNumericGeneric Edit154 Allow NULL? 
28BMNUMHPNumber of HoopsNumericGeneric Edit20 Allow NULL? 
29BMSCTMBarrel Category Code 1StringUDC (31B R1)100 Allow NULL? 
30BMSTAVTStave ThicknessNumericGeneric Edit31 Allow NULL? 
31BMSDRMBarrel Category Code 2StringUDC (31B R2)100 Allow NULL? 
32BMSBDMBarrel Category Code 3StringUDC (31B R3)100 Allow NULL? 
33BMSDRLBarrel Category Code 4StringUDC (31B R4)200 Allow NULL? 
34BMSDDRStave Dry DateDateGeneric Edit60
35BMBSMKBarrel SmokeStringGeneric Edit80 Allow NULL? 
36BMGRAINStave - GrainStringGeneric Edit30 Allow NULL? 
37BMBNMSBarrel Number Months SeasonedNumericGeneric Edit20 Allow NULL? 
38BMBAVCBarrel Availability CodeStringUDC (31B AC)40 Allow NULL? 
39BMAJRSAdjustment Reason CodeStringUDC (31B RC)200 Allow NULL? 
40BMDAOSDate Out of ServiceDateGeneric Edit60
41BMBVSTBarrel Volume StatusStringUDC (31B VS)30 Allow NULL? 
42BMSHAVBarrel ShavedCharacterUDC (31B SH)10 Allow NULL? 
43BMSHAVDShave DateDateGeneric Edit80
44BMSHAVBShaved ByStringGeneric Edit80 Allow NULL? 
45BMTSTRToast ReworkCharacterGeneric Edit10 Allow NULL? 
46BMDAFUDate First UseDateGeneric Edit80
47BMCUSECurrent UseStringUDC (31B CU)40 Allow NULL? 
48BMNXUSENext UseStringUDC (31B NU)40 Allow NULL? 
49BMNUMFLNumber of FillsNumericGeneric Edit40 Allow NULL? 
50BMMTDLTMethod Last TreatmentStringUDC (31B LT)80 Allow NULL? 
51BMDALTDate Last TreatmentDateGeneric Edit80
52BMDALSDate Last SulfurDateGeneric Edit80
53BMBOWNBarrel OwnerNumericGeneric Edit80 Allow NULL? 
54BMLEASLeased YNCharacterUDC (31B LS)10 Allow NULL? 
55BMLESTMLease TermNumericGeneric Edit30 Allow NULL? 
56BMLESDTLease DateDateGeneric Edit80
57BMLESDNLease Document NumberNumericGeneric Edit80 Allow NULL? 
58BMLESCOLeasing CompanyNumericGeneric Edit80 Allow NULL? 
59BMLESCNLeasing Company NameStringGeneric Edit300 Allow NULL? 
60BMANUMWAsset Number WineNumericGeneric Edit80 Allow NULL? 
61BMWBPOBarrel Purchase OrderNumericGeneric Edit80 Allow NULL? 
62BMBRLCBarrel Receiving LocationStringGeneric Edit200 Allow NULL? 
63BMIUOMInsert Unit of MeasureStringUDC (31B UM)20 Allow NULL? 
64BMINUMInsert NumberNumericGeneric Edit100 Allow NULL? 
65BMINSUInsert SupplierNumericGeneric Edit80 Allow NULL? 
66BMINLGInsertLengthNumericGeneric Edit101 Allow NULL? 
67BMINWDInsertWidthNumericGeneric Edit101 Allow NULL? 
68BMINHGInsertHeightNumericGeneric Edit101 Allow NULL? 
69BMINGRInsert GrainStringGeneric Edit30 Allow NULL? 
70BMINQTInsert QuantityNumericGeneric Edit40 Allow NULL? 
71BMINTSInsert ToastStringGeneric Edit20 Allow NULL? 
72BMINFOBarrel Category Code 5StringUDC (31B R5)100 Allow NULL? 
73BMINMSInsert Number Months SeasonedNumericGeneric Edit20 Allow NULL? 
74BMINUSInsert Number UsesNumericGeneric Edit40 Allow NULL? 
75BMSYARSystem ArrangementStringGeneric Edit30 Allow NULL? 
76BMINOOInsert Oak OriginStringGeneric Edit200 Allow NULL? 
77BMISARInsert Surface AreaNumericGeneric Edit81 Allow NULL? 
78BMIUMSAUnit of Measure - Insert Surface AreaStringUDC (31B UM)20 Allow NULL? 
79BMISVRInsert Surface Area to Volume RatioNumericGeneric Edit43 Allow NULL? 
80BMDAFCDate First CommissionedDateGeneric Edit80
81BMINSFInsert FlagCharacterGeneric Edit10 Allow NULL? 
82BMQTORQuantity - OriginalNumericGeneric Edit154 Allow NULL? 
83BMQTRCQuantity - ReceivedNumericGeneric Edit154 Allow NULL? 
84BMQTCUQuantity - CurrentNumericGeneric Edit154 Allow NULL? 
85BMURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
86BMURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
87BMURDTUser Reserved DateDateGeneric Edit60
88BMURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
89BMURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
90BMUSERUser IDStringGeneric Edit100 Allow NULL? 
91BMDTEDateDateGeneric Edit60
92BMTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
93BMUPMJDate - UpdatedDateGeneric Edit60
94BMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
95BMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
96BMMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
97BMPIDProgram IDStringGeneric Edit100 Allow NULL? 
98BMGECMGeneral CommentsStringGeneric Edit400 Allow NULL? 
99BMLDREFLease Document ReferenceStringGeneric Edit400 Allow NULL? 
100BMBRLNUMBarrel NumberNumericGeneric Edit80 Allow NULL? 
101BMBPDESCBarrel Profile DescriptionStringGeneric Edit400 Allow NULL? 
102BMBRLCLABarrel ClassificationStringUDC (31B CL)20 Allow NULL? 
103BMRKNMRRack NumberStringGeneric Edit200 Allow NULL? 
104BMSHAVEBYShave ByNumericGeneric Edit80 Allow NULL? 
105BMWOTCOne-Time CostCharacterGeneric Edit10 Allow NULL? 
106BMWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
107BMWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
108BMWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
109BMWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
110BMWMDTBlend Mgmt DateDateGeneric Edit60
111BMNXTUSEIDNext Use EUR IDNumericGeneric Edit100 Allow NULL? 
112BMCURUSEIDCurrent Use EUR IDNumericGeneric Edit100 Allow NULL? 
113BMWCGCost GroupStringGeneric Edit120 Allow NULL? 
114BMCOOPCooperStringUDC (31B CP)30 Allow NULL? 
115BMWCTROCountryStringUDC (31B CN)30 Allow NULL? 
116BMWVIDVessel IDNumericGeneric Edit80 Allow NULL? 

TOP812 | 31B | F31B03 INDEXES

NumberDescription
1BarrelProfile MCU
ElementAliasDescriptionSequence
1BPCOBarrel Profile CodeAscending
2MCUBusiness UnitAscending
2BranchPlant
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
3BarrelID (Unique)
ElementAliasDescriptionSequence
1BARIDBarrel IDAscending
5BarrelType MCU
ElementAliasDescriptionSequence
1BATPBarrel TypeAscending
2MCUBusiness UnitAscending
3BAVCBarrel Availability CodeAscending
6BarrelNum (Primary/Unique)
ElementAliasDescriptionSequence
1BRLNUMBarrel NumberAscending