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

222 COLUMNS | 2 INDEXES | Print definition?910 | 47 | F47157 TABLE

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F47157SZ2222EDI Shipping Schedule Detail - OutboundTransaction Files31: Shop Floor ControlBusiness 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, SZKCOO, SZDOCO, SZDCTO, SZSFXO, SZLNID, SZMCU, SZCO, SZOKCO, SZOORN, SZOCTO, SZOGNO, SZRKCO, SZRORN, SZRCTO, SZRLLN, SZDMCT, SZDMCS, SZBALU, SZAN8, SZSHAN, SZMKFR, SZDRQJ, SZTRDJ, SZPDDJ, SZOPDJ, SZADDJ, SZCNDJ, SZPEFJ, SZPPDJ, SZPSDJ, SZDSVJ, SZDGL, SZPN, SZVR01, SZVR02, SZVR03, SZITM, SZLITM, SZAITM, SZCITM, SZLOCN, SZLOTN, SZFRGD, SZTHGD, SZFRMP, SZTHRP, SZDSC1, SZDSC2, SZMERL, SZLNTY, SZNXTR, SZLTTR, SZRLIT, SZKTLN, SZCPNT, SZPDS1, SZPDS2, SZPDS3, SZPDS4, SZPDS5, SZPDP1, SZPDP2, SZPDP3, SZPDP4, SZPDP5, SZUOM, SZUORG, SZUCHG, SZUOPN, SZUREC, SZCREC, SZURLV, SZOTQY, SZBCRC, SZPRRC, SZAEXP, SZACHG, SZAOPN, SZAREC, SZARLV, SZFTN1, SZTRLV, SZPROV, SZAMC3, SZECST, SZCSTO, SZCSMP, SZINMG, SZASN, SZPRGR, SZCLVL, SZCATN, SZDSPR, SZPTC, SZTX, SZEXR1, SZTXA1, SZATXT, SZCNID, SZCDCD, SZNTR, SZFRTH, SZFRTC, SZZON, SZFRAT, SZRATT, SZANBY, SZANCR, SZMOT, SZCOT, SZSHCM, SZSHCN, SZLDNM, SZSHMT, SZUOM1, SZPQOR, SZUOM2, SZSQOR, SZUOM3, SZITWT, SZWTUM, SZITVL, SZVLUM, SZGLC, SZCTRY, SZFY, SZSTTS, SZRCD, SZFUF1, SZFUF2, SZGRWT, SZGWUM, SZLT, SZANI, SZAID, SZOMCU, SZOBJ, SZSUB, SZSBLT, SZSBL, SZASID, SZCCMP, SZTAG, SZWR01, SZPL, SZELEV, SZR001, SZRTNR, SZLCOD, SZPURG, SZPROM, SZFNLP, SZAVCH, SZPRPY, SZUNCD, SZMATY, SZRTGC, SZRCPF, SZPS01, SZPS02, SZPS03, SZPS04, SZPS05, SZPS06, SZPS07, SZPS08, SZPS09, SZPS10, SZCRMD, SZARTG, SZCORD, SZCHDT, SZDOCC, SZCHLN, SZCHID, SZCHMJ, SZCHT, SZCRCD, SZCRR, SZFRRC, SZFEA, SZFUC, SZFEC, SZFCHG, SZFAP, SZFREC, SZCTAM, SZFTRL, SZMACT, SZUPRC, SZPUOM, SZRLQT, SZSTRT, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZGAN8, SZGSHAN, SZGCARS, SZGMKFR FROM F47157

