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

63 COLUMNS | 2 INDEXES | Print definition?920 | 42 | F42UI130 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42UI130ZC632Commitment Work FileRegular Work Files42: Sales ManagementBusiness 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 ZCTCID, ZCPEID, ZCCTID, ZCJOBS, ZCXLIN, ZCDOCO, ZCDCTO, ZCKCOO, ZCLNID, ZCSEQ, ZCEDTY, ZCITM, ZCMCU, ZCUOM, ZCPDDJ, ZCSOQS, ZCSOBK, ZCSOCN, ZCLOCN, ZCLOTN, ZCSHCM, ZCSHCN, ZCSRP1, ZCSRP2, ZCSRP3, ZCSRP4, ZCSRP5, ZCPRP1, ZCPRP2, ZCPRP3, ZCPRP4, ZCPRP5, ZCRPRC, ZCORPR, ZCVEND, ZCBUYR, ZCCARS, ZCINMG, ZCPRGR, ZCSTKT, ZCTAX1, ZCLNTY, ZCMOT, ZCROUT, ZCUNCS, ZCCOMM, ZCRSDJ, ZCFRGD, ZCTHGD, ZCFRMP, ZCTHRP, ZCCPQS, ZCCPBK, ZCCPCN, ZCEDCK, ZCSBCK, ZCCMDM, ZCBBCK, ZCSQOR, ZCSONE, ZCGENSTR, ZCPPDJ, ZCALLOC FROM F42UI130

TOP920 | 42 | F42UI130 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ZCTCIDTransaction IDNumericGeneric Edit150 Allow NULL? 
2ZCPEIDProcess IDNumericGeneric Edit150 Allow NULL? 
3ZCCTIDComputer IDStringGeneric Edit150 Allow NULL? 
4ZCJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
5ZCXLINLine NumberNumericGeneric Edit63 Allow NULL? 
6ZCDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7ZCDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8ZCKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
9ZCLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
10ZCSEQSequence NumberNumericGeneric Edit60 Allow NULL? 
11ZCEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
12ZCITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
13ZCMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
14ZCUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
15ZCPDDJDate - Scheduled PickDateGeneric Edit60
16ZCSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
17ZCSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
18ZCSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
19ZCLOCNLocationStringGeneric Edit200 Allow NULL? 
20ZCLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
21ZCSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
22ZCSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
23ZCSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
24ZCSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
25ZCSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
26ZCSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
27ZCSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
28ZCPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
29ZCPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
30ZCPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
31ZCPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
32ZCPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
33ZCRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
34ZCORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
35ZCVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
36ZCBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
37ZCCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
38ZCINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
39ZCPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
40ZCSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
41ZCTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
42ZCLNTYLine TypeStringGeneric Edit20 Allow NULL? 
43ZCMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
44ZCROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
45ZCUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
46ZCCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
47ZCRSDJDate - Promised DeliveryDateGeneric Edit60
48ZCFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
49ZCTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
50ZCFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
51ZCTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
52ZCCPQSQuantity Shipped VarianceNumericGeneric Edit150 Allow NULL? 
53ZCCPBK Qty Backordered/Held VarianceNumericGeneric Edit150 Allow NULL? 
54ZCCPCNQuantity Canceled/Scrapped VarianceNumericGeneric Edit150 Allow NULL? 
55ZCEDCKCheck Expiration DateCharacterGeneric Edit10 Allow NULL? 
56ZCSBCKCheck Sell By DateCharacterGeneric Edit10 Allow NULL? 
57ZCCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
58ZCBBCKCheck Best Before DateCharacterGeneric Edit10 Allow NULL? 
59ZCSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
60ZCSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
61ZCGENSTRGeneric String Field ValueStringGeneric Edit300 Allow NULL? 
62ZCPPDJDate - Promised ShipmentDateGeneric Edit60
63ZCALLOCAllocation Process FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 42 | F42UI130 INDEXES

NumberDescription
1CTID JOBS + (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2PEIDProcess IDAscending
3TCIDTransaction IDAscending
4JOBSJob NumberAscending
5XLINLine NumberAscending
6SEQSequence NumberAscending
2CTID JOBS +B (Unique)
ElementAliasDescriptionSequence
1PEIDProcess IDAscending
2CTIDComputer IDAscending
3TCIDTransaction IDAscending
4JOBSJob NumberAscending
5XLINLine NumberAscending
6EDTYType RecordAscending
7ITMItem Number - ShortAscending
8MCUBusiness UnitAscending
9LOCNLocationAscending
10LOTNLot/Serial NumberAscending
11SEQSequence NumberAscending