| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| orderId | integer |
None. |
|
| orderlineId | integer |
None. |
|
| productlistId | integer |
None. |
|
| model | string |
None. |
|
| customerId | integer |
None. |
|
| customerName | string |
None. |
|
| contactId | integer |
None. |
|
| contactFullName | string |
None. |
|
| promisedQuantity | integer |
None. |
|
| promisedPricePerItem | decimal number |
None. |
|
| promisedTotal | decimal number |
None. |
|
| newQuantity | integer |
None. |
|
| newPricePerItem | decimal number |
None. |
|
| newTotal | decimal number |
None. |
|
| updateStockStatus | string |
None. |
|
| updateCount | integer |
None. |
|
| userRecorded | string |
None. |
|
| discrepancy | integer |
None. |
|
| changeDateTime | date |
None. |
|
| TblContact | TblContact |
None. |
|
| TblCustomerSupplier | TblCustomerSupplier |
None. |
|
| TblOrder | TblOrder |
None. |
|
| TblOrderLine | TblOrderLine |
None. |
|
| TblProductStock | TblProductStock |
None. |