TOP910 | 47 | F47157 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? 
15SZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
16SZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
17SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
18SZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
19SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
20SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
21SZCOCompanyStringGeneric Edit50 Allow NULL? 
22SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
23SZOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
24SZOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
25SZOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
26SZRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
27SZRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
28SZRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
30SZDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
31SZDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
32SZBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
33SZAN8Address NumberNumericUDC80 Allow NULL? 
34SZSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
35SZMKFRAddress Number - Mark-forNumericGeneric Edit80 Allow NULL? 
36SZDRQJDate - RequestedDateGeneric Edit60
37SZTRDJDate - Order/TransactionDateGeneric Edit60
38SZPDDJDate - Scheduled PickDateGeneric Edit60
39SZOPDJDate - Original Promised DeliveryDateGeneric Edit60
40SZADDJDate - Actual Ship DateDateGeneric Edit60
41SZCNDJDate - CancelDateGeneric Edit60
42SZPEFJDate - Price Effective DateDateGeneric Edit60
43SZPPDJDate - Promised ShipmentDateGeneric Edit60
44SZPSDJDate - Future Date 2DateGeneric Edit60
45SZDSVJDate - Service/TaxDateGeneric Edit60
46SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
47SZPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
48SZVR01ReferenceStringGeneric Edit250 Allow NULL? 
49SZVR02Reference 2StringGeneric Edit250 Allow NULL? 
50SZVR03ReferenceStringGeneric Edit250 Allow NULL? 
51SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
52SZLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
53SZAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
54SZCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
55SZLOCNLocationStringGeneric Edit200 Allow NULL? 
56SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
57SZFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
58SZTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
59SZFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
60SZTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
61SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
62SZDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
63SZMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
64SZLNTYLine TypeStringGeneric Edit20 Allow NULL? 
65SZNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
66SZLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
67SZRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
68SZKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
69SZCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
70SZPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
71SZPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
72SZPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
73SZPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
74SZPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
75SZPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
76SZPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
77SZPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
78SZPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
79SZPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
80SZUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
82SZUCHGUnits - On HoldNumericGeneric Edit152 Allow NULL? 
83SZUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
84SZURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
85SZCRECUnits - Cumulative ReceivedNumericGeneric Edit152 Allow NULL? 
86SZURLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
87SZOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
88SZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
89SZPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
90SZAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
91SZACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
92SZAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
93SZARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
94SZARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
95SZFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
96SZTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
97SZPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
98SZAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
99SZECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
100SZCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
101SZCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
102SZINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
103SZASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
104SZPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
105SZCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
106SZCATNCatalogStringUDC (40 CN)80 Allow NULL? 
107SZDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
108SZPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
109SZTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
110SZEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
111SZTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
112SZATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
113SZCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
114SZCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
115SZNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
116SZFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
117SZFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
118SZZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
119SZFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
120SZRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
121SZANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
122SZANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
123SZMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
124SZCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
125SZSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
126SZSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
127SZLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
128SZSHMTShipment number (ITLS)StringGeneric Edit150 Allow NULL? 
129SZUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
130SZPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
131SZUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
132SZSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
133SZUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
134SZITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
135SZWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
136SZITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
137SZVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
138SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
139SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
140SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
141SZSTTSLine StatusStringGeneric Edit20 Allow NULL? 
142SZRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
143SZFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
144SZFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
145SZGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
146SZGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
147SZLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
148SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
149SZAIDAccount IDStringGeneric Edit80 Allow NULL? 
150SZOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
151SZOBJObject AccountStringGeneric Edit60 Allow NULL? 
152SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
153SZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
154SZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
155SZASIDSerial NumberStringGeneric Edit250 Allow NULL? 
156SZCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
157SZTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
158SZWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
159SZPLPlan NumberStringGeneric Edit40 Allow NULL? 
160SZELEVElevationStringGeneric Edit30 Allow NULL? 
161SZR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
162SZRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
163SZLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
164SZPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
165SZPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
166SZFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
167SZAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
168SZPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
169SZUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
170SZMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
171SZRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
172SZRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
173SZPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
174SZPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
175SZPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
176SZPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
177SZPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
178SZPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
179SZPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
180SZPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
181SZPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
182SZPS10Purchase Order Status 10CharacterUDC (00 XS)10 Allow NULL? 
183SZCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
184SZARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
185SZCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
186SZCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
187SZDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
188SZCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
189SZCHIDChange Order Program IDStringGeneric Edit100 Allow NULL? 
190SZCHMJChange Order Date - UpdatedDateGeneric Edit60
191SZCHTChange Order Time of DayNumericGeneric Edit70 Allow NULL? 
192SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
193SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
194SZFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
195SZFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
196SZFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
197SZFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
198SZFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
199SZFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
200SZFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
201SZCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
202SZFTRLAmount - Foreign Tax RelievedNumericGeneric Edit152 Allow NULL? 
203SZMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
204SZUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
205SZPUOMUnit of Measure - PriceStringUDC (00 UM)20 Allow NULL? 
206SZRLQTQuantity - ReleasedNumericGeneric Edit152 Allow NULL? 
207SZSTRTDate - Start (Julian)DateGeneric Edit60
208SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
209SZURDTUser Reserved DateDateGeneric Edit60
210SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
211SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
212SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
213SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
214SZUSERUser IDStringGeneric Edit100 Allow NULL? 
215SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
216SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
217SZUPMJDate - UpdatedDateGeneric Edit60
218SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
219SZGAN8Global Location NumberNumericGeneric Edit130 Allow NULL? 
220SZGSHANShip To GLNNumericGeneric Edit130 Allow NULL? 
221SZGCARSCarrier Number GLNNumericGeneric Edit130 Allow NULL? 
222SZGMKFRMark For Address GLNNumericGeneric Edit130 Allow NULL? 

TOP910 | 47 | F47157 INDEXES

NumberDescription
1EDIOrder No EDIOrder Type + (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending
4EDLNEDI - Line NumberAscending
2Order Number Order Type +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending