[Home] [Help] [Dependency Information]
Object Name: | RCV_OPSM_DLVLINE_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
SHIPMENT_HEADER_ID | NUMBER |
|
|
SHIPMENT_LINE_ID | NUMBER |
|
|
ITEM_ID | NUMBER |
|
|
ITEM | VARCHAR2 | (240) | |
ORGANIZATION_CODE | VARCHAR2 | (10) | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | |
OPSMINTEGRATEDFLAG | VARCHAR2 | (10) | |
SERIALTYPE | VARCHAR2 | (240) | |
QUANTITY_SHIPPED | NUMBER |
|
|
QUANTITY_RECEIVED | NUMBER |
|
|
UNIT_OF_MEASURE | VARCHAR2 | (25) | |
SHIPMENT_LINE_STATUS_CODE | VARCHAR2 | (25) | |
BAR_CODE_LABEL | VARCHAR2 | (35) | |
QC_GRADE | VARCHAR2 | (150) | |
ASN_LINE_FLAG | VARCHAR2 | (1) | |
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | |
LOT_CONTROL_CODE | NUMBER |
|
|
SERIAL_NUMBER_CONTROL_CODE | NUMBER |
|
|
OE_ORDER_HEADER_ID | NUMBER |
|
|
ORDER_NUMBER | NUMBER |
|
|
ORDER_TYPE | VARCHAR2 | (25) | |
ORDER_LINE_NUMBER | NUMBER |
|
|
SOLDBYORGID | NUMBER |
|
|
SOLDBYCONTACTID | NUMBER |
|
|
BILLEDBYORGID | NUMBER |
|
|
BILLEDBYCONTACTID | NUMBER |
|
|
SHIPFROMORGID | NUMBER |
|
|
SHIPFROMCONTACTID | NUMBER |
|
|
PARENT_TRANSACTION_ID | NUMBER |
|
|
TRANSACTION_ID | NUMBER |
|
|
TRANSACTION_TYPE | VARCHAR2 | (25) | |
TRANSACTION_DATE | DATE |
|
|
TRANSACTION_QTY | NUMBER |
|
|
TRANSACTION_UOM | VARCHAR2 | (25) | |
PRIMARY_QTY | NUMBER |
|
|
PRIMARY_UOM | VARCHAR2 | (25) | |
SECONDARY_QTY | NUMBER |
|
|
SECONDARY_UOM | VARCHAR2 | (25) | |
SOURCE_DOCUMENT_CODE | VARCHAR2 | (25) | |
TRANS_DESTINATION_TYPE_CODE | VARCHAR2 | (25) |
|
|
|