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

217 COLUMNS | 1 INDEXES | Print definition?920 | 47 | F47037 TABLE

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F47037SZ2171EDI Shipping Notice Detail - OutboundBatch Input 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 SZEDTY, SZEDSQ, SZEKCO, SZEDOC, SZEDCT, SZEDLN, SZEDST, SZEDFT, SZEDDT, SZEDER, SZEDDL, SZEDSP, SZEDBT, SZPNID, SZSPID, SZHLVL, SZHL03, SZKCOO, SZDOCO, SZDCTO, SZLNID, SZSFXO, SZMCU, SZCO, SZOKCO, SZOORN, SZOCTO, SZOGNO, SZRKCO, SZRORN, SZRCTO, SZRLLN, SZAN8, SZSHAN, SZPA8, SZDRQJ, SZTRDJ, SZPDDJ, SZOPDJ, SZADDJ, SZIVD, SZCNDJ, SZDGL, SZRSDJ, SZPEFJ, SZPPDJ, SZVR01, SZVR02, SZITM, SZLITM, SZAITM, SZCITM, SZLOCN, SZLOTN, SZFRGD, SZTHGD, SZFRMP, SZTHRP, SZEXDP, SZDSC1, SZDSC2, SZLNTY, SZNXTR, SZLTTR, SZEMCU, SZRLIT, SZKTLN, SZCPNT, SZRKIT, SZKTP, SZSRP1, SZSRP2, SZSRP3, SZSRP4, SZSRP5, SZPRP1, SZPRP2, SZUOM, SZUORG, SZSOQS, SZSOBK, SZSOCN, SZSONE, SZUOPN, SZQTYT, SZQRLV, SZCOMM, SZOTQY, SZUPRC, SZAEXP, SZAOPN, SZAPUM, SZLPRC, SZUNCS, SZECST, SZCSTO, SZTCST, SZINMG, SZPTC, SZRYIN, SZDTBS, SZTRDC, SZDSPR, SZDSFT, SZCADC, SZKCO, SZDOC, SZDCT, SZODOC, SZODCT, SZOKC, SZPSN, SZDELN, SZATXT, SZPRIO, SZAPTS, SZLOB, SZEUSE, SZDTYS, SZNTR, SZCARS, SZMOT, SZCOT, SZROUT, SZSTOP, SZZON, SZCNID, SZFRTH, SZAFT, SZFUF1, SZFRTC, SZFRAT, SZRATT, SZSHCM, SZSHCN, SZSERN, SZUOM1, SZPQOR, SZUOM2, SZSQOR, SZUOM4, SZITWT, SZWTUM, SZITVL, SZVLUM, SZRPRC, SZGLC, SZCTRY, SZFY, SZSTTS, SZRCD, SZGRWT, SZGWUM, SZSUB, SZLCOD, SZCRMD, SZCRCD, SZCRR, SZFPRC, SZFUP, SZFEA, SZFUC, SZFEC, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZSTPC, SZSHPN, SZWGTS, SZWGQ, SZWGTU, SZROTE, SZRF2, SZRFQ1, SZRFQ2, SZUPCN, SZUPQT, SZUPUM, SZSCCN, SZSCCQ, SZSCUM, SZPKCD, SZPAK, SZPLT, SZLINS, SZID1, SZIDQ1, SZID2, SZIDQ2, SZHLSC, SZHLCF, SZEQNB, SZEQIN, SZEQCD, SZAN81, SZMLNM, SZADD1, SZADD2, SZADD3, SZADD4, SZCTY1, SZCOUN, SZADDS, SZCTR, SZADDZ, SZGAN8, SZGSHAN, SZGPA8, SZGANS8 FROM F47037

