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
4F9671SDSoftware Update Detail Table
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

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

79 COLUMNS | 3 INDEXES | Print definition?920 | 47 | F470372 TABLE

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F470372AI793EDI ASN Demand Scheduling DetailFiles47: Electronic Commerce
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 AIEDTY, AIEDSQ, AIEKCO, AIEDOC, AIEDCT, AIEDLN, AIEDST, AIEDFT, AIEDDT, AIEDER, AIEDDL, AIEDSP, AIEDBT, AISTPC, AIANTY, AILINS, AICFGPID, AIASNRECID, AITHEOWT, AITHEOUOM, AICUMS, AIUOM, AIDKID, AIYEAR1, AIUCARTNO, AIMFGORDNO, AICIRV, AIVINNO, AIVNPART, AIGCNT, AICSTORDNO, AISTLRELNO, AIVNORDNO, AIENGCTL, AIASBLNLOC, AIJOBSQ, AIENDJOBSQ, AIENGTAG1, AIENGTAGR1, AIENGTAG2, AIENGTAGR2, AIHZCLSNO, AIHEATNO, AIHL03, AIHLVL, AIDMD06, AIDMD07, AIDMD08, AIDMD09, AIDMD10, AIDMDREF1, AIDMDREF2, AIURCD, AIURDT, AIURAT, AIURAB, AIURRF, AIUSER, AIPID, AIJOBN, AIUPMJ, AITDAY, AIPSJOBNO, AICIRVQ, AIDMDREF3, AIDMDREF4, AIDMDREF5, AIDMDREF6, AIDMDREF7, AIDMDREF8, AIDMDREF9, AIDMDREF10, AIASBNO, AIATMCN, AIRTORSQ, AIRTGDAT, AIRTGTIM, AIKBSNO, AIKBENO FROM F470372

