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

115 COLUMNS | 2 INDEXES | Print definition?920 | 40R | F47172 TABLE

40R: Demand Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F47172ED1152EDI Demand 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 EDEDTY, EDEDSQ, EDEKCO, EDEDOC, EDEDCT, EDEDLN, EDEDST, EDEDFT, EDEDDT, EDEDER, EDEDDL, EDEDSP, EDEDBT, EDITM, EDLITM, EDAITM, EDCITM, EDCSTPO, EDCSTPODJ, EDCSTPOTM, EDCSTPOLIN, EDDKID, EDDVAN, EDCIRV, EDYEAR1, EDPTRLSSTS, EDLCRCVDJ, EDLCRCVQTY, EDLCRCVTM, EDLCRCVUOM, EDLCSHPDJ, EDLCSHPQTY, EDLCSHPTM, EDLCSHPUOM, EDLASTSID, EDOPTCUMQY, EDCUMREFNO, EDCCUMRQY, EDCCUMRDJ, EDCCUMRTM, EDCRQQYFM, EDCRQQYPN, EDCRQQYPS, EDCRQSDJFM, EDCRQSTMFM, EDCRQEDJFM, EDCRQETMFM, EDCRQSDJPN, EDCRQSTMPN, EDCRQEDJPN, EDCRQETMPN, EDCRQSDJPS, EDCRQSTMPS, EDCRQEDJPS, EDCRQETMPS, EDCCUMSQY, EDCCUMSDJ, EDCCUMSTM, EDCCUMSUOM, EDFBCUMQY, EDFBCUMSDJ, EDFBCUMEDJ, EDMTCUMQY, EDMTCUMSDJ, EDMTCUMEDJ, EDVINNO, EDASBLNFD, EDASBLNLOC, EDASBNO, EDGCNT, EDCSTORDNO, EDHZCLSNO, EDKBSNO, EDKBENO, EDLABORHR, EDRSVLNFD, EDTRSRTE, EDTRSRTSFX, EDUCARTNO, EDCTLNUM, EDDMD01, EDDMD02, EDDMD03, EDDMD04, EDDMD05, EDDMDREF1, EDDMDREF2, EDURCD, EDURDT, EDURAT, EDURAB, EDURRF, EDUSER, EDPID, EDJOBN, EDUPMJ, EDTDAY, EDCARDNO, EDCIRVQ, EDPRODTYPE, EDRTORSQ, EDRTGDAT, EDRTGTIM, EDDMDREF3, EDDMDREF4, EDDMDREF5, EDDMDREF6, EDDMDREF7, EDDMDREF8, EDDMDREF9, EDDMDREF10, EDSCAC, EDATMCN, EDOFFLNDT, EDGDVAN FROM F47172

