Data information
The information below tells you more about the SQL table where AGR houses this data, its importance and an external link to more information about the SQL table.
Importance | Required |
Description | Undelivered transfer orders are used for order calculations to aling calculated orders with incoming quantities. |
Criteria | On all items in the system, has to be available on item+location level. |
Primary key | TRANSFER_ORDER_NO, ITEM_NO, LOCATION_NO, DELIVERY_DATE |
Table documentation |
Column and type
The information below breaks down the data for this SQL table into columns, descriptions and types.
Column | Functional description | Type |
TRANSFER_ORDER_NO | Transfer order number | nvarchar(128) |
ITEM_NO | The Item that is being received, corresponds to NO in ITEM | nvarchar(255) |
LOCATION_NO | The number of the internal location that receives the transfer order, corresponds to NO in raw.location | nvarchar(255) |
ORDER_FROM_LOCATION_NO | The number of the internal location from which the transfer order line is sent, corresponds to NO in raw.location | nvarchar(255) |
DELIVERY_DATE | The date that the order line is planned to be received | date |
QUANTITY | The expected amount that will be received | decimal(18,4) |