Database Table "hyp_Supplier Commission List"
Table Description
The table of the approved commissions for a middleman.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Supplier Number | Integer | 0 | Edit | Hidden Read Only Key Field |
SupplierNumber | |
| Created On | FixDT | 0 | Edit | Read Only Key Field |
CreatedOn | |
| Created By | String | 40 | Edit | Read Only | CreatedBy | |
| Creation Method | Values List: 0 = Manually1 = Hyper Embedded Code 2 = Dynamic Script 3 = Web API Req |
Status | 0 | Select | Read Only | CreationMethod |
| Reference Document Issue Date | Date | 0 | SelectEdit | ReferenceDocumentIssueDate | ||
| Reference Document Type | String | 20 | Select | Spare Field | ReferenceDocumentType | |
| Reference Document | Integer | 0 | Edit | Spare Field | ReferenceDocument | |
| Refers to Client Number | Integer | 0 | Edit | Read Only | RefersToClientNumber | |
| Client Full Name | String | 105 | PopupList | ClientFullName | ||
| Client Agency | Status | 0 | Select | Read Only | ClientAgency | |
| Total Amount Due | Money | 0 | Edit | TotalAmountDue | ||
| Commission % Rate | Real | 0 | Edit | CommissionRate | ||
| Commission | Money | 0 | Edit | Commission | ||
| Currency | String | 5 | Select | Currency | ||
| Commission Approval | Values List: 0 = Waiting1 = Approved 2 = Denied |
Status | 0 | Select | CommissionApproval | |
| Commission Decision On | FixDT | 0 | SelectEdit | Read Only | CommissionDecisionOn | |
| Commission Decision By | String | 40 | SelectEdit | Read Only | CommissionDecisionBy | |
| Commission Paid On | Date | 0 | SelectEdit | CommissionPaidOn | ||
| Paid Against Supplier Invoice | Integer | 0 | Edit | PaidAgainstSupplierInvoice | ||
| Paid in Cheque Number | Integer | 0 | Edit | PaidInChequeNumber | ||
| Notes | String | 80 | Edit | Notes |