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

258 COLUMNS | 4 INDEXES | Print definition?920 | 47 | F470371 TABLE

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F470371SZ2584EDI Shipping Notice Detail - OutboundBatch Input Files49: Transportation 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, SZEDOC, SZEKCO, 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, SZRQSJ, SZADLJ, SZDRQT, SZRSDT, SZRSHT, SZVR01, SZVR02, SZVR03, SZITM, SZLITM, SZAITM, SZCITM, SZLOCN, SZLOTN, SZFRGD, SZTHGD, SZACGD, SZFRMP, SZAPOT, SZTHRP, SZEXDP, SZDSC1, SZDSC2, SZLNTY, SZNXTR, SZLTTR, SZEMCU, SZHDBU, SZSRP2, SZRLIT, SZKTLN, SZCPNT, SZRKIT, SZKTP, SZSRP1, SZDMBU, SZSRP3, SZSRP4, SZSRP5, SZPRP1, SZPRP2, SZUOM, SZUORG, SZSOQS, SZSOBK, SZSOCN, SZSONE, SZUOPN, SZQTYT, SZQRLV, SZCOMM, SZOTQY, SZBCRC, SZUPRC, SZAEXP, SZAOPN, SZAPUM, SZLPRC, SZUNCS, SZECST, SZCSTO, SZTCST, SZINMG, SZPTC, SZDCD, SZDCP, SZNDTP, SZPXDD, SZPXDM, 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, SZSHPN, SZSHCN, SZSERN, SZLDNM, SZTKNR, SZTKTM, SZTKDA, SZUOM1, SZPQOR, SZUOM2, SZSQOR, SZUOM4, SZITWT, SZWTUM, SZITVL, SZVLUM, SZGLC, SZCTRY, SZFY, SZSTTS, SZRCD, SZGRWT, SZGWUM, SZLCOD, SZCRMD, SZCRCD, SZCRR, SZFPRC, SZFUP, SZFEA, SZFUC, SZFEC, SZHLCF, SZHLSC, SZPKCD, SZWGQ, SZWGTS, SZWGTU, SZIDQ1, SZID1, SZIDQ2, SZID2, SZROTE, SZEQCD, SZEQIN, SZEQNB, SZRFQ1, SZRF1, SZRFQ2, SZRF2, SZPLT, SZPAK, SZSCCN, SZSCCQ, SZSCUM, SZUPCN, SZUPQT, SZUPUM, SZLINS, SZSTPC, SZANTY, SZTXLN, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZPDTT, SZOPTT, SZADTM, SZPMDT, SZPSTM, SZBSC, SZCBSC, SZDEID, SZDUAL, SZDVAN, SZHOLD, SZPMTN, SZPMTO, SZPRJM, SZPSIG, SZRFRV, SZRLDJ, SZRLNU, SZRLTM, SZSOOR, SZCARDNO, SZRTORSQ, SZRTGDAT, SZRTGTIM, SZNCOOC, SZIPPTG, SZIPPRC, SZKBSNO, SZKBENO, SZGAN8, SZGSHAN, SZGPA8, SZGDVAN, SZGCARS, SZORIG FROM F470371

