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

110 COLUMNS | 9 INDEXES | Print definition?812 | 40R | F40R11 TABLE

40R: Demand Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F40R11DD1109Demand DetailFiles40R: 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 DDUKID, DDDEID, DDMCU, DDAN8, DDSHAN, DDDVAN, DDITM, DDDETYP, DDDEPER, DDCRTSOSTS, DDRLSNO, DDRLSDJ, DDRLSTM, DDRQSJ, DDERQSHPDJ, DDRSHT, DDRQSHPQTY, DDUOM, DDRSDJ, DDRSDT, DDHZED, DDHZSD, DDASBLNFD, DDASBLNLOC, DDASBNO, DDDMDBTHNO, DDCSGSHPNO, DDGCNT, DDCUMID, DDTXTREFNO, DDREQFRQ, DDCSTDMDPT, DDREQTYP, DDCSTORDNO, DDDKID, DDENDJOBSQ, DDPSJOBNO, DDHZCLSNO, DDJOBSQ, DDKBSNO, DDKBENO, DDLABORHR, DDCIRV, DDYEAR1, DDPTRLSSTS, DDCSTPODJ, DDCSTPOTM, DDCSTPOLIN, DDCSTPO, DDTPUR, DDQTYBYPOS, DDSOCN, DDPSIG, DDRSVLNFD, DDSTSSQIND, DDEDTCTDJ, DDEDTCTTM, DDOGDMDQTY, DDEDTMSGNM, DDEDTMSGSB, DDEDTMSGTP, DDTRSRTE, DDTRSRTSFX, DDUCARTNO, DDVINNO, DDPENDDLT, DDSDID, DDNETVC, DDNETVCNTF, DDCRTCLID, DDDMD06, DDDMD07, DDDMD08, DDDMD09, DDDMD10, DDDMDREF1, DDDMDREF2, DDCTLNUM, DDURCD, DDURDT, DDURAT, DDURAB, DDURRF, DDUSER, DDPID, DDJOBN, DDUPMJ, DDTDAY, DDCARDNO, DDDELBATCH, DDCIRVQ, DDPRODTYPE, DDRTORSQ, DDRTGDAT, DDRTGTIM, DDDMDREF3, DDDMDREF4, DDDMDREF5, DDDMDREF6, DDDMDREF7, DDDMDREF8, DDDMDREF9, DDDMDREF10, DDSCAC, DDATMCN, DDOFFLNDT, DDENGTAG1, DDENGTAGR1, DDENGTAG2, DDENGTAGR2 FROM F40R11

