Bill Of Lading Records
In ScopeTechnical: SHIPMENT_BOL | ID: OR-STO-SHIPMENT_BOL-SHIPMENT_BOL
Stores bill of lading records.
See how this object fits into Store Operations
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_BOL
Field Definitions(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | CARRIER_ROLER | MOTIVE | STATUS | TAX_ID | SHIP_TYPE | SHIP_WEIGHT | UPDATE_DATE | UPDATE_USER | SHIP_CARRIER_ID | SHIP_WEIGHT_UOM | TRACKING_NUMBER | THIRD_PARTY_NAME | THIRD_PARTY_ADDRESS | SHIP_TO_ADDRESS_TYPE | REQUESTED_PICKUP_DATE | SHIPMENT_CARTON_DIM_ID | ALT_DESTINATION_ADDRESS | SHIP_CARRIER_SERVICE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAMPLE | 1 | SAMP | SAMPLE | SAMPLE | SAMPLE | SA | 2026-01-01 | 1 | SAMPLE | 1 |
| default | 3 | 3 | Shipment Bol-002-ALT | 3 | ALT-SHIPMENT_B-002 | 3 | 12.5000 | 2026-01-03 | 2026-01-02-ALT | 1000000003 | Ship | Shipment Bol-002-ALT | Shipment Bol Secondary | Shipment Bol-002-ALT | 02 | 2026-01-03 | 1000000003 | Shipment Bol-002-ALT | 1000000003 |
| default | 5 | 5 | Shipment Bol-003-EDGE | 5 | EDGE-SHIPMENT_B-00 | 5 | 14.0000 | 2026-01-05 | 2026-01-03-EDGE | 1000000005 | Ship | Shipment Bol-003-EDGE | Shipment Bol Core | Shipment Bol-003-EDGE | 03 | 2026-01-05 | 1000000005 | Shipment Bol-003-EDGE | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- CARRIER_ROLER
- 1
- MOTIVE
- SAMPLE
- STATUS
- 1
- TAX_ID
- SAMPLE
- SHIP_TYPE
- 1
- SHIP_WEIGHT
- 1.0000
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- SHIP_CARRIER_ID
- 1
- SHIP_WEIGHT_UOM
- SAMP
- TRACKING_NUMBER
- SAMPLE
- THIRD_PARTY_NAME
- SAMPLE
- THIRD_PARTY_ADDRESS
- SAMPLE
- SHIP_TO_ADDRESS_TYPE
- SA
- REQUESTED_PICKUP_DATE
- 2026-01-01
- SHIPMENT_CARTON_DIM_ID
- 1
- ALT_DESTINATION_ADDRESS
- SAMPLE
- SHIP_CARRIER_SERVICE_ID
- 1
default
- IDRPK
- 3
- CARRIER_ROLER
- 3
- MOTIVE
- Shipment Bol-002-ALT
- STATUS
- 3
- TAX_ID
- ALT-SHIPMENT_B-002
- SHIP_TYPE
- 3
- SHIP_WEIGHT
- 12.5000
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- SHIP_CARRIER_ID
- 1000000003
- SHIP_WEIGHT_UOM
- Ship
- TRACKING_NUMBER
- Shipment Bol-002-ALT
- THIRD_PARTY_NAME
- Shipment Bol Secondary
- THIRD_PARTY_ADDRESS
- Shipment Bol-002-ALT
- SHIP_TO_ADDRESS_TYPE
- 02
- REQUESTED_PICKUP_DATE
- 2026-01-03
- SHIPMENT_CARTON_DIM_ID
- 1000000003
- ALT_DESTINATION_ADDRESS
- Shipment Bol-002-ALT
- SHIP_CARRIER_SERVICE_ID
- 1000000003
default
- IDRPK
- 5
- CARRIER_ROLER
- 5
- MOTIVE
- Shipment Bol-003-EDGE
- STATUS
- 5
- TAX_ID
- EDGE-SHIPMENT_B-00
- SHIP_TYPE
- 5
- SHIP_WEIGHT
- 14.0000
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- SHIP_CARRIER_ID
- 1000000005
- SHIP_WEIGHT_UOM
- Ship
- TRACKING_NUMBER
- Shipment Bol-003-EDGE
- THIRD_PARTY_NAME
- Shipment Bol Core
- THIRD_PARTY_ADDRESS
- Shipment Bol-003-EDGE
- SHIP_TO_ADDRESS_TYPE
- 03
- REQUESTED_PICKUP_DATE
- 2026-01-05
- SHIPMENT_CARTON_DIM_ID
- 1000000005
- ALT_DESTINATION_ADDRESS
- Shipment Bol-003-EDGE
- SHIP_CARRIER_SERVICE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 33