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

251 COLUMNS | 1 INDEXES | Print definition?910 | 40 | F4011Z TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4011ZSZ2511Batch Receiver File - Order DetailsBatch Input Files42B: Sales Order EntryBusiness 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, SZPNID, SZKCOO, SZDOCO, SZDCTO, SZLNID, SZSFXO, SZMCU, SZCO, SZOKCO, SZOORN, SZOCTO, SZOGNO, SZRKCO, SZRORN, SZRCTO, SZRLLN, SZDMCT, SZDMCS, SZBALU, SZAN8, SZSHAN, SZPA8, SZDRQJ, SZTRDJ, SZPDDJ, SZOPDJ, SZADDJ, SZIVD, SZCNDJ, SZDGL, SZRSDJ, SZPEFJ, SZPPDJ, SZPSDJ, SZVR01, SZVR02, SZITM, SZLITM, SZAITM, 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, SZPRP3, SZPRP4, SZPRP5, SZUOM, SZUORG, SZSOQS, SZSOBK, SZSOCN, SZSONE, SZUOPN, SZQTYT, SZQRLV, SZCOMM, SZOTQY, SZUPRC, SZAEXP, SZAOPN, SZPROV, SZTPC, SZAPUM, SZLPRC, SZUNCS, SZECST, SZCSTO, SZTCST, SZINMG, SZPTC, SZRYIN, SZDTBS, SZTRDC, SZFUN2, SZASN, SZPRGR, SZCLVL, SZDSPR, SZDSFT, SZFAPP, SZCADC, SZKCO, SZDOC, SZDCT, SZODOC, SZODCT, SZOKC, SZPSN, SZDELN, SZTAX1, SZTXA1, SZEXR1, SZATXT, SZPRIO, SZRESL, SZBACK, SZSBAL, SZAPTS, SZLOB, SZEUSE, SZDTYS, SZNTR, SZVEND, SZANBY, 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, SZORPR, SZORP, SZCMGP, SZCMGL, SZGLC, SZCTRY, SZFY, SZSTTS, SZSO01, SZSO02, SZSO03, SZSO04, SZSO05, SZSO06, SZSO07, SZSO08, SZSO09, SZSO10, SZSO11, SZSO12, SZSO13, SZSO14, SZSO15, SZACOM, SZCMCG, SZRCD, SZGRWT, SZGWUM, SZANI, SZAID, SZOMCU, SZOBJ, SZSUB, SZLT, SZSBL, SZSBLT, SZLCOD, SZUPC1, SZUPC2, SZUPC3, SZSWMS, SZUNCD, SZCRMD, SZCRCD, SZCRR, SZFPRC, SZFUP, SZFEA, SZFUC, SZFEC, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZIR01, SZIR02, SZIR03, SZIR04, SZIR05, SZSOOR, SZDEID, SZPSIG, SZRLNU, SZPMDT, SZRLTM, SZRLDJ, SZDRQT, SZADTM, SZOPTT, SZPDTT, SZPSTM, SZPMTN, SZBSC, SZCBSC, SZDVAN, SZRFRV, SZSHPN, SZPRJM, SZHOLD, SZPMTO, SZDUAL FROM F4011Z