TOP812 | 40R | F40R11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2DDDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
3DDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
4DDAN8Address NumberNumericUDC80 Allow NULL? 
5DDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
6DDDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
7DDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
8DDDETYPDemand TypeStringUDC (40R DT)20 Allow NULL? 
9DDDEPERDemand PeriodStringUDC (40R PD)20 Allow NULL? 
10DDCRTSOSTSStatus Code – Updated by Create ScheduleCharacterGeneric Edit10 Allow NULL? 
11DDRLSNORelease NumberStringGeneric Edit100 Allow NULL? 
12DDRLSDJDate - ReleaseDateGeneric Edit60
13DDRLSTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
14DDRQSJDate - Requested ShipDateGeneric Edit60
15DDERQSHPDJDate - Ending Requested ShipDateGeneric Edit60
16DDRSHTRequested Ship TimeNumericGeneric Edit60 Allow NULL? 
17DDRQSHPQTYRequested Ship QuantityNumericGeneric Edit150 Allow NULL? 
18DDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
19DDRSDJDate - Promised DeliveryDateGeneric Edit60
20DDRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
21DDHZEDHorizon End DateDateGeneric Edit60
22DDHZSDHorizon Start DateDateGeneric Edit60
23DDASBLNFDAssembly Line FeedStringGeneric Edit100 Allow NULL? 
24DDASBLNLOCAssembly Line LocationStringGeneric Edit60 Allow NULL? 
25DDASBNOAssembly NumberStringGeneric Edit150 Allow NULL? 
26DDDMDBTHNODemand Batch NumberNumericGeneric Edit150 Allow NULL? 
27DDCSGSHPNOConsignee Shipment NumberStringGeneric Edit350 Allow NULL? 
28DDGCNTContract NumberStringGeneric Edit120 Allow NULL? 
29DDCUMIDCUM IDNumericGeneric Edit150 Allow NULL? 
30DDTXTREFNOText Reference NumberStringGeneric Edit150 Allow NULL? 
31DDREQFRQRequirement FrequencyStringGeneric Edit30 Allow NULL? 
32DDCSTDMDPTCustomer Demand PatternStringGeneric Edit30 Allow NULL? 
33DDREQTYPRequirement TypeStringGeneric Edit30 Allow NULL? 
34DDCSTORDNOCustomer Order NumberStringGeneric Edit150 Allow NULL? 
35DDDKIDDock IDStringGeneric Edit200 Allow NULL? 
36DDENDJOBSQEnding Job Sequence NumberStringGeneric Edit150 Allow NULL? 
37DDPSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
38DDHZCLSNOHazardous Goods ClassificationStringGeneric Edit150 Allow NULL? 
39DDJOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
40DDKBSNOKanban Start NumberStringGeneric Edit150 Allow NULL? 
41DDKBENOKanban End NumberStringGeneric Edit150 Allow NULL? 
42DDLABORHRLabor HoursNumericGeneric Edit150 Allow NULL? 
43DDCIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
44DDYEAR1Model Year 1NumericGeneric Edit40 Allow NULL? 
45DDPTRLSSTSCode - Part Release StatusStringGeneric Edit20 Allow NULL? 
46DDCSTPODJDate - Customer PODateGeneric Edit60
47DDCSTPOTMCustomer PO TimeNumericGeneric Edit60 Allow NULL? 
48DDCSTPOLINCustomer PO LineStringGeneric Edit50 Allow NULL? 
49DDCSTPOCustomer POStringGeneric Edit300 Allow NULL? 
50DDTPURTransaction Set PurposeStringUDC (47 PU)20 Allow NULL? 
51DDQTYBYPOSQuantity by PositionNumericGeneric Edit150 Allow NULL? 
52DDSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
53DDPSIGPull SignalStringGeneric Edit300 Allow NULL? 
54DDRSVLNFDReserve Line FeedStringGeneric Edit100 Allow NULL? 
55DDSTSSQINDStatus Sequence IndicatorStringGeneric Edit30 Allow NULL? 
56DDEDTCTDJDate - EDI Transaction CreateDateGeneric Edit60
57DDEDTCTTMEDI Transaction Create TimeNumericGeneric Edit60 Allow NULL? 
58DDOGDMDQTYOriginal Demand QuantityNumericGeneric Edit150 Allow NULL? 
59DDEDTMSGNMEDI Transaction/Message NameStringGeneric Edit100 Allow NULL? 
60DDEDTMSGSBEDI Transaction/Message Name SubsetStringGeneric Edit30 Allow NULL? 
61DDEDTMSGTPEDI Transaction/Message Name TypeStringGeneric Edit30 Allow NULL? 
62DDTRSRTETransportation RouteStringGeneric Edit150 Allow NULL? 
63DDTRSRTSFXTransportation Route SuffixStringGeneric Edit150 Allow NULL? 
64DDUCARTNOUltimate Customer's Article NumberStringGeneric Edit150 Allow NULL? 
65DDVINNOVehicle Identification NumberStringGeneric Edit200 Allow NULL? 
66DDPENDDLTOption - Pending DeleteCharacterGeneric Edit10 Allow NULL? 
67DDSDIDSupplemental Data IDNumericGeneric Edit80 Allow NULL? 
68DDNETVCNet VarianceNumericGeneric Edit73 Allow NULL? 
69DDNETVCNTFOption - Net Variance NotificationCharacterGeneric Edit10 Allow NULL? 
70DDCRTCLIDCritical IDStringUDC (40R CI)20 Allow NULL? 
71DDDMD06Category Code - Demand 06StringUDC (40R 06)30 Allow NULL? 
72DDDMD07Category Code - Demand 07StringUDC (40R 07)30 Allow NULL? 
73DDDMD08Category Code - Demand 08StringUDC (40R 08)30 Allow NULL? 
74DDDMD09Category Code - Demand 09StringUDC (40R 09)30 Allow NULL? 
75DDDMD10Category Code - Demand 10StringUDC (40R 10)30 Allow NULL? 
76DDDMDREF1Demand Reference 1StringGeneric Edit350 Allow NULL? 
77DDDMDREF2Demand Reference 2StringGeneric Edit350 Allow NULL? 
78DDCTLNUMControl NumberStringGeneric Edit350 Allow NULL? 
79DDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
80DDURDTUser Reserved DateDateGeneric Edit60
81DDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
82DDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
83DDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
84DDUSERUser IDStringGeneric Edit100 Allow NULL? 
85DDPIDProgram IDStringGeneric Edit100 Allow NULL? 
86DDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
87DDUPMJDate - UpdatedDateGeneric Edit60
88DDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
89DDCARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
90DDDELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 
91DDCIRVQItem Revision Level QualifierStringUDC (40R IQ)20 Allow NULL? 
92DDPRODTYPEProduct TypeStringGeneric Edit300 Allow NULL? 
93DDRTORSQRouting Order Sequence NumberStringGeneric Edit300 Allow NULL? 
94DDRTGDATRouting DateDateGeneric Edit60
95DDRTGTIMRouting TimeNumericGeneric Edit60 Allow NULL? 
96DDDMDREF3Demand Reference 3StringGeneric Edit350 Allow NULL? 
97DDDMDREF4Demand Reference 4StringGeneric Edit350 Allow NULL? 
98DDDMDREF5Demand Reference 5StringGeneric Edit350 Allow NULL? 
99DDDMDREF6Demand Reference 6StringGeneric Edit350 Allow NULL? 
100DDDMDREF7Demand Reference 7StringGeneric Edit350 Allow NULL? 
101DDDMDREF8Demand Reference 8StringGeneric Edit350 Allow NULL? 
102DDDMDREF9Demand Reference 9StringGeneric Edit350 Allow NULL? 
103DDDMDREF10Demand Reference 10StringGeneric Edit350 Allow NULL? 
104DDSCACStandard Carrier Alpha CodeStringGeneric Edit40 Allow NULL? 
105DDATMCNAuthorization To Meet Competition NumberNumericGeneric Edit60 Allow NULL? 
106DDOFFLNDTOff Line DateDateGeneric Edit60
107DDENGTAG1Engineering Tag 1StringGeneric Edit150 Allow NULL? 
108DDENGTAGR1Engineering Tag Reason Code 1StringUDC (40R EN)20 Allow NULL? 
109DDENGTAG2Engineering Tag 2StringGeneric Edit150 Allow NULL? 
110DDENGTAGR2Engineering Tag Reason Code 2StringUDC (40R EN)20 Allow NULL? 

