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

116 COLUMNS | 8 INDEXES | Print definition?920 | 40R | F40R41 TABLE

40R: Demand Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40R41DI1168Demand HistoryFiles40R: Demand SchedulingBusiness Data
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 DIUKID, DIDEID, DICREATEDJ, DICREATETM, DIMCU, DIAN8, DISHAN, DIDVAN, DISHPN, DIADDJ, DIADTM, DIITM, DIDETYP, DIDEPER, DICRTSOSTS, DIRLSNO, DIRLSDJ, DIRLSTM, DIRQSJ, DIERQSHPDJ, DIRSHT, DIRQSHPQTY, DIUOM, DIRSDJ, DIRSDT, DIHZED, DIHZSD, DIASBLNFD, DIASBLNLOC, DIASBNO, DIDMDBTHNO, DICSGSHPNO, DIGCNT, DICUMID, DITXTREFNO, DIREQFRQ, DICSTDMDPT, DIREQTYP, DICSTORDNO, DIDKID, DIENDJOBSQ, DIPSJOBNO, DIHZCLSNO, DIJOBSQ, DIKBSNO, DIKBENO, DILABORHR, DICIRV, DIYEAR1, DIPTRLSSTS, DICSTPODJ, DICSTPOTM, DICSTPOLIN, DICSTPO, DITPUR, DIQTYBYPOS, DISOCN, DIPSIG, DIRSVLNFD, DISTSSQIND, DIEDTCTDJ, DIEDTCTTM, DIOGDMDQTY, DIEDTMSGNM, DIEDTMSGSB, DIEDTMSGTP, DITRSRTE, DITRSRTSFX, DIUCARTNO, DIVINNO, DIPENDDLT, DISDID, DINETVC, DINETVCNTF, DICRTCLID, DISOQS, DIDMD06, DIDMD07, DIDMD08, DIDMD09, DIDMD10, DIDMDREF1, DIDMDREF2, DICTLNUM, DIURCD, DIURDT, DIURAT, DIURAB, DIURRF, DIUSER, DIPID, DIJOBN, DIUPMJ, DITDAY, DICARDNO, DIDELBATCH, DICIRVQ, DIPRODTYPE, DIRTORSQ, DIRTGDAT, DIRTGTIM, DIDMDREF3, DIDMDREF4, DIDMDREF5, DIDMDREF6, DIDMDREF7, DIDMDREF8, DIDMDREF9, DIDMDREF10, DISCAC, DIATMCN, DIOFFLNDT, DIENGTAG1, DIENGTAGR1, DIENGTAG2, DIENGTAGR2 FROM F40R41

