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. |