Database Table "hyp_Client Monthly Billing for Services"
Table Description
Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Client Number | Integer | 0 | Edit | Hidden Read Only Key Field |
ClientNumber | |
| Commitment ID | Integer | 0 | Edit | Read Only Key Field |
CommitmentId | |
| Service Started From | Date | 0 | SelectEdit | Mandatory | ServiceStartedFrom | |
| Service Ends At | Date | 0 | SelectEdit | ServiceEndsAt | ||
| Catalogic Number | String | 30 | PopupList | CatalogicNumber | ||
| Description | String | 120 | Edit | Mandatory | Description | |
| Quantity | Real | 0 | Edit | Mandatory Spare Field |
Quantity | |
| Unit of measure | Status | 0 | Select | UnitOfMeasure | ||
| Net Sale Price | Real | 0 | Edit | NetSalePrice | ||
| Gross Sale Price | Money | 0 | Edit | GrossSalePrice | ||
| Sale Price Method | Values List: 0 = Net Price1 = VAT included |
Status | 0 | Select | Read Only | SalePriceMethod |
| Sale Currency | String | 5 | Select | Mandatory | SaleCurrency | |
| Logic | Values List: 0 = Monthly Repeating1 = Fix-Price Repeating 2 = One-time Event 3 = Not for Wizard |
Status | 0 | Select | Logic | |
| Last Billing Date | Date | 0 | SelectEdit | Read Only | LastBillingDate | |
| Notes | String | 300 | TextMemo | Notes | ||
| Tax Class | String | 3 | Select | TaxClass |