Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
Creation Date | 27/10/2017 14:33 |
Encrypted | |
Ansi Nulls |
Parameter | Direction | Description | Data Type | Size |
---|---|---|---|---|
@RETURN_VALUE | Return Value | DBTimeStamp | 4 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
iduSalesOrderDetail | Trigger | AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column. | 3 | |
Sales.SalesOrderDetail | Table | Individual products associated with a specific sales order. See SalesOrderHeader. | 2 | |
Sales.SalesOrderHeader | Table | General sales order information. | 1 | |
Sales.SalesOrderHeaderSalesReason | Table | Cross-reference table mapping sales orders to sales reason codes. | 2 | |
uSalesOrderHeader | Trigger | AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables. | 2 | |
Sales.vSalesPersonSalesByFiscalYears | View | Uses PIVOT to return aggregated sales information for each sales representative. | 2 |
|