Table OUTDETAILSII
Purpose
Seemingly not used in code.
Field definitions in table OUTDETAILSII
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | MessageID | VARCHAR(50) | N | ||
| 2 | FileName | VARCHAR(100) | N | ||
| 3 | ImportDate | TIMESTAMP | N | ||
| 4 | CarrierServiceCode | VARCHAR(50) | N | ||
| 5 | CustomerEMailID | VARCHAR(50) | N | ||
| 6 | CustomerName | VARCHAR(50) | N | ||
| 7 | EnterpriseCode | VARCHAR(50) | N | ||
| 8 | EntryType | VARCHAR(50) | N | ||
| 9 | OrderDate | VARCHAR(50) | N | ||
| 10 | OrderHeaderKey | VARCHAR(50) | N | ||
| 11 | OrderNo | VARCHAR(50) | N | ||
| 12 | OrderType | VARCHAR(50) | N | ||
| 13 | PaymentStatus | VARCHAR(50) | N | ||
| 14 | PriorityNumber | VARCHAR(50) | N | ||
| 15 | ExtnContinuityInterval | VARCHAR(50) | N | ||
| 16 | ExtnCustId | VARCHAR(50) | N | ||
| 17 | ExtnLocaleCode | VARCHAR(50) | N | ||
| 18 | ExtnNextShipmentDate | VARCHAR(50) | N | ||
| 19 | Amount | VARCHAR(50) | N | ||
| 20 | InstallmentCollectionDate | VARCHAR(50) | N | ||
| 21 | InstallmentSeq | VARCHAR(50) | N | ||
| 22 | IsPaid | VARCHAR(50) | N | ||
| 23 | TChargeAmount | VARCHAR(50) | N | ||
| 24 | Currency | VARCHAR(50) | N | ||
| 25 | TotalAmount | VARCHAR(50) | N | ||
| 26 | OrderedQty | INT | N | ||
| 27 | OriginalTax | VARCHAR(50) | N | ||
| 28 | OtherCharges | VARCHAR(50) | N | ||
| 29 | PrimeLineNo | VARCHAR(50) | N | ||
| 30 | ShipNode | VARCHAR(50) | N | ||
| 31 | ItemDesc | VARCHAR(50) | N | ||
| 32 | ItemID | VARCHAR(50) | N | ||
| 33 | TaxProductCode | VARCHAR(50) | N | ||
| 34 | AddressLine1 | VARCHAR(100) | N | ||
| 35 | AddressLine2 | VARCHAR(100) | N | ||
| 36 | AddressLine3 | VARCHAR(100) | N | ||
| 37 | AddressLine4 | VARCHAR(100) | N | ||
| 38 | AddressLine5 | VARCHAR(100) | N | ||
| 39 | AddressLine6 | VARCHAR(100) | N | ||
| 40 | City | VARCHAR(50) | N | ||
| 41 | Country | VARCHAR(50) | N | ||
| 42 | FirstName | VARCHAR(50) | N | ||
| 43 | LastName | VARCHAR(50) | N | ||
| 44 | MiddleName | VARCHAR(50) | N | ||
| 45 | EMailID | VARCHAR(50) | N | ||
| 46 | MobilePhone | VARCHAR(50) | N | ||
| 47 | State | VARCHAR(50) | N | ||
| 48 | ZipCode | VARCHAR(50) | N | ||
| 49 | ExtendedPrice | VARCHAR(50) | N | ||
| 50 | Tax | VARCHAR(50) | N | ||
| 51 | UnitPrice | VARCHAR(50) | N | ||
| 52 | ChargeAmount | VARCHAR(50) | N | ||
| 53 | ChargeCategory | VARCHAR(50) | N | ||
| 54 | ChargeName | VARCHAR(50) | N | ||
| 55 | ChargePerUnit | VARCHAR(50) | N | ||
| 56 | OrderReleaseKey | VARCHAR(50) | N | ||
| 57 | PaymentType | VARCHAR(50) | N | ||
| 58 | ConfirmedQTY | INT | N | ||
| 59 | ID | NUMERIC(0,18) | N |