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 |
Primary key | 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 |
NO | Reference Number of the Sales Order | nvarchar(128) |
LOCATION_NO | NO as in Location table | nvarchar(255) |
CUSTOMER_NO | NO as in Customer table | nvarchar(255) |
DELIVERY_DATE | The date the order was invoiced to the customer | date |
DELIVERY_STATUS | 0 if the order has been created; 1 if invoiced | tinyint |