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

187 COLUMNS | 4 INDEXES | Print definition?812 | 42 | F42UI11 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F42UI11ZD1874SO Detail Cache File (MBF)Regular Work Files42B: Sales Order EntryNo
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, ZDACTN, ZDKCOO, ZDDOCO, ZDDCTO, ZDLNID, ZDSFXO, ZDMCU, ZDCO, ZDOKCO, ZDOORN, ZDOCTO, ZDOGNO, ZDRKCO, ZDRORN, ZDRCTO, ZDRLLN, ZDDMCT, ZDDMCS, ZDAN8, ZDSHAN, ZDPA8, ZDDRQJ, ZDTRDJ, ZDPDDJ, ZDADDJ, ZDIVD, ZDCNDJ, ZDDGL, ZDRSDJ, ZDPEFJ, ZDVR01, ZDVR02, ZDITM, ZDLITM, ZDAITM, ZDLOCN, ZDLOTN, ZDEXDP, ZDDSC1, ZDDSC2, ZDLNTY, ZDNXTR, ZDLTTR, ZDRLIT, ZDKTLN, ZDCPNT, ZDRKIT, ZDKTP, ZDUOM, ZDUORG, ZDSOQS, ZDSOBK, ZDSOCN, ZDSONE, ZDUOPN, ZDQTYT, ZDQRLV, ZDCOMM, ZDOTQY, ZDUPRC, ZDAEXP, ZDAOPN, ZDPROV, ZDTPC, ZDAPUM, ZDLPRC, ZDUNCS, ZDECST, ZDCSTO, ZDTCST, ZDFUN2, ZDASN, ZDCLVL, ZDODOC, ZDODCT, ZDOKC, ZDPSN, ZDDELN, ZDTAX1, ZDATXT, ZDRESL, ZDAPTS, ZDVEND, ZDCNID, ZDUOM1, ZDPQOR, ZDUOM2, ZDSQOR, ZDUOM4, ZDITWT, ZDWTUM, ZDVLUM, ZDITVL, ZDRPRC, ZDORPR, ZDORP, ZDCMGP, ZDCTRY, ZDFY, ZDCMCG, ZDGRWT, ZDUPC1, ZDUPC2, ZDUPC3, ZDCRCD, ZDCRR, ZDFPRC, ZDFUP, ZDFEA, ZDFUC, ZDFEC, ZDTORG, ZDUSER, ZDPID, ZDJOBN, ZDUPMJ, ZDTDAY, ZDSTKT, ZDWRTH, ZDIVI, ZDCONV, ZDCNV3, ZDKTCM, ZDOT1Y, ZDSTDP, ZDCS07, ZDIT07, ZDTFLA, ZDEDLN, ZDRJOB, ZDDETD, ZDDETF, ZDSHPN, ZDLINN, ZDSLNE, ZDDSGP, ZDBPFG, ZDHCDS, ZDPSR, ZDPSRY, ZDSEQ, ZDRCUP, ZDCMTR, ZDALPH, ZDPMTH, ZDSO16, ZDSO17, ZDSO18, ZDSO19, ZDSO20, ZDIR01, ZDIR02, ZDIR03, ZDIR04, ZDIR05, ZDSOOR, ZDVR03, ZDBSC, ZDCBSC, ZDCORD, ZDDVAN, ZDPEND, ZDRFRV, ZDPRJM, ZDHOLD, ZDODLN, ZDRLNU, ZDDRQT, ZDMCLN, ZDPOE, ZDPMTO, ZDNUMB, ZDAAID, ZDSPATTN, ZDPRAN8, ZDPRCIDLN, ZDCCIDLN, ZDSHCCIDLN, ZDOPPID, ZDOSTP, ZDUKID, ZDCATNM, ZDOPFR, ZDOPERROR FROM F42UI11

