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 | If applicable |
Description | Open sales orders are used to align with the order calculations at AGR so that order quantities consider the open sales orders. |
Criteria | For all items that are open for ordering in AGR. Item + location level. |
Primary key | SALES_ORDER_NO, ITEM_NO, LOCATION_NO |
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 |
SALES_ORDER_NO | NO as in Sales_Order table | nvarchar(128) |
PRODUCT_ITEM_NO | NO as in ITEM table | nvarchar(255) |
LOCATION_NO | LOCATION_NO from Sales Order table | nvarchar(255) |
QUANTITY | The amount which has been sold | decimal(18,4) |
EXPIRE_DATE | The date the item will expire | date |
DELIVERY_DATE | The date the order is shipped | date |
DELIVERY_STATUS | 0 if the order line has been created; 1 if invoiced | tinyint |