TOP910 | 40 | F4011Z 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? 
13SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
14SZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
15SZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
16SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
17SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
18SZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
19SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
20SZCOCompanyStringGeneric Edit50 Allow NULL? 
21SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
22SZOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
23SZOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
24SZOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
25SZRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
26SZRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
27SZRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
28SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
29SZDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
30SZDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
31SZBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
32SZAN8Address NumberNumericUDC80 Allow NULL? 
33SZSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
34SZPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
35SZDRQJDate - RequestedDateGeneric Edit60
36SZTRDJDate - Order/TransactionDateGeneric Edit60
37SZPDDJDate - Scheduled PickDateGeneric Edit60
38SZOPDJDate - Original Promised DeliveryDateGeneric Edit60
39SZADDJDate - Actual Ship DateDateGeneric Edit60
40SZIVDDate - InvoiceDateGeneric Edit60
41SZCNDJDate - CancelDateGeneric Edit60
42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
43SZRSDJDate - Promised DeliveryDateGeneric Edit60
44SZPEFJDate - Price Effective DateDateGeneric Edit60
45SZPPDJDate - Promised ShipmentDateGeneric Edit60
46SZPSDJDate - Future Date 2DateGeneric 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? 
52SZLOCNLocationStringGeneric Edit200 Allow NULL? 
53SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
54SZFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
55SZTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
56SZFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
57SZTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
58SZEXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
59SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
60SZDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
61SZLNTYLine TypeStringGeneric Edit20 Allow NULL? 
62SZNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
63SZLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
64SZEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
65SZRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
66SZKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
67SZCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
68SZRKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
69SZKTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
70SZSRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
71SZSRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
72SZSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
73SZSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
74SZSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
75SZPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
76SZPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
77SZPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
78SZPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
79SZPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
80SZUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
82SZSOQSQuantity ShippedNumericGeneric Edit152 Allow NULL? 
83SZSOBKUnits - Qty Backordered/HeldNumericGeneric Edit152 Allow NULL? 
84SZSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
85SZSONEUnits - Future Quantity CommittedNumericGeneric Edit152 Allow NULL? 
86SZUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
87SZQTYTUnits - Shipped to DateNumericGeneric Edit152 Allow NULL? 
88SZQRLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
89SZCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
90SZOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
91SZUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
92SZAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
93SZAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
94SZPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
95SZTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
96SZAPUMUnit of Measure - Entered for Unit PriceStringUDC (00 UM)20 Allow NULL? 
97SZLPRCAmount - List PriceNumericGeneric Edit154 Allow NULL? 
98SZUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
99SZECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
100SZCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
101SZTCSTExtended Cost - TransferNumericGeneric Edit154 Allow NULL? 
102SZINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
103SZPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
104SZRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
105SZDTBSBased on DateCharacterUDC (42 BD)10 Allow NULL? 
106SZTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
107SZFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
108SZASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
109SZPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
110SZCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
111SZDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
112SZDSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
113SZFAPPDiscount Application TypeCharacterGeneric Edit10 Allow NULL? 
114SZCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
115SZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
116SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
117SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
118SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
119SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
120SZOKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
121SZPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
122SZDELNDelivery NumberNumericGeneric Edit80 Allow NULL? 
123SZTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
124SZTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
125SZEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
126SZATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
127SZPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
128SZRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
129SZBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
130SZSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
131SZAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
132SZLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
133SZEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
134SZDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
135SZNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
136SZVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
137SZANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
138SZCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
139SZMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
140SZCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
141SZROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
142SZSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
143SZZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
144SZCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
145SZFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
146SZAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
147SZFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
148SZFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
149SZFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
150SZRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
151SZSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
152SZSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
153SZSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
154SZUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
155SZPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
156SZUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
157SZSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
158SZUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
159SZITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
160SZWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
161SZITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
162SZVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
163SZRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
164SZORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
165SZORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
166SZCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
167SZCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
168SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
169SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
170SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
171SZSTTSLine StatusStringGeneric Edit20 Allow NULL? 
172SZSO01Inter Branch SalesCharacterGeneric Edit10 Allow NULL? 
173SZSO02On Hand UpdatedCharacterGeneric Edit10 Allow NULL? 
174SZSO03Configurator Print FlagCharacterGeneric Edit10 Allow NULL? 
175SZSO04Sales Order Status 04CharacterGeneric Edit10 Allow NULL? 
176SZSO05Substitute Item IndicatorCharacterGeneric Edit10 Allow NULL? 
177SZSO06Preference Commitment IndicatorCharacterGeneric Edit10 Allow NULL? 
178SZSO07Ship date (PDDJ) overriddenCharacterGeneric Edit10 Allow NULL? 
179SZSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
180SZSO09Price Adj. History IndicatorCharacterGeneric Edit10 Allow NULL? 
181SZSO10Preference Production AllocationCharacterGeneric Edit10 Allow NULL? 
182SZSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
183SZSO12Deferred entries flagCharacterGeneric Edit10 Allow NULL? 
184SZSO13Euro Conversion Status FlagCharacterGeneric Edit10 Allow NULL? 
185SZSO14Sales Order Status 14CharacterGeneric Edit10 Allow NULL? 
186SZSO15Sales Order Status 15CharacterGeneric Edit10 Allow NULL? 
187SZACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
188SZCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
189SZRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
190SZGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
191SZGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
192SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
193SZAIDAccount IDStringGeneric Edit80 Allow NULL? 
194SZOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
195SZOBJObject AccountStringGeneric Edit60 Allow NULL? 
196SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
197SZLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
198SZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
199SZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
200SZLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
201SZUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
202SZUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
203SZUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
204SZSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
205SZUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
206SZCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
207SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
208SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
209SZFPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
210SZFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
211SZFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
212SZFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
213SZFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
214SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
215SZURDTUser Reserved DateDateGeneric Edit60
216SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
217SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
218SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
219SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
220SZUSERUser IDStringGeneric Edit100 Allow NULL? 
221SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
222SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
223SZUPMJDate - UpdatedDateGeneric Edit60
224SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
225SZIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
226SZIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
227SZIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
228SZIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
229SZIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
230SZSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
231SZDEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
232SZPSIGPull SignalStringGeneric Edit300 Allow NULL? 
233SZRLNURelease NumberStringGeneric Edit100 Allow NULL? 
234SZPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
235SZRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
236SZRLDJDate - ReleaseDateGeneric Edit60
237SZDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
238SZADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
239SZOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
240SZPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
241SZPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
242SZPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
243SZBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
244SZCBSCCurrent Buying Segment CodeStringUDC (42B BS)100 Allow NULL? 
245SZDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
246SZRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
247SZSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
248SZPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
249SZHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
250SZPMTOPayment Terms Override CodeCharacterGeneric Edit10 Allow NULL? 
251SZDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 

TOP910 | 40 | F4011Z INDEXES

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