Table Out
Purpose
This table contains the outgoing parcels. The contents of each parcel is described in OutDetails.
Field definitions in table Out
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | AVIZ | VARCHAR(50) | Y | Order number |
| 2 | Y | DATA | TIMESTAMP | N | Date when the record is created |
| 3 | Y | CLIENT | VARCHAR(50) | N | Supplier |
| 4 | Y | BLOCKNO | INT | N | Unique order ID in Warta |
| 5 | Y | FILENAME | VARCHAR(200) | N | Comments ? |
| 6 | Y | PCNAME | VARCHAR(50) | N | User that created the record |
| 7 | Y | FILLDATE | VARCHAR(20) | N | Date the record is filled (default same as DATA) |
| 8 | Y | IDCLIENT | NUMERIC(0,18) | N | Default 8 |
| 9 | N | OP1 | VARCHAR(30) | N | |
| 10 | N | OP2 | VARCHAR(30) | N | |
| 11 | Y | Country | VARCHAR(20) | N | Country for shipping |
| 12 | Y | OrderType | VARCHAR(50) | N | Order ID from client ? |
| 13 | Y | SystemDate | TIMESTAMP | N | Creation date |
| 14 | Y | IDDClient | VARCHAR(50) | N | Delivery client ID |
| 15 | Y | DClient | VARCHAR(50) | N | Delivery client Name |
| 16 | Y | DClientTown | VARCHAR(50) | N | Delivery client town |
| 17 | Y | DClientTownCode | VARCHAR(50) | N | Delivery client ZIP |
| 18 | Y | DClientAddress | VARCHAR(200) | N | Delivery client Address |
| 19 | Y | DClientCountry | VARCHAR(50) | N | Delivery client Country |
| 20 | Y | DClientProvince | VARCHAR(50) | N | Delivery client Province |
| 21 | Y | DClientPhone | VARCHAR(50) | N | Delivery client Phone |
| 22 | Y | DClientEmail | VARCHAR(100) | N | Delivery client Email |
| 23 | Y | IDIClient | VARCHAR(50) | N | Invoice client ID. |
| 24 | Y | IClient | VARCHAR(50) | N | Invoice client name |
| 25 | Y | IClientTown | VARCHAR(50) | N | Invoice client town |
| 26 | Y | IClientTownCode | VARCHAR(50) | N | Invoice client zip |
| 27 | Y | IClientAddress | VARCHAR(200) | N | Invoice client Address |
| 28 | Y | IClientCountry | VARCHAR(50) | N | Invoice client country |
| 29 | Y | IClientProvince | VARCHAR(50) | N | Invoice client Province |
| 30 | Y | IClientPhone | VARCHAR(50) | N | Invoice client phone |
| 31 | Y | IClientEmail | VARCHAR(100) | N | Invoice client email |
| 32 | Y | ClientReference | VARCHAR(50) | N | Invoice client reference |
| 33 | Y | CFGenFileDate | TIMESTAMP | N | Confirmation file generated on |
| 34 | Y | CFGen | VARCHAR(1) | N | Need confirmation file |
| 35 | Y | CFGen1 | VARCHAR(1) | N | Need confirmation file 1 |
| 36 | Y | CFGen2 | VARCHAR(1) | N | Need confirmation file 2 |
| 37 | Y | CFGenFile | VARCHAR(200) | N | Filename for confirmation |
| 38 | N | OriginalImpRow1 | VARCHAR(750) | N | Originally imported row 1 |
| 39 | N | OriginalImpRow2 | VARCHAR(750) | N | Originally imported row 2 |
| 40 | Y | TrackingNumber | VARCHAR(100) | N | Tracking number |
| 41 | Y | TrackingNumber2 | VARCHAR(100) | N | Tracking number 2 |
| 42 | Y | FirstArticle | VARCHAR(100) | N | First article description |
| 43 | Y | ArticleCount | NUMERIC(0,18) | N | Number of articles |
| 44 | Y | TLocation | VARCHAR(50) | N | Location |
| 45 | Y | CarrierDepo1 | VARCHAR(50) | N | Carrier depo 1. |
| 46 | Y | CarrierDepo2 | VARCHAR(50) | N | Carrier depo 2. |
| 47 | Y | CarrierDepo3 | VARCHAR(50) | N | Carrier depo 3. |
| 48 | Y | CarrierTrackingNo1 | VARCHAR(50) | N | Carrier tracking number 1 |
| 49 | Y | CarrierTrackingNo2 | VARCHAR(50) | N | Carrier tracking number 2 |
| 50 | Y | CarrierRoutingDate | TIMESTAMP | N | Carrier routing date |
| 51 | Y | Carrier | VARCHAR(50) | N | Carrier |
| 52 | Y | EdiDate | TIMESTAMP | N | EDI/Label generation date. |
| 53 | Y | ShippingMethod | VARCHAR(100) | N | Shipping method |
| 54 | Y | PLPrintingDate | TIMESTAMP | N | Pack list printing date. |
| 55 | Y | PickingJobID | NUMERIC(0,18) | N | Pick job ID |