Table 6707 Booking Item in 20
- App
- Base Application
Fields, 17Keys, 1Procedures, 7
Versions171819202122232425262728latest
Source29
Fields, 17
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Id | Text[250] | - |
| 2 | Start Date | Blob | - |
| 3 | End Date | Blob | - |
| 4 | Duration | Duration | - |
| 5 | Notes | Text[250] | - |
| 7 | Price Type | Option | - |
| 8 | Price | Decimal | - |
| 10 | Service ID | Text[50] | - |
| 11 | Service Name | Text[50] | - |
| 13 | Customer ID | Text[50] | - |
| 14 | Customer Email | Text[80] | - |
| 15 | Customer Name | Text[100] | - |
| 18 | Invoice Link | Text[250] | - |
| 19 | Invoice No. | Text[250] | - |
| 21 | Invoice Status | Option | - |
| 22 | Invoice Amount | Decimal | - |
| 23 | Invoice Date | Blob | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Id | - |
Procedures, 7
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetEndDate | () | DateTime | public | - |
| SetEndDate | (DateTime) | public | - | |
| GetInvoiceDate | () | DateTime | public | - |
| SetInvoiceDate | (DateTime) | public | - | |
| GetStartDate | () | DateTime | public | - |
| SetStartDate | (DateTime) | public | - | |
| CheckActionAllowed | () | Boolean | public | - |