TOP812 | 42 | F42UI11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ZDCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2ZDJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3ZDLNIXLine Number - X-REFNumericGeneric Edit63 Allow NULL? 
4ZDACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
5ZDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
6ZDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7ZDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8ZDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
9ZDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
10ZDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11ZDCOCompanyStringGeneric Edit50 Allow NULL? 
12ZDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
13ZDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
14ZDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
15ZDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
16ZDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
17ZDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
18ZDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
19ZDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
20ZDDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
21ZDDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
22ZDAN8Address NumberNumericUDC80 Allow NULL? 
23ZDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
24ZDPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
25ZDDRQJDate - RequestedDateGeneric Edit60
26ZDTRDJDate - Order/TransactionDateGeneric Edit60
27ZDPDDJDate - Scheduled PickDateGeneric Edit60
28ZDADDJDate - Actual Ship DateDateGeneric Edit60
29ZDIVDDate - InvoiceDateGeneric Edit60
30ZDCNDJDate - CancelDateGeneric Edit60
31ZDDGLDate - For G/L (and Voucher)DateGeneric Edit60
32ZDRSDJDate - Promised DeliveryDateGeneric Edit60
33ZDPEFJDate - Price Effective DateDateGeneric Edit60
34ZDVR01ReferenceStringGeneric Edit250 Allow NULL? 
35ZDVR02Reference 2StringGeneric Edit250 Allow NULL? 
36ZDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
37ZDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
38ZDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
39ZDLOCNLocationStringGeneric Edit200 Allow NULL? 
40ZDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
41ZDEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
42ZDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
43ZDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
44ZDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
45ZDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
46ZDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
47ZDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
48ZDKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
49ZDCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
50ZDRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
51ZDKTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
52ZDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
53ZDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
54ZDSOQSQuantity ShippedNumericGeneric Edit152 Allow NULL? 
55ZDSOBKUnits - Qty Backordered/HeldNumericGeneric Edit152 Allow NULL? 
56ZDSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
57ZDSONEUnits - Future Quantity CommittedNumericGeneric Edit152 Allow NULL? 
58ZDUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
59ZDQTYTUnits - Shipped to DateNumericGeneric Edit152 Allow NULL? 
60ZDQRLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
61ZDCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
62ZDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
63ZDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
64ZDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
65ZDAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
66ZDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
67ZDTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
68ZDAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
69ZDLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
70ZDUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
71ZDECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
72ZDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
73ZDTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
74ZDFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
75ZDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
76ZDCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
77ZDODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
78ZDODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
79ZDOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
80ZDPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
81ZDDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
82ZDTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
83ZDATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
84ZDRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
85ZDAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
86ZDVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
87ZDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
88ZDUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
89ZDPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
90ZDUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
91ZDSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
92ZDUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
93ZDITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
94ZDWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
95ZDVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
96ZDITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
97ZDRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
98ZDORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
99ZDORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
100ZDCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
101ZDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
102ZDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
103ZDCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
104ZDGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
105ZDUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
106ZDUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
107ZDUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
108ZDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
109ZDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
110ZDFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
111ZDFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
112ZDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
113ZDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
114ZDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
115ZDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
116ZDUSERUser IDStringGeneric Edit100 Allow NULL? 
117ZDPIDProgram IDStringGeneric Edit100 Allow NULL? 
118ZDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
119ZDUPMJDate - UpdatedDateGeneric Edit60
120ZDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
121ZDSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
122ZDWRTHFlag - Write Ledger Record (Y/N)CharacterGeneric Edit10 Allow NULL? 
123ZDIVIInventory Interface Y/N - DistributionCharacterUDC (H40 IV)10 Allow NULL? 
124ZDCONVConversion FactorNumericGeneric Edit157 Allow NULL? 
125ZDCNV3Conversion Factor - Pricing to PrimaryNumericGeneric Edit157 Allow NULL? 
126ZDKTCMKit is Complete (1/0)CharacterGeneric Edit10 Allow NULL? 
127ZDOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
128ZDSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
129ZDCS07Customer Group - Product AllocationsStringUDC (40 07)80 Allow NULL? 
130ZDIT07Item Group - Product AllocationsStringUDC (40 57)80 Allow NULL? 
131ZDTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
132ZDEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
133ZDRJOBJob NumberNumericGeneric Edit80 Allow NULL? 
134ZDDETDAmount - Detached Adj. DomesticNumericGeneric Edit154 Allow NULL? 
135ZDDETFAmount - Detached Adj. ForeignNumericGeneric Edit154 Allow NULL? 
136ZDSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
137ZDLINNLine NumberNumericGeneric Edit73 Allow NULL? 
138ZDSLNELine NumberNumericGeneric Edit63 Allow NULL? 
139ZDDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
140ZDBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
141ZDHCDSHold Codes StringStringGeneric Edit100 Allow NULL? 
142ZDPSRSourceStringGeneric Edit120 Allow NULL? 
143ZDPSRYSource TypeStringUDC (38 DY)20 Allow NULL? 
144ZDSEQSequence NumberNumericGeneric Edit60 Allow NULL? 
145ZDRCUPUnedited record flagCharacterGeneric Edit10 Allow NULL? 
146ZDCMTRCommitment Relief (Y/N)CharacterGeneric Edit10 Allow NULL? 
147ZDALPHName - AlphaStringGeneric Edit400 Allow NULL? 
148ZDPMTHMethod - Kit/Configurator PricingCharacterUDC (H41 PM)10 Allow NULL? 
149ZDSO16Manufacturing Variance Accounting FlagCharacterGeneric Edit10 Allow NULL? 
150ZDSO17Sales Order Status 17CharacterGeneric Edit10 Allow NULL? 
151ZDSO18Sales Order Status 18CharacterGeneric Edit10 Allow NULL? 
152ZDSO19Sales Order Status 19CharacterGeneric Edit10 Allow NULL? 
153ZDSO20Sales Order Status 20CharacterGeneric Edit10 Allow NULL? 
154ZDIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
155ZDIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
156ZDIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
157ZDIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
158ZDIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
159ZDSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
160ZDVR03ReferenceStringGeneric Edit250 Allow NULL? 
161ZDBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
162ZDCBSCCurrent Buying Segment CodeStringUDC (42B BS)100 Allow NULL? 
163ZDCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
164ZDDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
165ZDPENDPending Approval FlagCharacterGeneric Edit10 Allow NULL? 
166ZDRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
167ZDPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
168ZDHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
169ZDODLNDocument Line Number - OriginalNumericGeneric Edit73 Allow NULL? 
170ZDRLNURelease NumberStringGeneric Edit100 Allow NULL? 
171ZDDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
172ZDMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
173ZDPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
174ZDPMTOPayment Terms Override CodeCharacterGeneric Edit10 Allow NULL? 
175ZDNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
176ZDAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
177ZDSPATTNShip To AttentionStringGeneric Edit500 Allow NULL? 
178ZDPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
179ZDPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
180ZDCCIDLNCustomer Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
181ZDSHCCIDLNShip To Cust Contact Line Num IDNumericGeneric Edit50 Allow NULL? 
182ZDOPPIDOpportunity NumberNumericGeneric Edit150 Allow NULL? 
183ZDOSTPOrganization Structure TypeStringUDC (01 TS)30 Allow NULL? 
184ZDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
185ZDCATNMCatalog NameStringGeneric Edit300 Allow NULL? 
186ZDOPFROP Return FlagCharacterGeneric Edit10 Allow NULL? 
187ZDOPERROROrder Promising ErrorStringGeneric Edit400 Allow NULL? 

TOP812 | 42 | F42UI11 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
2Compuer ID Job No Item
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2CTIDComputer IDAscending
3ITMItem Number - ShortAscending
3Computer ID Job No SLineNo
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3SLNELine NumberAscending
4Computer ID JobNo MatrixLineNo
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3MCLNMatrix Control Line NumberAscending
4LNIDLine NumberAscending