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