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

155 COLUMNS | 3 INDEXES | Print definition?920 | 42 | F42UI12 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42UI12ZD1553Sales Order Detail Cache 2 (MBF)Regular Work Files42B: Sales Order EntryBusiness 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 ZDCTID, ZDJOBS, ZDLNIX, ZDKCOO, ZDDOCO, ZDDCTO, ZDLNID, ZDOPDJ, ZDPPDJ, ZDTHGD, ZDTHRP, ZDFRGD, ZDFRMP, ZDEMCU, ZDSRP1, ZDSRP2, ZDSRP3, ZDSRP4, ZDSRP5, ZDPRP1, ZDPRP2, ZDPRP3, ZDPRP4, ZDPRP5, ZDINMG, ZDPTC, ZDDTBS, ZDRYIN, ZDTRDC, ZDPRGR, ZDCADC, ZDKCO, ZDDOC, ZDDCT, ZDTXA1, ZDEXR1, ZDPRIO, ZDBACK, ZDSBAL, ZDLOB, ZDEUSE, ZDDTYS, ZDNTR, ZDCARS, ZDMOT, ZDROUT, ZDSTOP, ZDZON, ZDAFT, ZDFRTH, ZDSHCM, ZDSHCN, ZDSERN, ZDGLC, ZDACOM, ZDRCD, ZDGWUM, ZDSBL, ZDSBLT, ZDLCOD, ZDSWMS, ZDUNCD, ZDCRMD, ZDURCD, ZDURDT, ZDURAT, ZDURAB, ZDURRF, ZDFRAT, ZDMCU, ZDITM, ZDLOCN, ZDLOTN, ZDUOM, ZDSOQS, ZDSOBK, ZDSONE, ZDOTQY, ZDFFG1, ZDFFG2, ZDFFU2, ZDSHPN, ZDRSDT, ZDOSEQ, ZDMERL, ZDHDBU, ZDDMBU, ZDBCRC, ZDDEID, ZDPSIG, ZDPMDT, ZDRLTM, ZDRLDJ, ZDADTM, ZDOPTT, ZDPDTT, ZDPSTM, ZDXDCK, ZDXPTY, ZDXKCO, ZDXORN, ZDXCTO, ZDXLLN, ZDXSFX, ZDANBY, ZDPMTN, ZDOPOL, ZDOPBO, ZDOPID, ZDOPCS, ZDOPLL, ZDOPMS, ZDOPSS, ZDOPBA, ZDOPMG, ZDOPSG, ZDOPYN, ZDOPSU, ZDFXSR, ZDEDCK, ZDSBCK, ZDBBCK, ZDCMDM, ZDDUAL, ZDSOEF, ZDSOEG, ZDPSJOBNO, ZDJOBSQ, ZDDELBATCH, ZDCARDNO, ZDALLOC, ZDFULPID, ZDALLSTS, ZDOSCORE, ZDOSCOREO, ZDCMCO, ZDKITID, ZDKITAMTDOM, ZDKITAMTFOR, ZDKITDIRTY, ZDOCITT, ZDOCCARDNO, ZDTUPRC, ZDUTA, ZDTAEXP, ZDETA, ZDTFUP, ZDFUTA, ZDTFEA, ZDFETA, ZDTPROV, ZDDTXJ, ZDTKITAMTD, ZDTKITAMTF, ZDCRCD FROM F42UI12