TOP920 | 47 | F470371 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2SZEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3SZEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
4SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 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
47SZRQSJDate - Requested ShipDateGeneric Edit60
48SZADLJDate - Actual DeliveryDateGeneric Edit60
49SZDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
50SZRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
51SZRSHTRequested Ship TimeNumericGeneric Edit60 Allow NULL? 
52SZVR01ReferenceStringGeneric Edit250 Allow NULL? 
53SZVR02Reference 2StringGeneric Edit250 Allow NULL? 
54SZVR03ReferenceStringGeneric Edit250 Allow NULL? 
55SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
56SZLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
57SZAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
58SZCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
59SZLOCNLocationStringGeneric Edit200 Allow NULL? 
60SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
61SZFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
62SZTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
63SZACGDActual GradeStringUDC (40 LG)30 Allow NULL? 
64SZFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
65SZAPOTActual PotencyNumericGeneric Edit73 Allow NULL? 
66SZTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
67SZEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
68SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
69SZDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
70SZLNTYLine TypeStringGeneric Edit20 Allow NULL? 
71SZNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
72SZLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
73SZEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
74SZHDBUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
75SZSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
76SZRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
77SZKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
78SZCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
79SZRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
80SZKTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
81SZSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
82SZDMBUBusiness Unit - DemandStringGeneric Edit120 Allow NULL? 
83SZSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
84SZSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
85SZSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
86SZPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
87SZPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
88SZUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
89SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
90SZSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
91SZSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
92SZSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
93SZSONEUnits - Future Quantity CommittedNumericGeneric Edit150 Allow NULL? 
94SZUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
95SZQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
96SZQRLVUnits - RelievedNumericGeneric Edit150 Allow NULL? 
97SZCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
98SZOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
99SZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
100SZUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
101SZAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
102SZAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
103SZAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
104SZLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
105SZUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
106SZECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
107SZCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
108SZTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
109SZINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
110SZPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
111SZDCDDiscount DaysNumericGeneric Edit30 Allow NULL? 
112SZDCPDiscount % - Payment TermsNumericGeneric Edit50 Allow NULL? 
113SZNDTPNet Days to PayNumericGeneric Edit30 Allow NULL? 
114SZPXDDDate - Due Date - DANumericGeneric Edit20 Allow NULL? 
115SZPXDMDate - Due Date - MONumericGeneric Edit20 Allow NULL? 
116SZRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
117SZDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
118SZTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
119SZDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
120SZDSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
121SZCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
122SZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
123SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
124SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
125SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
126SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
127SZOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
128SZPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
129SZDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
130SZATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
131SZPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
132SZAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
133SZLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
134SZEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
135SZDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
136SZNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
137SZCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
138SZMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
139SZCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
140SZROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
141SZSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
142SZZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
143SZCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
144SZFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
145SZAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
146SZFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
147SZFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
148SZFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
149SZRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
150SZSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
151SZSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
152SZSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
153SZSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
154SZLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
155SZTKNRTicket NumberStringGeneric Edit200 Allow NULL? 
156SZTKTMTime - TicketNumericGeneric Edit60 Allow NULL? 
157SZTKDADate - TicketDateGeneric Edit60
158SZUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
159SZPQORUnits - Primary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
160SZUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
161SZSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
162SZUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
163SZITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
164SZWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
165SZITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
166SZVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
167SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
168SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
169SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
170SZSTTSLine StatusStringGeneric Edit20 Allow NULL? 
171SZRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
172SZGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
173SZGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
174SZLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
175SZCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
176SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
177SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
178SZFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
179SZFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
180SZFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
181SZFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
182SZFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
183SZHLCFHierarchical ConfigurationStringGeneric Edit180 Allow NULL? 
184SZHLSCHierarchical Structure CodeStringGeneric Edit40 Allow NULL? 
185SZPKCDPackaging CodeStringUDC (41 X1)50 Allow NULL? 
186SZWGQWeight QualifierStringUDC (41 X2)20 Allow NULL? 
187SZWGTSShipment WeightNumericGeneric Edit154 Allow NULL? 
188SZWGTUWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
189SZIDQ1Identifier Code Qualifier 1StringUDC (41 X3)20 Allow NULL? 
190SZID1Identifier Code 1StringGeneric Edit170 Allow NULL? 
191SZIDQ2Identifier Code Qualifier 2StringUDC (41 X3)20 Allow NULL? 
192SZID2Identifier Code 2StringGeneric Edit170 Allow NULL? 
193SZROTERoutingStringGeneric Edit350 Allow NULL? 
194SZEQCDEquipment Description CodeStringUDC (41 X5)20 Allow NULL? 
195SZEQINEquipment InitialStringGeneric Edit40 Allow NULL? 
196SZEQNBEquipment NumberStringGeneric Edit100 Allow NULL? 
197SZRFQ1Reference Number Qualifier 1StringUDC (41 X6)20 Allow NULL? 
198SZRF1Reference Number 1StringGeneric Edit300 Allow NULL? 
199SZRFQ2Reference Number Qualifier 2StringUDC (41 X6)20 Allow NULL? 
200SZRF2Reference Number 2StringGeneric Edit300 Allow NULL? 
201SZPLTSSCC Number - Tare LevelStringGeneric Edit180 Allow NULL? 
202SZPAKSSCC Number - Pack LevelStringGeneric Edit180 Allow NULL? 
203SZSCCNSCC NumberStringGeneric Edit140 Allow NULL? 
204SZSCCQSCC QuantityNumericGeneric Edit150 Allow NULL? 
205SZSCUMSCC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
206SZUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
207SZUPQTUPC QuantityNumericGeneric Edit150 Allow NULL? 
208SZUPUMUPC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
209SZLINSWork Order - Line NumberNumericGeneric Edit92 Allow NULL? 
210SZSTPCType CodeCharacterGeneric Edit10 Allow NULL? 
211SZANTYType - Address NumberCharacterUDC (40 AN)10 Allow NULL? 
212SZTXLNMessage Text LineStringGeneric Edit600 Allow NULL? 
213SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
214SZURDTUser Reserved DateDateGeneric Edit60
215SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
216SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
217SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
218SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
219SZUSERUser IDStringGeneric Edit100 Allow NULL? 
220SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
221SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
222SZUPMJDate - UpdatedDateGeneric Edit60
223SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
224SZPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
225SZOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
226SZADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
227SZPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
228SZPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
229SZBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
230SZCBSCCurrent Buying Segment CodeStringUDC (42B BS)100 Allow NULL? 
231SZDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
232SZDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
233SZDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
234SZHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
235SZPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
236SZPMTOPayment Terms Override CodeCharacterGeneric Edit10 Allow NULL? 
237SZPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
238SZPSIGPull SignalStringGeneric Edit300 Allow NULL? 
239SZRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
240SZRLDJDate - ReleaseDateGeneric Edit60
241SZRLNURelease NumberStringGeneric Edit100 Allow NULL? 
242SZRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
243SZSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
244SZCARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
245SZRTORSQRouting Order Sequence NumberStringGeneric Edit300 Allow NULL? 
246SZRTGDATRouting DateDateGeneric Edit60
247SZRTGTIMRouting TimeNumericGeneric Edit60 Allow NULL? 
248SZNCOOCBranch Country Of Origin CodeStringUDC (40R CO)30 Allow NULL? 
249SZIPPTGIPP TagStringGeneric Edit20 Allow NULL? 
250SZIPPRCIPP Reason CodeStringGeneric Edit100 Allow NULL? 
251SZKBSNOKanban Start NumberStringGeneric Edit150 Allow NULL? 
252SZKBENOKanban End NumberStringGeneric Edit150 Allow NULL? 
253SZGAN8Global Location NumberNumericGeneric Edit130 Allow NULL? 
254SZGSHANShip To GLNNumericGeneric Edit130 Allow NULL? 
255SZGPA8Parent Address GLNNumericGeneric Edit130 Allow NULL? 
256SZGDVANDeliver To Address GLNNumericGeneric Edit130 Allow NULL? 
257SZGCARSCarrier Number GLNNumericGeneric Edit130 Allow NULL? 
258SZORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 

TOP920 | 47 | F470371 INDEXES

NumberDescription
1Primary DocN DocT CO LN etc (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberAscending
5STPCType CodeAscending
6ANTYType - Address NumberAscending
7LINSWork Order - Line NumberAscending
2EDOC EDCT EKCO EDLN
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberAscending
3ShipmentNumber
ElementAliasDescriptionSequence
1SHPNShipment NumberAscending
4EDOC EDCT EKCO EDLN DESC
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberDescending