DW_NS_item_D
This table contains information on items like item name, item type, units of measurement, etc.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Key | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| displayname | VARCHAR2 | 999 | Display Name | ||||
| fullname | VARCHAR2 | 999 | Full Name | ||||
| itemtypeflag | VARCHAR2 | 16 | item type flag | ||||
| includechildren | VARCHAR2 | 16 | Include Children | ||||
| isdropshipitem | VARCHAR2 | 16 | Drop Ship Item | ||||
| isfulfillable | VARCHAR2 | 16 | Can be Fulfilled | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| islotitem | VARCHAR2 | 16 | Lot Numbered | ||||
| isonline | VARCHAR2 | 16 | Display in Web Site | ||||
| isphantom | VARCHAR2 | 16 | Phantom | ||||
| isserialitem | VARCHAR2 | 16 | Serialized | ||||
| isspecialorderitem | VARCHAR2 | 16 | Special Order Item | ||||
| isspecialworkorderitem | VARCHAR2 | 16 | Special Work Order Item | ||||
| availabletopartners | VARCHAR2 | 16 | Available to Adv. Partners | ||||
| generateaccruals | VARCHAR2 | 16 | Generate Accruals | ||||
| matchbilltoreceipt | VARCHAR2 | 16 | Match Bill To Receipt | ||||
| tracklandedcost | VARCHAR2 | 16 | Track Landed Cost | ||||
| shipindividually | VARCHAR2 | 16 | Ships Individually | ||||
| createddate | TIMESTAMP | Date Created | |||||
| lastmodifieddate | TIMESTAMP | Date Last Modified | |||||
| billingschedule | NUMBER | 38 | 0 | Billing Schedule | DW_NS_billingSchedule_D | id | |
| class | NUMBER | 38 | 0 | Class | DW_NS_classification_D | id | |
| consumptionunit | NUMBER | 38 | 0 | Consumption Units | DW_NS_unitsTypeUom_D | internalid | |
| costcategory | NUMBER | 38 | 0 | Cost Category | DW_NS_costCategory_D | id | |
| department | NUMBER | 38 | 0 | Department | DW_NS_department_D | id | |
| incomeaccount | NUMBER | 38 | 0 | Account | DW_NS_account_D | id | |
| assetaccount | NUMBER | 38 | 0 | Asset Account | |||
| deferralaccount | NUMBER | 38 | 0 | Deferred Expense Account | |||
| deferredrevenueaccount | NUMBER | 38 | 0 | Deferred Revenue Account | |||
| expenseaccount | NUMBER | 38 | 0 | Expense Account | |||
| itemrevenuecategory | NUMBER | 38 | 0 | Item Revenue Category | DW_NS_itemRevenueCategory_D | id | |
| location | NUMBER | 38 | 0 | Location | DW_NS_location_D | id | |
| preferredlocation | NUMBER | 38 | 0 | Preferred Location | |||
| maximumquantity | NUMBER | 38 | 0 | Maximum Order Qty | |||
| minimumquantity | NUMBER | 38 | 0 | Minimum Order Qty | |||
| parent | NUMBER | 38 | 0 | Parent | DW_NS_item_D | id | |
| saleunit | NUMBER | 38 | 0 | Sale Unit | DW_NS_unitsTypeUom_D | internalid | |
| unitstype | NUMBER | 38 | 0 | [Missing Label:unitsType] | DW_NS_unitsType_D | id | |
| weightunit | NUMBER | 38 | 0 | Weight Unit | DW_NS_itemUnit_D | key | |
| costestimatetype | VARCHAR2 | 64 | Cost Estimate Type | DW_NS_costEstimateType_D | key | ||
| costingmethod | VARCHAR2 | 32 | Costing Method | DW_NS_CostingMethodType_D | key | ||
| countryofmanufacture | VARCHAR2 | 16 | Country of Manufacture | DW_NS_Country_D | id | ||
| description | VARCHAR2 | 999 | Description | ||||
| purchasedescription | VARCHAR2 | 999 | Purchase Description | ||||
| itemid | VARCHAR2 | 512 | Subscription Plan Name | ||||
| itemtype | VARCHAR2 | 32 | Task Item Type | ||||
| manufacturer | VARCHAR2 | 512 | Manufacturer | ||||
| subsidiary | VARCHAR2 | 999 | Subsidiary | ||||
| subtype | VARCHAR2 | 32 | Subtype | DW_NS_itemSubtype_D | key | ||
| upccode | VARCHAR2 | 512 | UPC Code | ||||
| vendorname | VARCHAR2 | 512 | Vendor Name/Code | ||||
| weightunits | VARCHAR2 | 999 | Weight Units | ||||
| averagecost | NUMBER | Average Cost | |||||
| cost | NUMBER | Purchase Price | |||||
| fxcost | NUMBER | Purchase Price (Foreign Currency) | |||||
| costestimate | NUMBER | Est. Cost | |||||
| handlingcost | NUMBER | Handling Cost | |||||
| shippingcost | NUMBER | Shipping Cost | |||||
| weight | NUMBER | Weight | |||||
| revenueallocationgroup | NUMBER | 38 | 0 | Revenue Allocation Group | DW_NS_revenueAllocationgroup_D | id | |
| revenuerecognitionrule | NUMBER | 38 | 0 | Revenue Recognition Rule | DW_NS_RevenueRecognitionRule_D | id | |
| revrecforecastrule | NUMBER | 38 | 0 | Revenue Forecast Rule | DW_NS_RevenueRecognitionRule_D | id | |
| revreclassfxaccount | NUMBER | 38 | 0 | Revenue Foreign Currency Adjustment Account | DW_NS_account_D | id | |
| createrevenueplanson | NUMBER | 38 | 0 | Create Revenue Plan On | DW_NS_ratableEventType_D | id | |
| vsoesopgroup | VARCHAR2 | 64 | Allocation Type | DW_NS_vsoeSopGroupType_D | key | ||
| directrevenueposting | VARCHAR2 | 16 | Direct Revenue Posting | ||||
| scrapacct | NUMBER | 38 | 0 | Scrap Account | DW_NS_account_D | id | |
| unbuildvarianceaccount | NUMBER | 38 | 0 | Unbuild Variance Account | DW_NS_account_D | id | |
| wipacct | NUMBER | 38 | 0 | WIP Account | DW_NS_account_D | id | |
| wipvarianceacct | NUMBER | 38 | 0 | WIP Variance Account | DW_NS_account_D | id | |
| manufacturingchargeitem | VARCHAR2 | 16 | Manufacturing Routing and Work Center | ||||
| taxtype | NUMBER | 38 | 0 | Tax Type | DW_NS_taxType_D | id | |
| storedisplayimage | NUMBER | 38 | 0 | Item Display Image | DW_NS_File_D | id | |
| storedisplaythumbnail | NUMBER | 38 | 0 | Item Display Thumbnail | DW_NS_File_D | id | |
| mpn | VARCHAR2 | 256 | |||||
| purchaseunit | NUMBER | 38 | 0 | DW_NS_unitsTypeUom_D | internalid | ||
| stockunit | NUMBER | 38 | 0 | DW_NS_unitsTypeUom_D | internalid | ||
| usebins | VARCHAR2 | 16 |