DW_NS_ShipItem_D
This table contains information on the shipping method for sales orders.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| account | NUMBER | 38 | 0 | Account | |||
| countries | VARCHAR2 | 999 | Countries | ||||
| displayname | VARCHAR2 | 999 | Displayname | ||||
| freeifordertotalisoveramount | NUMBER | free shipping if ordertotal is over certain amount | |||||
| isfreeifordertotalisover | VARCHAR2 | 16 | Is ree if order total is over certain amount | ||||
| isinactive | VARCHAR2 | 16 | Is inactive | ||||
| itemid | VARCHAR2 | 512 | item id | ||||
| maximumshippingcost | NUMBER | Maximum shipping cost | |||||
| minimumshippingcost | NUMBER | Minimum shipping cost | |||||
| omitpackaging | VARCHAR2 | 16 | Omit packaging | ||||
| shippingaspercentageoftotal | NUMBER | shippingaspercentageoftotal | |||||
| subsidiary | NUMBER | 38 | 0 | subsidiary | DW_NS_subsidiary_D | id |