XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for XTsfDesc in AIP application. |
AIP's Table Name | AIP's Column Name | Integration API(RIB or/and RSB or/and RSL) | AIP's Column Length | Is Column Required in AIP's API? | AIP's API Description |
tsf_no | number12 | 1 | 1 | Number that uniquely identifies the transfer. | * | * | null | null | Yes | Number that uniquely identifies the transfer. |
from_loc_type | varchar21 | 1 | 1 | The location type of the from location. | * | * | null | null | Yes | The location type of the From location. |
from_loc | varchar210 | 1 | 1 | The location number of the from location. | * | * | null | null | Yes | The location number of the From location. |
to_loc_type | varchar21 | 1 | 1 | The location type of the to location. | * | * | null | null | Yes | The location type of the To location. |
to_loc | varchar210 | 1 | 1 | The location number of the to location. | * | * | null | null | Yes | The location number of the To location. |
delivery_date | xs:dateTime | 0 | 1 | The earliest date the transfer can be delivered. | * | * | null | null | No | The earliest date on which the transfer can be delivered. |
dept | number4 | 0 | 1 | The department number associated with the transfer. | * | * | null | null | No | The department number associated with the transfer. |
routing_code | varchar21 | 0 | 1 | If the freight status is expedite, this is a code indicating more detailed freight info. | * | * | null | null | No | If the freight status is expedite, this code indicates more detailed freight information. |
freight_code | varchar21 | 0 | 1 | A code indicating the freight status of the transfer (e.g. normal, expedite, etc.). | * | * | null | null | No | A code indicating the freight status of the transfer (such as normal and expedite.). |
tsf_type | varchar26 | 0 | 1 | A code indicating the type of transfer (e.g. store requisition, book transfer, etc.). | * | * | null | null | No | A code indicating the type of transfer (for example, store requisition and book transfer). |
XTsfDtl | * | 0 | unbounded | Child node - see layout below. | | | | | | |
status | varchar21 | 0 | 1 | A code indicating the status of the transfer (e.g. approved, closed, etc.). | * | * | null | null | No | A code indicating the status of the transfer (such as Approved and Closed). |
user_id | varchar230 | 0 | 1 | The userid of the user who created the transfer. | * | * | null | null | No | The userid of the user who created the transfer. |
comment_desc | varchar22000 | 0 | 1 | Comments associated with the transfer. | * | * | null | null | No | Comments associated with the transfer. |
context_type | varchar26 | 0 | 1 | This field holds the functional area code to which the transfer relates to. Valid values are PROM and REPAIR. | NA | NA | NA | NA | NA | NA |
context_value | varchar225 | 0 | 1 | This field holds the value relating to the context type like Promotion number. | NA | NA | NA | NA | NA | NA |