Table NRW_Inv_Temp
Purpose
Import van Norwex Purchase orders. Wordt niet in warta gebruikt.
Field definitions in table NRW_Inv_Temp
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | SalesOrderNo | VARCHAR(50) | N | ||
| 2 | OrderLineNo | VARCHAR(50) | N | ||
| 3 | ItemCode | VARCHAR(50) | N | ||
| 4 | Description | VARCHAR(50) | N | ||
| 5 | ReservationNo | VARCHAR(50) | N | ||
| 6 | StockFeature | VARCHAR(50) | N | ||
| 7 | Owner | VARCHAR(50) | N | ||
| 8 | OrderedQuantity | VARCHAR(50) | N | ||
| 9 | SupplierCode | VARCHAR(50) | N | ||
| 10 | SupplierName | VARCHAR(50) | N | ||
| 11 | OrderDate | VARCHAR(50) | N | ||
| 12 | DeliveryDate | VARCHAR(50) | N | ||
| 13 | OrderType | VARCHAR(50) | N | ||
| 14 | Principal | VARCHAR(50) | N | ||
| 15 | PurchaseUnit | VARCHAR(50) | N | ||
| 16 | MfgBatchNo | VARCHAR(50) | N | ||
| 17 | UnitPrice | VARCHAR(50) | N | ||
| 18 | CurrencyCode | VARCHAR(50) | N | ||
| 19 | CreateAppointment | VARCHAR(50) | N | ||
| 20 | Appointmentnumber | VARCHAR(50) | N | ||
| 21 | AppointmentReference | VARCHAR(50) | N | ||
| 22 | SupplierDeliveryNumber | VARCHAR(50) | N | ||
| 23 | Docknumber | VARCHAR(50) | N | ||
| 24 | LoadingType | VARCHAR(50) | N | ||
| 25 | AppointmentDate | VARCHAR(50) | N | ||
| 26 | AppointmentFromtime | VARCHAR(50) | N | ||
| 27 | AppointmentToTime | VARCHAR(50) | N | ||
| 28 | Countryoforigin | VARCHAR(50) | N | ||
| 29 | Size | VARCHAR(50) | N | ||
| 30 | CustomerItemcode | VARCHAR(50) | N | ||
| 31 | CustomerItemdescription | VARCHAR(50) | N | ||
| 32 | RSystemDate | TIMESTAMP | N | ||
| 33 | Processed | VARCHAR(1) | N | ||
| 34 | FileName | VARCHAR(100) | N | ||
| 35 | PackingUnitName | VARCHAR(50) | N | ||
| 36 | UnitsPerPackingUnit | NUMERIC(0,18) | N |