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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

62 COLUMNS | 2 INDEXES | Print definition?812 | 42 | F42UI130 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F42UI130ZC622Commitment Work FileRegular Work Files42: Sales ManagementNo
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 FROM F42UI130

TOP812 | 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 Edit152 Allow NULL? 
17ZCSOBKUnits - Qty Backordered/HeldNumericGeneric Edit152 Allow NULL? 
18ZCSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 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 Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
24ZCSRP2Sales Rpt 02 - Family 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 Edit152 Allow NULL? 
53ZCCPBK Qty Backordered/Held VarianceNumericGeneric Edit152 Allow NULL? 
54ZCCPCNQuantity Canceled/Scrapped VarianceNumericGeneric Edit152 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 Edit152 Allow NULL? 
60ZCSONEUnits - Future Quantity CommittedNumericGeneric Edit152 Allow NULL? 
61ZCGENSTRGeneric String Field ValueStringGeneric Edit300 Allow NULL? 
62ZCPPDJDate - Promised ShipmentDateGeneric Edit60

TOP812 | 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