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

91 COLUMNS | 5 INDEXES | Print definition?920 | 31B | F31B31 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B31WL915Blend Lot 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 WLMCU, WLWLOTN, WLWBID, WLWBIDAPP, WLAWBID, WLLTQNTY, WLLTUOM, WLLTSTAT, WLMATYP, WLWISSC, WLSRVGAV, WLSRVGAP, WLOPRGAV, WLOPRGAP, WLLOTYLD, WLCUMYLD, WLSATTN1, WLSATTN2, WLSATTN3, WLSATTN4, WLSATTN5, WLSATTN6, WLSATTN7, WLSATTN8, WLSATTN9, WLSATTN10, WLSATTN11, WLSATTN12, WLSATTN13, WLSATTN14, WLSATTN15, WLSATTS16, WLSATTS17, WLSATTS18, WLSATTS19, WLSATTS20, WLSATTS21, WLSATTS22, WLSATTS23, WLSATTS24, WLSATTS25, WLINATTN1, WLINATTN2, WLINATTN3, WLINATTN4, WLINATTS5, WLINATTS6, WLINATTS7, WLINATTS8, WLINATTD9, WLINATTD10, WLINATTD11, WLINATTD12, WLDECLOV, WLSAMLOV, WLMATOVR, WLWSOVR, WLINATOVR1, WLINATOVR2, WLINATOVR3, WLINATOVR4, WLINATOVR5, WLINATOVR6, WLINATOVR7, WLINATOVR8, WLINATOVR9, WLINAOVR10, WLINAOVR11, WLINAOVR12, WLEUROVR, WLOWNOVR, WLLTCMTOVR, WLVLI, WLWRF, WLWCD, WLWAB, WLWNUM, WLWMDT, WLURCD, WLURDT, WLURAT, WLURRF, WLURAB, WLUSER, WLPID, WLJOBN, WLUPMJ, WLUPMT, WLBIDOVR, WLWERCS, WLWOVC FROM F31B31