TOP812 | 40R | F40R11 INDEXES

NumberDescription
1Demand Unique Key ID (Primary/Unique)
ElementAliasDescriptionSequence
1DEIDDemand Unique Key IDAscending
2CUM ID
ElementAliasDescriptionSequence
1CUMIDCUM IDAscending
3Business Unit Address Num + (Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4ITMItem Number - ShortAscending
5RQSJDate - Requested ShipAscending
6RSHTRequested Ship TimeAscending
7DETYPDemand TypeAscending
8DEPERDemand PeriodAscending
9CSTPOCustomer POAscending
10PSIGPull SignalAscending
11PSJOBNOProduction Sequencing Job NumberAscending
12JOBSQJob Sequence NumberAscending
4Demand Batch Number
ElementAliasDescriptionSequence
1DMDBTHNODemand Batch NumberAscending
5Supplemental Dmd ID
ElementAliasDescriptionSequence
1SDIDSupplemental Data IDAscending
6Txn Msg Name Business Unit +
ElementAliasDescriptionSequence
1EDTMSGNMEDI Transaction/Message NameAscending
2MCUBusiness UnitAscending
3AN8Address NumberAscending
4SHANAddress Number - Ship ToAscending
5ITMItem Number - ShortAscending
7Dmd UKID Release Date +
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2RLSDJDate - ReleaseDescending
3RLSTMTime - ReleaseDescending
8Unique Key ID
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
9Demand Type Sold To +
ElementAliasDescriptionSequence
1DETYPDemand TypeAscending
2AN8Address NumberAscending
3SHANAddress Number - Ship ToAscending
4MCUBusiness UnitAscending
5RQSJDate - Requested ShipAscending
6RSHTRequested Ship TimeAscending
7ITMItem Number - ShortAscending