TOP920 | 40R | F40R41 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DIUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2DIDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
3DICREATEDJDate - CreateDateGeneric Edit60
4DICREATETMCreate TimeNumericGeneric Edit60 Allow NULL? 
5DIMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6DIAN8Address NumberNumericGeneric Edit80 Allow NULL? 
7DISHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
8DIDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
9DISHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
10DIADDJDate - Actual Ship DateDateGeneric Edit60
11DIADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
12DIITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
13DIDETYPDemand TypeStringUDC (40R DT)20 Allow NULL? 
14DIDEPERDemand PeriodStringUDC (40R PD)20 Allow NULL? 
15DICRTSOSTSStatus Code - Updated by Create ScheduleCharacterGeneric Edit10 Allow NULL? 
16DIRLSNORelease NumberStringGeneric Edit100 Allow NULL? 
17DIRLSDJDate - ReleaseDateGeneric Edit60
18DIRLSTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
19DIRQSJDate - Requested ShipDateGeneric Edit60
20DIERQSHPDJDate - Ending Requested ShipDateGeneric Edit60
21DIRSHTRequested Ship TimeNumericGeneric Edit60 Allow NULL? 
22DIRQSHPQTYRequested Ship QuantityNumericGeneric Edit150 Allow NULL? 
23DIUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
24DIRSDJDate - Promised DeliveryDateGeneric Edit60
25DIRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
26DIHZEDHorizon End DateDateGeneric Edit60
27DIHZSDHorizon Start DateDateGeneric Edit60
28DIASBLNFDAssembly Line FeedStringGeneric Edit100 Allow NULL? 
29DIASBLNLOCAssembly Line LocationStringGeneric Edit60 Allow NULL? 
30DIASBNOAssembly NumberStringGeneric Edit150 Allow NULL? 
31DIDMDBTHNODemand Batch NumberNumericGeneric Edit150 Allow NULL? 
32DICSGSHPNOConsignee Shipment NumberStringGeneric Edit350 Allow NULL? 
33DIGCNTContract NumberStringGeneric Edit120 Allow NULL? 
34DICUMIDCUM IDNumericGeneric Edit150 Allow NULL? 
35DITXTREFNOText Reference NumberStringGeneric Edit150 Allow NULL? 
36DIREQFRQRequirement FrequencyStringGeneric Edit30 Allow NULL? 
37DICSTDMDPTCustomer Demand PatternStringGeneric Edit30 Allow NULL? 
38DIREQTYPRequirement TypeStringGeneric Edit30 Allow NULL? 
39DICSTORDNOCustomer Order NumberStringGeneric Edit150 Allow NULL? 
40DIDKIDDock IDStringGeneric Edit200 Allow NULL? 
41DIENDJOBSQEnding Job Sequence NumberStringGeneric Edit150 Allow NULL? 
42DIPSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
43DIHZCLSNOHazardous Goods ClassificationStringGeneric Edit150 Allow NULL? 
44DIJOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
45DIKBSNOKanban Start NumberStringGeneric Edit150 Allow NULL? 
46DIKBENOKanban End NumberStringGeneric Edit150 Allow NULL? 
47DILABORHRLabor HoursNumericGeneric Edit150 Allow NULL? 
48DICIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
49DIYEAR1Model Year 1NumericGeneric Edit40 Allow NULL? 
50DIPTRLSSTSCode - Part Release StatusStringGeneric Edit20 Allow NULL? 
51DICSTPODJDate - Customer PODateGeneric Edit60
52DICSTPOTMCustomer PO TimeNumericGeneric Edit60 Allow NULL? 
53DICSTPOLINCustomer PO LineStringGeneric Edit50 Allow NULL? 
54DICSTPOCustomer POStringGeneric Edit300 Allow NULL? 
55DITPURTransaction Set PurposeStringUDC (47 PU)20 Allow NULL? 
56DIQTYBYPOSQuantity by PositionNumericGeneric Edit150 Allow NULL? 
57DISOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
58DIPSIGPull SignalStringGeneric Edit300 Allow NULL? 
59DIRSVLNFDReserve Line FeedStringGeneric Edit100 Allow NULL? 
60DISTSSQINDStatus Sequence IndicatorStringGeneric Edit30 Allow NULL? 
61DIEDTCTDJDate - EDI Transaction CreateDateGeneric Edit60
62DIEDTCTTMEDI Transaction Create TimeNumericGeneric Edit60 Allow NULL? 
63DIOGDMDQTYOriginal Demand QuantityNumericGeneric Edit150 Allow NULL? 
64DIEDTMSGNMEDI Transaction/Message NameStringGeneric Edit100 Allow NULL? 
65DIEDTMSGSBEDI Transaction/Message Name SubsetStringGeneric Edit30 Allow NULL? 
66DIEDTMSGTPEDI Transaction/Message Name TypeStringGeneric Edit30 Allow NULL? 
67DITRSRTETransportation RouteStringGeneric Edit150 Allow NULL? 
68DITRSRTSFXTransportation Route SuffixStringGeneric Edit150 Allow NULL? 
69DIUCARTNOUltimate Customer's Article NumberStringGeneric Edit150 Allow NULL? 
70DIVINNOVehicle Identification NumberStringGeneric Edit200 Allow NULL? 
71DIPENDDLTOption - Pending DeleteCharacterGeneric Edit10 Allow NULL? 
72DISDIDSupplemental Data IDNumericGeneric Edit80 Allow NULL? 
73DINETVCNet VarianceNumericGeneric Edit73 Allow NULL? 
74DINETVCNTFOption - Net Variance NotificationCharacterGeneric Edit10 Allow NULL? 
75DICRTCLIDCritical IDStringUDC (40R CI)20 Allow NULL? 
76DISOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
77DIDMD06Category Code - Demand 06StringUDC (40R 06)30 Allow NULL? 
78DIDMD07Category Code - Demand 07StringUDC (40R 07)30 Allow NULL? 
79DIDMD08Category Code - Demand 08StringUDC (40R 08)30 Allow NULL? 
80DIDMD09Category Code - Demand 09StringUDC (40R 09)30 Allow NULL? 
81DIDMD10Category Code - Demand 10StringUDC (40R 10)30 Allow NULL? 
82DIDMDREF1Demand Reference 1StringGeneric Edit350 Allow NULL? 
83DIDMDREF2Demand Reference 2StringGeneric Edit350 Allow NULL? 
84DICTLNUMControl NumberStringGeneric Edit350 Allow NULL? 
85DIURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
86DIURDTUser Reserved DateDateGeneric Edit60
87DIURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
88DIURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
89DIURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
90DIUSERUser IDStringGeneric Edit100 Allow NULL? 
91DIPIDProgram IDStringGeneric Edit100 Allow NULL? 
92DIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
93DIUPMJDate - UpdatedDateGeneric Edit60
94DITDAYTime of DayNumericGeneric Edit60 Allow NULL? 
95DICARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
96DIDELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 
97DICIRVQItem Revision Level QualifierStringUDC (40R IQ)20 Allow NULL? 
98DIPRODTYPEProduct TypeStringGeneric Edit300 Allow NULL? 
99DIRTORSQRouting Order Sequence NumberStringGeneric Edit300 Allow NULL? 
100DIRTGDATRouting DateDateGeneric Edit60
101DIRTGTIMRouting TimeNumericGeneric Edit60 Allow NULL? 
102DIDMDREF3Demand Reference 3StringGeneric Edit350 Allow NULL? 
103DIDMDREF4Demand Reference 4StringGeneric Edit350 Allow NULL? 
104DIDMDREF5Demand Reference 5StringGeneric Edit350 Allow NULL? 
105DIDMDREF6Demand Reference 6StringGeneric Edit350 Allow NULL? 
106DIDMDREF7Demand Reference 7StringGeneric Edit350 Allow NULL? 
107DIDMDREF8Demand Reference 8StringGeneric Edit350 Allow NULL? 
108DIDMDREF9Demand Reference 9StringGeneric Edit350 Allow NULL? 
109DIDMDREF10Demand Reference 10StringGeneric Edit350 Allow NULL? 
110DISCACStandard Carrier Alpha CodeStringGeneric Edit40 Allow NULL? 
111DIATMCNAuthorization To Meet Competition NumberNumericGeneric Edit60 Allow NULL? 
112DIOFFLNDTOff Line DateDateGeneric Edit60
113DIENGTAG1Engineering Tag 1StringGeneric Edit150 Allow NULL? 
114DIENGTAGR1Engineering Tag Reason Code 1StringUDC (40R EN)20 Allow NULL? 
115DIENGTAG2Engineering Tag 2StringGeneric Edit150 Allow NULL? 
116DIENGTAGR2Engineering Tag Reason Code 2StringUDC (40R EN)20 Allow NULL? 

