RCL_AVAILABLE_PARTS_GT
This table is a global temporary table for available parts which is used by the Part Search program.
Details
-
Schema: FUSION
-
Object owner: RCL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | 18 | The organization id identifier. | |
SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code. | |
SOURCE_TYPE_CODE | VARCHAR2 | 30 | The source type. | |
REQUIRED_ITEM_ID | NUMBER | 18 | The required item identifier. | |
REQUIRED_ITEM_REV | VARCHAR2 | 18 | It indicates the revision of the item if the item is revision controlled. | |
REQUIRED_QUANTITY | NUMBER | The required quantity. | ||
SUPPLIED_ITEM_ID | NUMBER | 18 | The supplied item identifier. | |
SUPPLIED_ITEM_REV | VARCHAR2 | 18 | The supplied item revision. | |
SUPPLIED_QUANTITY | NUMBER | The supplied quantity. | ||
SUPPLIED_ITEM_TYPE | VARCHAR2 | 10 | The supplied item type. | |
SOURCE_CARRIER_ID | NUMBER | 18 | The carrier identifier. | |
SOURCE_MODE_OF_TRANSPORT | VARCHAR2 | 30 | The mode of transportation. | |
SOURCE_SERVICE_LEVELS | VARCHAR2 | 30 | The service level. | |
SHIPPING_COST | NUMBER | The shipping cost. | ||
SOURCE_REQUEST_DATE | DATE | The request date. | ||
EXPECTED_ARRIVAL_DATE | DATE | The expected arrival date. | ||
EXPECTED_SHIP_DATE | DATE | The expected ship date. | ||
DISTANCE | NUMBER | The distance from source to destination. | ||
OPEN_OR_CLOSED | VARCHAR2 | 10 | It indicates if stocking location is open or closed. |