[Home] [Help] [Dependency Information]
Object Name: | FTE_DLV_ACTION_PARAM_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
PHASE | NUMBER |
|
|
ACTION_CODE | VARCHAR2 | (30) | |
TRIP_ID | NUMBER |
|
|
TRIP_NAME | VARCHAR2 | (30) | |
PICKUP_STOP_ID | NUMBER |
|
|
PICKUP_LOC_ID | NUMBER |
|
|
PICKUP_STOP_SEQ | NUMBER |
|
|
PICKUP_LOC_CODE | VARCHAR2 | (80) | |
PICKUP_ARR_DATE | DATE |
|
|
PICKUP_DEP_DATE | DATE |
|
|
PICKUP_STOP_STATUS | VARCHAR2 | (2) | |
DROPOFF_STOP_ID | NUMBER |
|
|
DROPOFF_LOC_ID | NUMBER |
|
|
DROPOFF_STOP_SEQ | NUMBER |
|
|
DROPOFF_LOC_CODE | VARCHAR2 | (80) | |
DROPOFF_ARR_DATE | DATE |
|
|
DROPOFF_DEP_DATE | DATE |
|
|
DROPOFF_STOP_STATUS | VARCHAR2 | (2) | |
ACTION_FLAG | VARCHAR2 | (1) | |
INTRANSIT_FLAG | VARCHAR2 | (1) | |
CLOSE_TRIP_FLAG | VARCHAR2 | (1) | |
STAGE_DEL_FLAG | VARCHAR2 | (1) | |
BILL_OF_LADING_FLAG | VARCHAR2 | (1) | |
MC_BILL_OF_LADING_FLAG | VARCHAR2 | (1) | |
OVERRIDE_FLAG | VARCHAR2 | (1) | |
SHIP_METHOD_CODE | VARCHAR2 | (240) | |
ACTUAL_DEP_DATE | DATE |
|
|
REPORT_SET_ID | NUMBER |
|
|
REPORT_SET_NAME | VARCHAR2 | (30) | |
SEND_945_FLAG | VARCHAR2 | (1) | |
ACTION_TYPE | VARCHAR2 | (1) | |
DOCUMENT_TYPE | VARCHAR2 | (2) | |
ORGANIZATION_ID | NUMBER |
|
|
REASON_OF_TRANSPORT | VARCHAR2 | (30) | |
DESCRIPTION | VARCHAR2 | (30) |
|
|
|