TOP920 | 42 | F42UI12 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ZDCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2ZDJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3ZDLNIXLine Number - X-REFNumericGeneric Edit63 Allow NULL? 
4ZDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
5ZDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
6ZDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
7ZDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
8ZDOPDJDate - Original Promised DeliveryDateGeneric Edit60
9ZDPPDJDate - Promised ShipmentDateGeneric Edit60
10ZDTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
11ZDTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
12ZDFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
13ZDFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
14ZDEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
15ZDSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
16ZDSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
17ZDSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
18ZDSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
19ZDSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
20ZDPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
21ZDPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
22ZDPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
23ZDPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
24ZDPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
25ZDINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
26ZDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
27ZDDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
28ZDRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
29ZDTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
30ZDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
31ZDCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
32ZDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
33ZDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
34ZDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
35ZDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
36ZDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
37ZDPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
38ZDBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
39ZDSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
40ZDLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
41ZDEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
42ZDDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
43ZDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
44ZDCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
45ZDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
46ZDROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
47ZDSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
48ZDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
49ZDAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
50ZDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
51ZDSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
52ZDSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
53ZDSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
54ZDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
55ZDACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
56ZDRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
57ZDGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
58ZDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
59ZDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
60ZDLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
61ZDSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
62ZDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
63ZDCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
64ZDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
65ZDURDTUser Reserved DateDateGeneric Edit60
66ZDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
67ZDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
68ZDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
69ZDFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
70ZDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
71ZDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
72ZDLOCNLocationStringGeneric Edit200 Allow NULL? 
73ZDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
74ZDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
75ZDSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
76ZDSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
77ZDSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
78ZDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
79ZDFFG1Flag for Future 01CharacterGeneric Edit10 Allow NULL? 
80ZDFFG2Flag for Future 02CharacterGeneric Edit10 Allow NULL? 
81ZDFFU2FlagCharacterGeneric Edit10 Allow NULL? 
82ZDSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
83ZDRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
84ZDOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
85ZDMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
86ZDHDBUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
87ZDDMBUBusiness Unit - DemandStringGeneric Edit120 Allow NULL? 
88ZDBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
89ZDDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
90ZDPSIGPull SignalStringGeneric Edit300 Allow NULL? 
91ZDPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
92ZDRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
93ZDRLDJDate - ReleaseDateGeneric Edit60
94ZDADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
95ZDOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
96ZDPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
97ZDPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
98ZDXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
99ZDXPTYCross Docking Priority for Sales OrdersNumericGeneric Edit150 Allow NULL? 
100ZDXKCOCross Dock Order Company (Order Number)StringGeneric Edit50 Allow NULL? 
101ZDXORNCross Dock Order NoNumericGeneric Edit80 Allow NULL? 
102ZDXCTOCross Dock Order TypeStringUDC (00 DT)20 Allow NULL? 
103ZDXLLNCross Dock Line NumberNumericGeneric Edit63 Allow NULL? 
104ZDXSFXCross Dock Order SuffixStringGeneric Edit30 Allow NULL? 
105ZDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
106ZDPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
107ZDOPOLOP Original Line NumberNumericGeneric Edit63 Allow NULL? 
108ZDOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
109ZDOPIDOP Scenario IDStringGeneric Edit300 Allow NULL? 
110ZDOPCSOP CostNumericGeneric Edit154 Allow NULL? 
111ZDOPLLOP Partial Ship Line ItemsCharacterGeneric Edit10 Allow NULL? 
112ZDOPMSOP Allow Multi SourceCharacterGeneric Edit10 Allow NULL? 
113ZDOPSSOP Allow SubstitutesCharacterGeneric Edit10 Allow NULL? 
114ZDOPBAOP Allow BackordersCharacterGeneric Edit10 Allow NULL? 
115ZDOPMGOP Multi Source GroupStringGeneric Edit300 Allow NULL? 
116ZDOPSGOP Shipping GroupStringGeneric Edit300 Allow NULL? 
117ZDOPYNOP Promise Line (Y/N)CharacterGeneric Edit10 Allow NULL? 
118ZDOPSUOP Allow Split UOMCharacterGeneric Edit10 Allow NULL? 
119ZDFXSRFix Source LocationCharacterGeneric Edit10 Allow NULL? 
120ZDEDCKCheck Expiration DateCharacterGeneric Edit10 Allow NULL? 
121ZDSBCKCheck Sell By DateCharacterGeneric Edit10 Allow NULL? 
122ZDBBCKCheck Best Before DateCharacterGeneric Edit10 Allow NULL? 
123ZDCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
124ZDDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
125ZDSOEFSales Order Entry MBF Internal FlagsStringGeneric Edit300 Allow NULL? 
126ZDSOEGSales Order Entry MBF Internal Flags2StringGeneric Edit300 Allow NULL? 
127ZDPSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
128ZDJOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
129ZDDELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 
130ZDCARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
131ZDALLOCAllocation Process FlagCharacterGeneric Edit10 Allow NULL? 
132ZDFULPIDFulfillment Plan IDIntegerGeneric Edit110 Allow NULL? 
133ZDALLSTSAllocation Status NumberStringUDC (42 AS)300 Allow NULL? 
134ZDOSCORESales Order ScoreNumericGeneric Edit153 Allow NULL? 
135ZDOSCOREOOrder Score OverrideCharacterGeneric Edit10 Allow NULL? 
136ZDCMCOCustomer Master CompanyStringGeneric Edit50 Allow NULL? 
137ZDKITIDKit IdentifierNumericGeneric Edit150 Allow NULL? 
138ZDKITAMTDOMAccumulated Amount Invoiced (Domestic)NumericGeneric Edit152 Allow NULL? 
139ZDKITAMTFORAccumulated Amount Invoiced (Foreign)NumericGeneric Edit152 Allow NULL? 
140ZDKITDIRTYKit Component Dirty FlagCharacterGeneric Edit10 Allow NULL? 
141ZDOCITTOC In-Transit FlagCharacterGeneric Edit10 Allow NULL? 
142ZDOCCARDNOOC Kanban Card NoNumericGeneric Edit80 Allow NULL? 
143ZDTUPRCTaxed Unit PriceNumericGeneric Edit154 Allow NULL? 
144ZDUTAUnit Tax AmountNumericGeneric Edit154 Allow NULL? 
145ZDTAEXPTaxed Extended PriceNumericGeneric Edit152 Allow NULL? 
146ZDETAExtended Tax AmountNumericGeneric Edit152 Allow NULL? 
147ZDTFUPForeign Taxed Unit PriceNumericGeneric Edit154 Allow NULL? 
148ZDFUTAForeign Unit Tax AmountNumericGeneric Edit154 Allow NULL? 
149ZDTFEAForeign Taxed Extended PriceNumericGeneric Edit152 Allow NULL? 
150ZDFETAForeign Extended Tax AmountNumericGeneric Edit152 Allow NULL? 
151ZDTPROVTaxed Price Override CodeCharacterGeneric Edit10 Allow NULL? 
152ZDDTXJInternal SO Tax DateDateGeneric Edit60
153ZDTKITAMTDKit Taxed Price InvoicedNumericGeneric Edit152 Allow NULL? 
154ZDTKITAMTFForeign Kit Taxed Price InvoicedNumericGeneric Edit152 Allow NULL? 
155ZDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 

TOP920 | 42 | F42UI12 INDEXES

NumberDescription
1Computer ID Job No (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3LNIXLine Number - X-REFAscending
4DOCODocument (Order No Invoice etc.)Ascending
5DCTOOrder TypeAscending
6KCOOOrder Company (Order Number)Ascending
7LNIDLine NumberAscending
2Computer ID Job No Item
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3LNIXLine Number - X-REFAscending
3Computer ID Job No Company
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3KCOOOrder Company (Order Number)Ascending
4DOCODocument (Order No Invoice etc.)Ascending
5DCTOOrder TypeAscending
6LNIDLine NumberAscending