49: Transportation Management |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 910 | F49T20 | SS | 54 | 3 | Shipment Staging Table | Files | 49: Transportation Management | |
Number | Description |
---|
1 | DomainShipBatchUnitRelease (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | OTDOMAIN | Transportation Planning Domain | Ascending | 2 | OTBSHPN | Transpo Plan Buy Side Shipment ID | Ascending | 3 | TRMNUM | Transmission Number | Ascending | 4 | OTSHPUNT | Planned Ship Unit ID | Ascending | 5 | OTRSHUNT | Order Release Ship Unit | Ascending | 6 | OTORDRLN | Order Release Line ID | Ascending |
|
2 | ShipDateXRelErrFlg |
| Element | Alias | Description | Sequence |
---|
1 | OTDOMAIN | Transportation Planning Domain | Ascending | 2 | OTBSHPN | Transpo Plan Buy Side Shipment ID | Ascending | 3 | TRMNUM | Transmission Number | Ascending | 4 | DATETIME | Date and Time Stamp | Ascending | 5 | OTORDRLS | Order Release ID | Ascending | 6 | OTERRFLG | Staging Error Flag | Ascending |
|
3 | ShipmentBatchErrorFlag |
| Element | Alias | Description | Sequence |
---|
1 | OTDOMAIN | Transportation Planning Domain | Ascending | 2 | OTBSHPN | Transpo Plan Buy Side Shipment ID | Ascending | 3 | TRMNUM | Transmission Number | Ascending | 4 | OTERRFLG | Staging Error Flag | Ascending |
|