One Row For Each Shipment
In ScopeTechnical: SHIPMENT | ID: OR-INV-SHIPMENT-SHIPMENT
Stores one row for each shipment within the system. Base information about each shipment for each order is held in this table for as long as its associated order header...
See how this object fits into Inventory Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SHIPMENT
Field Definitions(5)
Rules & Considerations(40)
Sample Load Data(4)
| _scenario | SHIPMENTRPK | SHIP_DATER | ASN | BOL_NO | TO_LOC | COURIER | COMMENTS | FROM_LOC | NO_BOXES | ORDER_NO | CREATE_ID | REF_DOC_NO | BILL_TO_LOC | SHIP_ORIGIN | STATUS_CODE | TO_LOC_TYPE | EST_ARR_DATE | RECEIVE_DATE | EXCHANGE_RATE | EXT_REF_NO_IN | FROM_LOC_TYPE | EXT_REF_NO_OUT | LAST_UPDATE_ID | CREATE_DATETIME | INVC_MATCH_DATE | PARENT_SHIPMENT | BILL_TO_LOC_TYPE | INVC_MATCH_STATUS | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 2026-01-01 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | S | S | S | 2026-01-01 | 2026-01-01 | 1.0000000000 | SAMPLE | S | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | S | S | 2026-01-01 |
| default | 3 | 2026-01-03 | Shipment-002-ALT | Shipment-002-ALT | 3 | Shipment-002-ALT | Shipment-002-ALT | 3 | 3 | 4 | C LIENT_INFO | Shipment-002-ALT | 3 | 0 | R | S | 2026-01-03 | 2026-01-03 | 12.5000000000 | Shipment-002-ALT | S | Shipment-002-ALT | C LIENT_INFO | 2026-01-03 | 2026-01-03 | 3 | S | P | 2026-01-03 |
| default | 5 | 2026-01-05 | Shipment-003-EDGE | Shipment-003-EDGE | 5 | Shipment-003-EDGE | Shipment-003-EDGE | 5 | 5 | 6 | USE RENV | Shipment-003-EDGE | 5 | 0 | R | S | 2026-01-05 | 2026-01-05 | 14.0000000000 | Shipment-003-EDGE | S | Shipment-003-EDGE | USE RENV | 2026-01-05 | 2026-01-05 | 5 | S | M | 2026-01-05 |
Example values from field definitions
- SHIPMENTRPK
- 1
- SHIP_DATER
- 2026-01-01
- ASN
- SAMPLE
- BOL_NO
- SAMPLE
- TO_LOC
- 1
- COURIER
- SAMPLE
- COMMENTS
- SAMPLE
- FROM_LOC
- 1
- NO_BOXES
- 1
- ORDER_NO
- 1
- CREATE_ID
- SAMPLE
- REF_DOC_NO
- SAMPLE
- BILL_TO_LOC
- 1
- SHIP_ORIGIN
- S
- STATUS_CODE
- S
- TO_LOC_TYPE
- S
- EST_ARR_DATE
- 2026-01-01
- RECEIVE_DATE
- 2026-01-01
- EXCHANGE_RATE
- 1.0000000000
- EXT_REF_NO_IN
- SAMPLE
- FROM_LOC_TYPE
- S
- EXT_REF_NO_OUT
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- INVC_MATCH_DATE
- 2026-01-01
- PARENT_SHIPMENT
- 1
- BILL_TO_LOC_TYPE
- S
- INVC_MATCH_STATUS
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- SHIPMENTRPK
- 3
- SHIP_DATER
- 2026-01-03
- ASN
- Shipment-002-ALT
- BOL_NO
- Shipment-002-ALT
- TO_LOC
- 3
- COURIER
- Shipment-002-ALT
- COMMENTS
- Shipment-002-ALT
- FROM_LOC
- 3
- NO_BOXES
- 3
- ORDER_NO
- 4
- CREATE_ID
- C LIENT_INFO
- REF_DOC_NO
- Shipment-002-ALT
- BILL_TO_LOC
- 3
- SHIP_ORIGIN
- 0
- STATUS_CODE
- R
- TO_LOC_TYPE
- S
- EST_ARR_DATE
- 2026-01-03
- RECEIVE_DATE
- 2026-01-03
- EXCHANGE_RATE
- 12.5000000000
- EXT_REF_NO_IN
- Shipment-002-ALT
- FROM_LOC_TYPE
- S
- EXT_REF_NO_OUT
- Shipment-002-ALT
- LAST_UPDATE_ID
- C LIENT_INFO
- CREATE_DATETIME
- 2026-01-03
- INVC_MATCH_DATE
- 2026-01-03
- PARENT_SHIPMENT
- 3
- BILL_TO_LOC_TYPE
- S
- INVC_MATCH_STATUS
- P
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- SHIPMENTRPK
- 5
- SHIP_DATER
- 2026-01-05
- ASN
- Shipment-003-EDGE
- BOL_NO
- Shipment-003-EDGE
- TO_LOC
- 5
- COURIER
- Shipment-003-EDGE
- COMMENTS
- Shipment-003-EDGE
- FROM_LOC
- 5
- NO_BOXES
- 5
- ORDER_NO
- 6
- CREATE_ID
- USE RENV
- REF_DOC_NO
- Shipment-003-EDGE
- BILL_TO_LOC
- 5
- SHIP_ORIGIN
- 0
- STATUS_CODE
- R
- TO_LOC_TYPE
- S
- EST_ARR_DATE
- 2026-01-05
- RECEIVE_DATE
- 2026-01-05
- EXCHANGE_RATE
- 14.0000000000
- EXT_REF_NO_IN
- Shipment-003-EDGE
- FROM_LOC_TYPE
- S
- EXT_REF_NO_OUT
- Shipment-003-EDGE
- LAST_UPDATE_ID
- USE RENV
- CREATE_DATETIME
- 2026-01-05
- INVC_MATCH_DATE
- 2026-01-05
- PARENT_SHIPMENT
- 5
- BILL_TO_LOC_TYPE
- S
- INVC_MATCH_STATUS
- M
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 75
- Governed Rule Count
- 40