StockAuditTrails - Audit trail of stock movements i.e. added, removed
Column | Type | Notes |
---|---|---|
AuditNo | WHOLE NUMBER | |
CallNo | WHOLE NUMBER | |
IssueRef | TEXT | |
JobCostingCompanyNo | WHOLE NUMBER | |
JobCostingJobNo | WHOLE NUMBER | |
JobCostingProductCode | TEXT | |
LocationCode | TEXT | |
Operator | TEXT | |
ProductCode | TEXT | |
PurchaseOrderNumber | TEXT | |
Quantity | DECIMAL NUMBER | |
TransactionDate | DATETIME | |
TransactionType | TEXT | |
LastEditDate | DATETIME | |
Deleted | BINARY |