TOP920 | 40R | F47172 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1EDEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2EDEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3EDEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
4EDEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
5EDEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6EDEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7EDEDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
8EDEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
9EDEDDTEDI - Transmission DateDateGeneric Edit60
10EDEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
11EDEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
12EDEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
13EDEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
14EDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
15EDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
16EDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
17EDCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
18EDCSTPOCustomer POStringGeneric Edit300 Allow NULL? 
19EDCSTPODJDate - Customer PODateGeneric Edit60
20EDCSTPOTMCustomer PO TimeNumericGeneric Edit60 Allow NULL? 
21EDCSTPOLINCustomer PO LineStringGeneric Edit50 Allow NULL? 
22EDDKIDDock IDStringGeneric Edit200 Allow NULL? 
23EDDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
24EDCIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
25EDYEAR1Model Year 1NumericGeneric Edit40 Allow NULL? 
26EDPTRLSSTSCode - Part Release StatusStringGeneric Edit20 Allow NULL? 
27EDLCRCVDJDate - Last Customer ReceivedDateGeneric Edit60
28EDLCRCVQTYLast Customer Received QuantityNumericGeneric Edit150 Allow NULL? 
29EDLCRCVTMLast Customer Received TimeNumericGeneric Edit60 Allow NULL? 
30EDLCRCVUOMLast Customer Received UOMStringGeneric Edit20 Allow NULL? 
31EDLCSHPDJDate - Last Customer ShippedDateGeneric Edit60
32EDLCSHPQTYLast Customer Shipped QuantityNumericGeneric Edit150 Allow NULL? 
33EDLCSHPTMLast Customer Shipped TimeNumericGeneric Edit60 Allow NULL? 
34EDLCSHPUOMLast Customer Shipped UOMStringGeneric Edit20 Allow NULL? 
35EDLASTSIDLast Shipment Identification NumberStringGeneric Edit160 Allow NULL? 
36EDOPTCUMQYOption - CUM QuantityCharacterGeneric Edit10 Allow NULL? 
37EDCUMREFNOCUM Reference NumberStringGeneric Edit250 Allow NULL? 
38EDCCUMRQYCustomer CUM Received QuantityNumericGeneric Edit150 Allow NULL? 
39EDCCUMRDJDate - Customer CUM ReceivedDateGeneric Edit60
40EDCCUMRTMCustomer CUM Received TimeNumericGeneric Edit60 Allow NULL? 
41EDCRQQYFMCUM Required Quantity - FirmNumericGeneric Edit150 Allow NULL? 
42EDCRQQYPNCUM Required Quantity - PlanNumericGeneric Edit150 Allow NULL? 
43EDCRQQYPSCUM Required Quantity - Production SeqNumericGeneric Edit150 Allow NULL? 
44EDCRQSDJFMDate - Firm CUM Required StartDateGeneric Edit60
45EDCRQSTMFMCUM Required Start Time - FirmNumericGeneric Edit60 Allow NULL? 
46EDCRQEDJFMDate - Firm CUM Required EndDateGeneric Edit60
47EDCRQETMFMCUM Required End Time - FirmNumericGeneric Edit60 Allow NULL? 
48EDCRQSDJPNDate - Plan CUM Required StartDateGeneric Edit60
49EDCRQSTMPNCUM Required Start Time - PlanNumericGeneric Edit60 Allow NULL? 
50EDCRQEDJPNDate - Plan CUM Required EndDateGeneric Edit60
51EDCRQETMPNCUM Required End Time - PlanNumericGeneric Edit60 Allow NULL? 
52EDCRQSDJPSDate - Prod Seq CUM Required StartDateGeneric Edit60
53EDCRQSTMPSCUM Required Start Time - Prod SeqNumericGeneric Edit60 Allow NULL? 
54EDCRQEDJPSDate - Prod Seq CUM Required EndDateGeneric Edit60
55EDCRQETMPSCUM Required End Time - Prod SeqNumericGeneric Edit60 Allow NULL? 
56EDCCUMSQYCustomer CUM Shipped QuantityNumericGeneric Edit150 Allow NULL? 
57EDCCUMSDJDate - Customer CUM ShippedDateGeneric Edit60
58EDCCUMSTMCustomer CUM Shipped TimeNumericGeneric Edit60 Allow NULL? 
59EDCCUMSUOMCustomer CUM Shipped UOMStringGeneric Edit20 Allow NULL? 
60EDFBCUMQYFabrication CUM QuantityNumericGeneric Edit150 Allow NULL? 
61EDFBCUMSDJDate - Fabrication CUM StartDateGeneric Edit60
62EDFBCUMEDJDate - Fabrication CUM EndDateGeneric Edit60
63EDMTCUMQYMaterial CUM QuantityNumericGeneric Edit150 Allow NULL? 
64EDMTCUMSDJDate - Material CUM StartDateGeneric Edit60
65EDMTCUMEDJDate - Material CUM EndDateGeneric Edit60
66EDVINNOVehicle Identification NumberStringGeneric Edit200 Allow NULL? 
67EDASBLNFDAssembly Line FeedStringGeneric Edit100 Allow NULL? 
68EDASBLNLOCAssembly Line LocationStringGeneric Edit60 Allow NULL? 
69EDASBNOAssembly NumberStringGeneric Edit150 Allow NULL? 
70EDGCNTContract NumberStringGeneric Edit120 Allow NULL? 
71EDCSTORDNOCustomer Order NumberStringGeneric Edit150 Allow NULL? 
72EDHZCLSNOHazardous Goods ClassificationStringGeneric Edit150 Allow NULL? 
73EDKBSNOKanban Start NumberStringGeneric Edit150 Allow NULL? 
74EDKBENOKanban End NumberStringGeneric Edit150 Allow NULL? 
75EDLABORHRLabor HoursNumericGeneric Edit150 Allow NULL? 
76EDRSVLNFDReserve Line FeedStringGeneric Edit100 Allow NULL? 
77EDTRSRTETransportation RouteStringGeneric Edit150 Allow NULL? 
78EDTRSRTSFXTransportation Route SuffixStringGeneric Edit150 Allow NULL? 
79EDUCARTNOUltimate Customer's Article NumberStringGeneric Edit150 Allow NULL? 
80EDCTLNUMControl NumberStringGeneric Edit350 Allow NULL? 
81EDDMD01Category Code - Demand 01StringUDC (40R 01)30 Allow NULL? 
82EDDMD02Category Code - Demand 02StringUDC (40R 02)30 Allow NULL? 
83EDDMD03Category Code - Demand 03StringUDC (40R 03)30 Allow NULL? 
84EDDMD04Category Code - Demand 04StringUDC (40R 04)30 Allow NULL? 
85EDDMD05Category Code - Demand 05StringUDC (40R 05)30 Allow NULL? 
86EDDMDREF1Demand Reference 1StringGeneric Edit350 Allow NULL? 
87EDDMDREF2Demand Reference 2StringGeneric Edit350 Allow NULL? 
88EDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
89EDURDTUser Reserved DateDateGeneric Edit60
90EDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
91EDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
92EDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
93EDUSERUser IDStringGeneric Edit100 Allow NULL? 
94EDPIDProgram IDStringGeneric Edit100 Allow NULL? 
95EDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
96EDUPMJDate - UpdatedDateGeneric Edit60
97EDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
98EDCARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
99EDCIRVQItem Revision Level QualifierStringUDC (40R IQ)20 Allow NULL? 
100EDPRODTYPEProduct TypeStringGeneric Edit300 Allow NULL? 
101EDRTORSQRouting Order Sequence NumberStringGeneric Edit300 Allow NULL? 
102EDRTGDATRouting DateDateGeneric Edit60
103EDRTGTIMRouting TimeNumericGeneric Edit60 Allow NULL? 
104EDDMDREF3Demand Reference 3StringGeneric Edit350 Allow NULL? 
105EDDMDREF4Demand Reference 4StringGeneric Edit350 Allow NULL? 
106EDDMDREF5Demand Reference 5StringGeneric Edit350 Allow NULL? 
107EDDMDREF6Demand Reference 6StringGeneric Edit350 Allow NULL? 
108EDDMDREF7Demand Reference 7StringGeneric Edit350 Allow NULL? 
109EDDMDREF8Demand Reference 8StringGeneric Edit350 Allow NULL? 
110EDDMDREF9Demand Reference 9StringGeneric Edit350 Allow NULL? 
111EDDMDREF10Demand Reference 10StringGeneric Edit350 Allow NULL? 
112EDSCACStandard Carrier Alpha CodeStringGeneric Edit40 Allow NULL? 
113EDATMCNAuthorization To Meet Competition NumberNumericGeneric Edit60 Allow NULL? 
114EDOFFLNDTOff Line DateDateGeneric Edit60
115EDGDVANDeliver To Address GLNNumericGeneric Edit130 Allow NULL? 

TOP920 | 40R | F47172 INDEXES

NumberDescription
1Document Number Doc Type + (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberAscending
2Success Proc Rec Seq +
ElementAliasDescriptionSequence
1EDSPEDI - Successfully ProcessedAscending
2EDSQRecord SequenceAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDOCEDI - Document NumberAscending
5EDCTEDI - Document TypeAscending