TOP920 | 47 | F47037 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2SZEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
4SZEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
5SZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7SZEDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
8SZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
9SZEDDTEDI - Transmission DateDateGeneric Edit60
10SZEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
11SZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
12SZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
13SZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
14SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
15SZSPIDShipment I.D.StringGeneric Edit200 Allow NULL? 
16SZHLVLHierarchical LevelNumericGeneric Edit10 Allow NULL? 
17SZHL03Hierarchical Level CodeStringGeneric Edit20 Allow NULL? 
18SZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
19SZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
20SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
21SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
22SZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
23SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
24SZCOCompanyStringGeneric Edit50 Allow NULL? 
25SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
26SZOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
27SZOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
28SZOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
29SZRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
30SZRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
31SZRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
32SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
33SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
34SZSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
35SZPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
36SZDRQJDate - RequestedDateGeneric Edit60
37SZTRDJDate - Order/TransactionDateGeneric Edit60
38SZPDDJDate - Scheduled PickDateGeneric Edit60
39SZOPDJDate - Original Promised DeliveryDateGeneric Edit60
40SZADDJDate - Actual Ship DateDateGeneric Edit60
41SZIVDDate - InvoiceDateGeneric Edit60
42SZCNDJDate - CancelDateGeneric Edit60
43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
44SZRSDJDate - Promised DeliveryDateGeneric Edit60
45SZPEFJDate - Price Effective DateDateGeneric Edit60
46SZPPDJDate - Promised ShipmentDateGeneric Edit60
47SZVR01ReferenceStringGeneric Edit250 Allow NULL? 
48SZVR02Reference 2StringGeneric Edit250 Allow NULL? 
49SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
50SZLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
51SZAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
52SZCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
53SZLOCNLocationStringGeneric Edit200 Allow NULL? 
54SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
55SZFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
56SZTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
57SZFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
58SZTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
59SZEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
60SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
61SZDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
62SZLNTYLine TypeStringGeneric Edit20 Allow NULL? 
63SZNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
64SZLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
65SZEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
66SZRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
67SZKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
68SZCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
69SZRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
70SZKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
71SZSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
72SZSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
73SZSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
74SZSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
75SZSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
76SZPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
77SZPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
78SZUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
79SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
80SZSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
81SZSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
82SZSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
83SZSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
84SZUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
85SZQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
86SZQRLVUnits - RelievedNumericGeneric Edit150 Allow NULL? 
87SZCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
88SZOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
89SZUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
90SZAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
91SZAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
92SZAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
93SZLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
94SZUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
95SZECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
96SZCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
97SZTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
98SZINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
99SZPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
100SZRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
101SZDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
102SZTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
103SZDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
104SZDSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
105SZCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
106SZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
107SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
108SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
109SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
110SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
111SZOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
112SZPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
113SZDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
114SZATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
115SZPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
116SZAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
117SZLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
118SZEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
119SZDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
120SZNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
121SZCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
122SZMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
123SZCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
124SZROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
125SZSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
126SZZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
127SZCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
128SZFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
129SZAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
130SZFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
131SZFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
132SZFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
133SZRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
134SZSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
135SZSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
136SZSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
137SZUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
138SZPQORUnits - Primary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
139SZUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
140SZSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
141SZUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
142SZITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
143SZWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
144SZITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
145SZVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
146SZRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
147SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
148SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
149SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
150SZSTTSLine StatusStringGeneric Edit20 Allow NULL? 
151SZRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
152SZGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
153SZGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
154SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
155SZLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
156SZCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
157SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
158SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
159SZFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
160SZFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
161SZFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
162SZFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
163SZFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
164SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
165SZURDTUser Reserved DateDateGeneric Edit60
166SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
167SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
168SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
169SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
170SZUSERUser IDStringGeneric Edit100 Allow NULL? 
171SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
172SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
173SZUPMJDate - UpdatedDateGeneric Edit60
174SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
175SZSTPCType CodeCharacterGeneric Edit10 Allow NULL? 
176SZSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
177SZWGTSShipment WeightNumericGeneric Edit154 Allow NULL? 
178SZWGQWeight QualifierStringUDC (41 X2)20 Allow NULL? 
179SZWGTUWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
180SZROTERoutingStringGeneric Edit350 Allow NULL? 
181SZRF2Reference Number 2StringGeneric Edit300 Allow NULL? 
182SZRFQ1Reference Number Qualifier 1StringUDC (41 X6)20 Allow NULL? 
183SZRFQ2Reference Number Qualifier 2StringUDC (41 X6)20 Allow NULL? 
184SZUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
185SZUPQTUPC QuantityNumericGeneric Edit150 Allow NULL? 
186SZUPUMUPC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
187SZSCCNSCC NumberStringGeneric Edit140 Allow NULL? 
188SZSCCQSCC QuantityNumericGeneric Edit150 Allow NULL? 
189SZSCUMSCC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
190SZPKCDPackaging CodeStringUDC (41 X1)50 Allow NULL? 
191SZPAKSSCC Number - Pack LevelStringGeneric Edit180 Allow NULL? 
192SZPLTSSCC Number - Tare LevelStringGeneric Edit180 Allow NULL? 
193SZLINSWork Order - Line NumberNumericGeneric Edit92 Allow NULL? 
194SZID1Identifier Code 1StringGeneric Edit170 Allow NULL? 
195SZIDQ1Identifier Code Qualifier 1StringUDC (41 X3)20 Allow NULL? 
196SZID2Identifier Code 2StringGeneric Edit170 Allow NULL? 
197SZIDQ2Identifier Code Qualifier 2StringUDC (41 X3)20 Allow NULL? 
198SZHLSCHierarchical Structure CodeStringGeneric Edit40 Allow NULL? 
199SZHLCFHierarchical ConfigurationStringGeneric Edit180 Allow NULL? 
200SZEQNBEquipment NumberStringGeneric Edit100 Allow NULL? 
201SZEQINEquipment InitialStringGeneric Edit40 Allow NULL? 
202SZEQCDEquipment Description CodeStringUDC (41 X5)20 Allow NULL? 
203SZAN81Address Number - 1stNumericGeneric Edit80 Allow NULL? 
204SZMLNMName - MailingStringGeneric Edit400 Allow NULL? 
205SZADD1Address Line 1StringGeneric Edit400 Allow NULL? 
206SZADD2Address Line 2StringGeneric Edit400 Allow NULL? 
207SZADD3Address Line 3StringGeneric Edit400 Allow NULL? 
208SZADD4Address Line 4StringGeneric Edit400 Allow NULL? 
209SZCTY1CityStringGeneric Edit250 Allow NULL? 
210SZCOUNCountyStringUDC (00 CT)250 Allow NULL? 
211SZADDSStateStringUDC (00 S)30 Allow NULL? 
212SZCTRCountryStringUDC (00 CN)30 Allow NULL? 
213SZADDZPostal CodeStringGeneric Edit120 Allow NULL? 
214SZGAN8Global Location NumberNumericGeneric Edit130 Allow NULL? 
215SZGSHANShip To GLNNumericGeneric Edit130 Allow NULL? 
216SZGPA8Parent Address GLNNumericGeneric Edit130 Allow NULL? 
217SZGANS8Secondary Address GLNNumericGeneric Edit130 Allow NULL? 

TOP920 | 47 | F47037 INDEXES

NumberDescription
1EdiDocNum EdiDocType + (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberAscending