[Home] [Help] [Dependency Information]
Object Name: | WSH_OPSM_ASN_ITEMS_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
DELIVERY_ID | NUMBER |
|
|
CONTAINER_INSTANCE_ID | NUMBER |
|
|
ITEM_ID | NUMBER |
|
|
ORDER_BY_CUSTOMER_ID | NUMBER |
|
|
ORDER_BY_CONTACT_ID | NUMBER |
|
|
ORDER_HEADER_ID | NUMBER |
|
|
ORDER_LINE_ID | NUMBER |
|
|
SALES_ORDER_NUMBER | VARCHAR2 | (50) | |
ORDER_TYPE | VARCHAR2 | (30) | |
ORDER_LINE_NUMBER | VARCHAR2 | (150) | |
DELIVERY_DETAIL_ID | NUMBER |
|
|
CUSTOMER_ITEM_ID | NUMBER |
|
|
REQUESTED_DATE | DATE |
|
|
PROMISE_DATE | DATE |
|
|
ORDERED_QUANTITY | NUMBER |
|
|
ORDER_QUANTITY_UOM | VARCHAR2 | (10) | |
CANCELLED_QUANTITY | NUMBER |
|
|
SHIPPED_QUANTITY | NUMBER |
|
|
SHIPPING_QUANTITY_UOM | VARCHAR2 | (10) | |
HAZARD_CLASS | VARCHAR2 | (40) | |
ORGANIZATION_ID | NUMBER |
|
|
DESTINATION_CONT_ID | NUMBER |
|
|
INVOICE_TO_ORG_ID | NUMBER |
|
|
INVOICE_TO_CONTACT_ID | NUMBER |
|
|
ITEM | VARCHAR2 | (40) | |
DESCRIPTION | VARCHAR2 | (240) | |
NET_WEIGHT | NUMBER |
|
|
WEIGHT_UOM | VARCHAR2 | (3) | |
VOLUME | NUMBER |
|
|
VOLUME_UOM_CODE | VARCHAR2 | (3) | |
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | |
ITEM_DESCRIPTION | VARCHAR2 | (250) | |
LOT_CONTROL_CODE | NUMBER |
|
|
SERIAL_NUMBER_CONTROL_CODE | NUMBER |
|
|
OPSM_INTEGRATED_FLAG | VARCHAR2 | (5) | |
SERIAL_TYPE | VARCHAR2 | (150) |
|
|
|