TOP920 | 31B | F31B31 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
2WLWLOTNBlend Lot NumberStringGeneric Edit300 Allow NULL? 
3WLWBIDBlend IDStringGeneric Edit300 Allow NULL? 
4WLWBIDAPPBlend ID ApprovedCharacterGeneric Edit10 Allow NULL? 
5WLAWBIDAlternate Blend IDStringGeneric Edit300 Allow NULL? 
6WLLTQNTYBlend Lot QuantityNumericGeneric Edit154 Allow NULL? 
7WLLTUOMBlend Lot Unit of MeasureStringGeneric Edit30 Allow NULL? 
8WLLTSTATBlend Lot StatusStringUDC (31B WF)100 Allow NULL? 
9WLMATYPMaterial Type CodeStringGeneric Edit40 Allow NULL? 
10WLWISSCWine StatusStringGeneric Edit60 Allow NULL? 
11WLSRVGAVSurvey Gain VolumeNumericGeneric Edit154 Allow NULL? 
12WLSRVGAPSurvey Gain PercentageNumericGeneric Edit154 Allow NULL? 
13WLOPRGAVOperation Gain QuantityNumericGeneric Edit154 Allow NULL? 
14WLOPRGAPOperation Gain PercentageNumericGeneric Edit154 Allow NULL? 
15WLLOTYLDLot Yield PercentageNumericGeneric Edit154 Allow NULL? 
16WLCUMYLDCumulative Lot YieldNumericGeneric Edit154 Allow NULL? 
17WLSATTN1Summary Attribute 1NumericGeneric Edit154 Allow NULL? 
18WLSATTN2Summary Attribute 2NumericGeneric Edit154 Allow NULL? 
19WLSATTN3Summary Attribute 3NumericGeneric Edit154 Allow NULL? 
20WLSATTN4Summary Attribute 4NumericGeneric Edit154 Allow NULL? 
21WLSATTN5Summary Attribute 5NumericGeneric Edit154 Allow NULL? 
22WLSATTN6Summary Attribute 6NumericGeneric Edit154 Allow NULL? 
23WLSATTN7Summary Attribute 7NumericGeneric Edit154 Allow NULL? 
24WLSATTN8Summary Attribute 8NumericGeneric Edit154 Allow NULL? 
25WLSATTN9Summary Attribute 9NumericGeneric Edit154 Allow NULL? 
26WLSATTN10Summary Attribute 10NumericGeneric Edit154 Allow NULL? 
27WLSATTN11Summary Attribute 11NumericGeneric Edit154 Allow NULL? 
28WLSATTN12Summary Attribute 12NumericGeneric Edit154 Allow NULL? 
29WLSATTN13Summary Attribute 13NumericGeneric Edit154 Allow NULL? 
30WLSATTN14Summary Attribute 14NumericGeneric Edit154 Allow NULL? 
31WLSATTN15Summary Attribute 15NumericGeneric Edit154 Allow NULL? 
32WLSATTS16Summary Attribute 16StringGeneric Edit200 Allow NULL? 
33WLSATTS17Summary Attribute 17StringGeneric Edit200 Allow NULL? 
34WLSATTS18Summary Attribute 18StringGeneric Edit200 Allow NULL? 
35WLSATTS19Summary Attribute 19StringGeneric Edit200 Allow NULL? 
36WLSATTS20Summary Attribute 20StringGeneric Edit200 Allow NULL? 
37WLSATTS21Summary Attribute 21StringGeneric Edit200 Allow NULL? 
38WLSATTS22Summary Attribute 22StringGeneric Edit200 Allow NULL? 
39WLSATTS23Summary Attribute 23StringGeneric Edit200 Allow NULL? 
40WLSATTS24Summary Attribute 24StringGeneric Edit200 Allow NULL? 
41WLSATTS25Summary Attribute 25StringGeneric Edit200 Allow NULL? 
42WLINATTN1Instructed Attribute 1NumericGeneric Edit154 Allow NULL? 
43WLINATTN2Instructed Attribute 2NumericGeneric Edit154 Allow NULL? 
44WLINATTN3Instructed Attribute 3NumericGeneric Edit154 Allow NULL? 
45WLINATTN4Instructed Attribute 4NumericGeneric Edit154 Allow NULL? 
46WLINATTS5Instructed Attribute 5StringGeneric Edit200 Allow NULL? 
47WLINATTS6Instructed Attribute 6StringGeneric Edit200 Allow NULL? 
48WLINATTS7Instructed Attribute 7StringGeneric Edit200 Allow NULL? 
49WLINATTS8Instructed Attribute 8StringGeneric Edit200 Allow NULL? 
50WLINATTD9Instructed Attribute 9DateGeneric Edit60
51WLINATTD10Instructed Attribute 10DateGeneric Edit60
52WLINATTD11Instructed Attribute 11DateGeneric Edit60
53WLINATTD12Instructed Attribute 12DateGeneric Edit60
54WLDECLOVDeclared Loss QuantityNumericGeneric Edit154 Allow NULL? 
55WLSAMLOVSample Loss VolumeNumericGeneric Edit154 Allow NULL? 
56WLMATOVRMaterial Type OverrideCharacterGeneric Edit10 Allow NULL? 
57WLWSOVRWine Status OverrideCharacterGeneric Edit10 Allow NULL? 
58WLINATOVR1Instructed Attribute Override1CharacterGeneric Edit10 Allow NULL? 
59WLINATOVR2Instructed Attribute Override2CharacterGeneric Edit10 Allow NULL? 
60WLINATOVR3Instructed Attribute Override3CharacterGeneric Edit10 Allow NULL? 
61WLINATOVR4Instructed Attribute Override4CharacterGeneric Edit10 Allow NULL? 
62WLINATOVR5Instructed Attribute Override5CharacterGeneric Edit10 Allow NULL? 
63WLINATOVR6Instructed Attribute Override6CharacterGeneric Edit10 Allow NULL? 
64WLINATOVR7Instructed Attribute Override7CharacterGeneric Edit10 Allow NULL? 
65WLINATOVR8Instructed Attribute Override8CharacterGeneric Edit10 Allow NULL? 
66WLINATOVR9Instructed Attribute Override9CharacterGeneric Edit10 Allow NULL? 
67WLINAOVR10Instructed Attribute Override10CharacterGeneric Edit10 Allow NULL? 
68WLINAOVR11Instructed Attribute Override11CharacterGeneric Edit10 Allow NULL? 
69WLINAOVR12Instructed Attribute Override12CharacterGeneric Edit10 Allow NULL? 
70WLEUROVREUR OverrideCharacterGeneric Edit10 Allow NULL? 
71WLOWNOVROwner OverrideCharacterGeneric Edit10 Allow NULL? 
72WLLTCMTOVRLot Comment OverrideCharacterGeneric Edit10 Allow NULL? 
73WLVLIVirtual Lot IndicatorCharacterUDC (31B VL)10 Allow NULL? 
74WLWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
75WLWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
76WLWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
77WLWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
78WLWMDTBlend Mgmt DateDateGeneric Edit60
79WLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
80WLURDTUser Reserved DateDateGeneric Edit60
81WLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
82WLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
83WLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
84WLUSERUser IDStringGeneric Edit100 Allow NULL? 
85WLPIDProgram IDStringGeneric Edit100 Allow NULL? 
86WLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
87WLUPMJDate - UpdatedDateGeneric Edit60
88WLUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
89WLBIDOVRBlend ID OverrideCharacterGeneric Edit10 Allow NULL? 
90WLWERCSRecalculation Operation Lot StatusCharacterGeneric Edit10 Allow NULL? 
91WLWOVCComposition OverrideCharacterGeneric Edit10 Allow NULL? 

TOP920 | 31B | F31B31 INDEXES

NumberDescription
1MCU LotNumber (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2WLOTNBlend Lot NumberAscending
2WineStatus
ElementAliasDescriptionSequence
1WISSCWine StatusAscending
3MatlType
ElementAliasDescriptionSequence
1MATYPMaterial Type CodeAscending
4Blend Lot Number
ElementAliasDescriptionSequence
1WLOTNBlend Lot NumberAscending
5VLI MCU
ElementAliasDescriptionSequence
1VLIVirtual Lot IndicatorAscending
2MCUBusiness UnitAscending