Ga naar inhoud

Table NRW_Out

Purpose

Field definitions in table NRW_Out

No. Used Name Type Reqd. Description
1 SalesOrderNo VARCHAR(50) N
2 OrderLineNo VARCHAR(50) N
3 ItemCode VARCHAR(50) N
4 Description VARCHAR(200) N
5 MfgBatchNo VARCHAR(50) N
6 SRN VARCHAR(50) N
7 StockFeature VARCHAR(50) N
8 Owner VARCHAR(50) N
9 OrderedQuantity VARCHAR(50) N
10 Quantitytodeliver VARCHAR(50) N
11 SerialNumber VARCHAR(50) N
12 ShiptoCode VARCHAR(50) N
13 Shiptoname VARCHAR(50) N
14 Address1 VARCHAR(50) N
15 Address2 VARCHAR(50) N
16 Street VARCHAR(50) N
17 AddtlAddress VARCHAR(50) N
18 ZipCode VARCHAR(50) N
19 City VARCHAR(50) N
20 CountryCode VARCHAR(50) N
21 SalesOrderreference VARCHAR(50) N
22 OrderDate VARCHAR(50) N
23 DeliveryDate VARCHAR(50) N
24 Datemandatory VARCHAR(50) N
25 Deliverytype VARCHAR(50) N
26 Principal VARCHAR(50) N
27 Carrier VARCHAR(50) N
28 OutputType VARCHAR(50) N
29 ShipmentMethod VARCHAR(50) N
30 Pickinstruction VARCHAR(255) N
31 Deliveryinstruction VARCHAR(255) N
32 Contact VARCHAR(50) N
33 Contact1 VARCHAR(50) N
34 Phone VARCHAR(50) N
35 Size VARCHAR(50) N
36 Languagecode VARCHAR(50) N
37 Customeritemcode VARCHAR(50) N
38 CustomerItemdescription VARCHAR(50) N
39 Unitprice VARCHAR(50) N
40 SpecificField1 VARCHAR(50) N
41 SpecificField2 VARCHAR(50) N
42 SpecificField3 VARCHAR(50) N
43 Cashondelivery VARCHAR(50) N
44 Priceforcashondelivery VARCHAR(50) N
45 ShipmentNumber VARCHAR(100) N
46 RSystemDate TIMESTAMP N
47 BlockNo NUMERIC(0,18) N
48 Processed VARCHAR(1) N
49 FileName VARCHAR(100) N
50 ServiceCode VARCHAR(50) N
51 Add_Address1 VARCHAR(200) N
52 Add_AddtlAddress VARCHAR(200) N
53 Add_ZipCode VARCHAR(50) N
54 Add_City VARCHAR(50) N
55 Add_CountryCode VARCHAR(50) N
56 IC_flag VARCHAR(50) N

Indexes