Ga naar inhoud

Table RETURDETII

Purpose

Field definitions in table RETURDETII

No. Used Name Type Reqd. Description
1 MessageID VARCHAR(50) N
2 FileName VARCHAR(100) N
3 ImportDate TIMESTAMP N
4 OrderHeaderKey VARCHAR(50) N
5 OrderNo VARCHAR(50) N
6 PrimeLineNo VARCHAR(50) N
7 OrderedQty VARCHAR(50) N
8 OrderReleaseKey VARCHAR(50) N
9 ExtnCustId VARCHAR(50) N
10 ItemID VARCHAR(50) N
11 AddressLine1 VARCHAR(100) N
12 AddressLine2 VARCHAR(100) N
13 AddressLine3 VARCHAR(100) N
14 City VARCHAR(50) N
15 Country VARCHAR(50) N
16 DayPhone VARCHAR(50) N
17 EMailID VARCHAR(50) N
18 FirstName VARCHAR(50) N
19 LastName VARCHAR(50) N
20 MiddleName VARCHAR(50) N
21 State VARCHAR(50) N
22 ZipCode VARCHAR(50) N
23 ConfirmedQTY INT N
24 ConfirmationDate TIMESTAMP N
25 ID NUMERIC(0,18) N

Indexes