TOP920 | 47 | F470372 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1AIEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2AIEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3AIEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
4AIEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
5AIEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6AIEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7AIEDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
8AIEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
9AIEDDTEDI - Transmission DateDateGeneric Edit60
10AIEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
11AIEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
12AIEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
13AIEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
14AISTPCType CodeCharacterGeneric Edit10 Allow NULL? 
15AIANTYType - Address NumberCharacterUDC (40 AN)10 Allow NULL? 
16AILINSWork Order - Line NumberNumericGeneric Edit92 Allow NULL? 
17AICFGPIDParent ID NumberNumericGeneric Edit150 Allow NULL? 
18AIASNRECIDASN Record IDNumericGeneric Edit150 Allow NULL? 
19AITHEOWTTheoretical WeightNumericGeneric Edit100 Allow NULL? 
20AITHEOUOMTheoretical Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
21AICUMSCUM Quantity ShippedNumericGeneric Edit150 Allow NULL? 
22AIUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
23AIDKIDDock IDStringGeneric Edit200 Allow NULL? 
24AIYEAR1Model Year 1NumericGeneric Edit40 Allow NULL? 
25AIUCARTNOUltimate Customer's Article NumberStringGeneric Edit150 Allow NULL? 
26AIMFGORDNOManufacturing Order NumberStringGeneric Edit300 Allow NULL? 
27AICIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
28AIVINNOVehicle Identification NumberStringGeneric Edit200 Allow NULL? 
29AIVNPARTVendor Part NumberStringGeneric Edit300 Allow NULL? 
30AIGCNTContract NumberStringGeneric Edit120 Allow NULL? 
31AICSTORDNOCustomer Order NumberStringGeneric Edit150 Allow NULL? 
32AISTLRELNOSteel Release NumberStringGeneric Edit300 Allow NULL? 
33AIVNORDNOVendor Order NumberStringGeneric Edit300 Allow NULL? 
34AIENGCTLEngineering Control NumberStringGeneric Edit300 Allow NULL? 
35AIASBLNLOCAssembly Line LocationStringGeneric Edit60 Allow NULL? 
36AIJOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
37AIENDJOBSQEnding Job Sequence NumberStringGeneric Edit150 Allow NULL? 
38AIENGTAG1Engineering Tag 1StringGeneric Edit150 Allow NULL? 
39AIENGTAGR1Engineering Tag Reason Code 1StringUDC (40R EN)20 Allow NULL? 
40AIENGTAG2Engineering Tag 2StringGeneric Edit150 Allow NULL? 
41AIENGTAGR2Engineering Tag Reason Code 2StringUDC (40R EN)20 Allow NULL? 
42AIHZCLSNOHazardous Goods ClassificationStringGeneric Edit150 Allow NULL? 
43AIHEATNOHeat NumberStringGeneric Edit160 Allow NULL? 
44AIHL03Hierarchical Level CodeStringGeneric Edit20 Allow NULL? 
45AIHLVLHierarchical LevelNumericGeneric Edit10 Allow NULL? 
46AIDMD06Category Code - Demand 06StringUDC (40R 06)30 Allow NULL? 
47AIDMD07Category Code - Demand 07StringUDC (40R 07)30 Allow NULL? 
48AIDMD08Category Code - Demand 08StringUDC (40R 08)30 Allow NULL? 
49AIDMD09Category Code - Demand 09StringUDC (40R 09)30 Allow NULL? 
50AIDMD10Category Code - Demand 10StringUDC (40R 10)30 Allow NULL? 
51AIDMDREF1Demand Reference 1StringGeneric Edit350 Allow NULL? 
52AIDMDREF2Demand Reference 2StringGeneric Edit350 Allow NULL? 
53AIURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
54AIURDTUser Reserved DateDateGeneric Edit60
55AIURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
56AIURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
57AIURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
58AIUSERUser IDStringGeneric Edit100 Allow NULL? 
59AIPIDProgram IDStringGeneric Edit100 Allow NULL? 
60AIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
61AIUPMJDate - UpdatedDateGeneric Edit60
62AITDAYTime of DayNumericGeneric Edit60 Allow NULL? 
63AIPSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
64AICIRVQItem Revision Level QualifierStringUDC (40R IQ)20 Allow NULL? 
65AIDMDREF3Demand Reference 3StringGeneric Edit350 Allow NULL? 
66AIDMDREF4Demand Reference 4StringGeneric Edit350 Allow NULL? 
67AIDMDREF5Demand Reference 5StringGeneric Edit350 Allow NULL? 
68AIDMDREF6Demand Reference 6StringGeneric Edit350 Allow NULL? 
69AIDMDREF7Demand Reference 7StringGeneric Edit350 Allow NULL? 
70AIDMDREF8Demand Reference 8StringGeneric Edit350 Allow NULL? 
71AIDMDREF9Demand Reference 9StringGeneric Edit350 Allow NULL? 
72AIDMDREF10Demand Reference 10StringGeneric Edit350 Allow NULL? 
73AIASBNOAssembly NumberStringGeneric Edit150 Allow NULL? 
74AIATMCNAuthorization To Meet Competition NumberNumericGeneric Edit60 Allow NULL? 
75AIRTORSQRouting Order Sequence NumberStringGeneric Edit300 Allow NULL? 
76AIRTGDATRouting DateDateGeneric Edit60
77AIRTGTIMRouting TimeNumericGeneric Edit60 Allow NULL? 
78AIKBSNOKanban Start NumberStringGeneric Edit150 Allow NULL? 
79AIKBENOKanban End NumberStringGeneric Edit150 Allow NULL? 

TOP920 | 47 | F470372 INDEXES

NumberDescription
1Document Number Doc Type A (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4STPCType CodeAscending
5ANTYType - Address NumberAscending
6LINSWork Order - Line NumberAscending
7EDLNEDI - Line NumberAscending
2Document Number Doc Type B
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberDescending
3Document Number Doc Type C
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4ASNRECIDASN Record IDDescending