MSC_ST_INTERORG_SHIP_METHODS
staging table for msc intergorg ship methods
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
FROM_ORGANIZATION_ID | NUMBER | 18 | From organization id for inter-organization transfers | ||
TO_ORGANIZATION_ID | NUMBER | 18 | Destination organization identifier of the shipping network. | ||
SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | ||
TIME_UOM_CODE | VARCHAR2 | 50 | Time unit of measure code of the shipping network. | ||
INSTRANSIT_TIME | NUMBER | transit time between the origin and destination | |||
DEFAULT_FLAG | NUMBER | Flag indicates whether the ship method is a default ship method. 1-Yes, 2-No. | |||
FROM_LOCATION_ID | NUMBER | 18 | Origination location identifier in a shipping network. | ||
TO_LOCATION_ID | NUMBER | 18 | Destination location identifier of the shipping network. | ||
AVAILABILITY_DATE | DATE | Identifies the actual availability date. | |||
WEIGHT_CAPACITY | NUMBER | This value indicates the weight capacity as defined in the shipping network. | |||
WEIGHT_UOM | VARCHAR2 | 50 | This value indicates the unit of measure defined in terms of weight. | ||
VOLUME_CAPACITY | NUMBER | This value indicates the volume capacity as defined in the shipping network. | |||
VOLUME_UOM | VARCHAR2 | 50 | This value indicates the unit of measure defined in terms of volume. | ||
COST_PER_WEIGHT_UNIT | NUMBER | The value indicates cost per weight unit. | |||
COST_PER_VOLUME_UNIT | NUMBER | The value indicates cost per volume unit. | |||
INTRANSIT_TIME | NUMBER | transit time between the origin and destination | |||
DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
SR_INSTANCE_ID | NUMBER | 18 | Identifier of the source system from where the data is collected. | ||
TRANSPORT_CAP_OVER_UTIL_COST | NUMBER | Transport capacity over utilization cost value. | |||
TO_REGION_ID | NUMBER | 18 | Destination region or zone identifier of the shipping network. | ||
FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | From organization code for inter-organization transfers | ||
TO_ORGANIZATION_CODE | VARCHAR2 | 18 | Destination organization code of the shipping network. | ||
SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
MESSAGE_ID | NUMBER | 18 | This value indicates the message identifier for the record. | ||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record | |||
DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of data | ||
ST_TRANSACTION_ID | NUMBER | 18 | This value indicates the staging transaction identifier. | ||
ERROR_TEXT | VARCHAR2 | 2000 | Error text for functional validation errors in the record | ||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
BATCH_ID | NUMBER | 18 | Batch identifier generated during processing | ||
COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | ||
FROM_LOCATION_CODE | VARCHAR2 | 60 | Origination location code in a shipping network. | ||
TO_LOCATION_CODE | VARCHAR2 | 60 | Destination location code of the shipping network. | ||
CURRENCY | VARCHAR2 | 40 | Currency associated with amounts | ||
FROM_ZONE | VARCHAR2 | 60 | Origination zone value as defined in the shipping network. | ||
SHIPMENT_WEIGHT | NUMBER | Shipment weight defined for the shipping network. | |||
SHIPMENT_VOLUME | NUMBER | Shipment volume defined for the shipping network. | |||
SHIPMENT_WEIGHT_UOM | VARCHAR2 | 3 | Shipment weight unit of measure defined for the shipping network. | ||
SHIPMENT_VOLUME_UOM | VARCHAR2 | 3 | Shipment volume unit of measure defined for the shipping network. | ||
LEADTIME_VARIABILITY | NUMBER | Leadtime variability defined for a shipping network. | |||
SHIP_METHOD_TEXT | VARCHAR2 | 240 | Shipping method used to move the material. | ||
CARRIER_ID | NUMBER | Populate the value of carrier id | |||
MODE_OF_TRANSPORT | VARCHAR2 | 80 | Populate the value of Mode of transport | ||
SERVICE_LEVEL | VARCHAR2 | 80 | Populate the value of service level | ||
CARRIER_NAME | VARCHAR2 | 360 | Populate the value of Carrier Name | ||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program | |||
RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
ORIGIN_ID | NUMBER | This value indicates the value of the origin identifier in the shipping network. | |||
DESTINATION_ID | NUMBER | Populate the value of Destinatin Id | |||
ORIGIN_TYPE | VARCHAR2 | 6 | Origin type of the origin code in the shipping network. | ||
DESTINATION_TYPE | VARCHAR2 | 6 | Populate the value of destination type value | ||
ORIGIN_CODE | VARCHAR2 | 360 | This value indicates the value of the origin code in the shipping network. | ||
DESTINATION_CODE | VARCHAR2 | 360 | Populate the value of destinatin code | ||
SR_INSTANCE_ID2 | NUMBER | Populate the source instance id for destination. | |||
SR_INSTANCE_CODE2 | VARCHAR2 | 8 | Populate the sr_instance code for destination. | ||
ORIGIN_REGION_TYPE | VARCHAR2 | 60 | This value indicates the value of the origin code in the shipping network. | ||
ORIGIN_REGION_ID | NUMBER | 18 | This value indicates the value of the origin region identifier in the shipping network. | ||
ORIGIN_COUNTRY_CODE | VARCHAR2 | 30 | This value indicates the value of the origin country code in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_1 | VARCHAR2 | 360 | Origin parent region code 1 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_2 | VARCHAR2 | 360 | Origin parent region code 2 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_3 | VARCHAR2 | 360 | Origin parent region code 3 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_4 | VARCHAR2 | 360 | Origin parent region code 4 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_5 | VARCHAR2 | 360 | Origin parent region code 5 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_6 | VARCHAR2 | 360 | Origin parent region code 6 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_7 | VARCHAR2 | 360 | Origin parent region code 7 specified in the shipping network. | ||
ORIGIN_PARENT_REGION_CODE_8 | VARCHAR2 | 360 | Origin parent region code 8 specified in the shipping network. | ||
DEST_REGION_TYPE | VARCHAR2 | 60 | Region type of the receiving party in a shipping network. | ||
DEST_REGION_ID | NUMBER | 18 | Region identifier of the receiving party in a shipping network. | ||
DEST_COUNTRY_CODE | VARCHAR2 | 30 | Country code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_1 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_2 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_3 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_4 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_5 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_6 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_7 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
DEST_PARENT_REGION_CODE_8 | VARCHAR2 | 360 | Parent region code of the receiving party in a shipping network. | ||
SUPPLIER_NAME | VARCHAR2 | 360 | This value indicates the Supplier name collected from source system. | ||
CUST_ACCOUNT_NUMBER | VARCHAR2 | 30 | Account number associated to the customer | ||
OPERATION_TYPE | VARCHAR2 | 2 | OPERATION_TYPE (not populated in collection) | ||
LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
TRANSIT_TIME_ID | NUMBER | 18 | Identifier of the transit time required to ship the material. | ||
CUTOFF_TIME | NUMBER | This column stores the shipping cut off time of respective inter location shipping network in minutes. The value ranges from 0 to (24*60) -1 | |||
PICK_PACK_LEAD_TIME | NUMBER | This column stores the Pick Pack Lead time of the respective interlocation shipping network in days. |