TOP920 | 40R | F40R41 INDEXES

NumberDescription
1Demand ID Create Date + (Primary/Unique)
ElementAliasDescriptionSequence
1DEIDDemand Unique Key IDAscending
2CREATEDJDate - CreateDescending
3CREATETMCreate TimeDescending
2Business Unit Address Num A
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5RLSDJDate - ReleaseAscending
6RLSTMTime - ReleaseAscending
3Business Unit Address Num B
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5EDTCTDJDate - EDI Transaction CreateAscending
6EDTCTTMEDI Transaction Create TimeAscending
4Business Unit Address Num C
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5RSDJDate - Promised DeliveryAscending
6RSDTPromised Delivery TimeAscending
5Business Unit Address Num D
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5RQSJDate - Requested ShipAscending
6RSHTRequested Ship TimeAscending
6Business Unit Address Num E
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5CREATEDJDate - CreateAscending
6CREATETMCreate TimeAscending
7Demand ID Shipment Number
ElementAliasDescriptionSequence
1DEIDDemand Unique Key IDAscending
2SHPNShipment NumberAscending
3CREATEDJDate - CreateDescending
4CREATETMCreate TimeDescending
8Dmd UKID Create Date +
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2CREATEDJDate - CreateDescending
3CREATETMCreate TimeDescending