XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvModVo in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
delivery_id |
number15 |
1 |
1 |
Transfer delivery unique identifier. |
TSF_DELV |
ID |
NUMBER |
15 |
Yes |
Transfer delivery unique identifier. |
store_id |
number10 |
1 |
1 |
Store identifier. |
TSF_DELV |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
carrier_name |
varchar2128 |
0 |
1 |
The name of the carrier. |
TSF_DELV |
CARRIER_ENTITY |
VARCHAR2 |
128 |
No |
The name of the carrier. |
carrier_type |
carrier_type |
1 |
1 |
The type of the carrier. Valid values are CORPORATE, THIRD_PARTY, UNKNOWN. |
TSF_DELV |
CARRIER_TYPE |
NUMBER |
2 |
No |
The Carrier type.0 - Corporate,1 - Third Party |
carrier_code |
varchar24 |
0 |
1 |
Unique code identifier for a carrier. |
TSF_DELV. |
CARRIER_CODE |
VARCHAR2 |
4 |
No |
Unique code identifier for a carrier. |
source_address |
varchar21000 |
0 |
1 |
The address of source location that is sending the delivery. |
TSF_DELV |
SOURCE_ADDRESS |
VARCHAR2 |
1000 |
Yes |
The address of source location that is sending the shipment. |
license_plate |
varchar2128 |
0 |
1 |
License plate. |
TSF_DELV |
LICENSE_PLATE |
VARCHAR2 |
128 |
No |
License plate. |
freight_id |
varchar2128 |
0 |
1 |
Freight identifier. |
TSF_DELV |
FREIGHT_ID |
VARCHAR2 |
128 |
No |
Freight identifier. |
external_bol |
varchar2128 |
0 |
1 |
External bill of lading number. |
TSF_DELV |
BOL_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
External bill of lading number. |