Database Table "hyp_Client X Statements"
Table Description
List of digitally signed statements & documents for customer or vendor. We always use PDF files.Normal StorageAll Data Stored Here |
Archive StorageNot In Use |
Deleted Storage(Recycle)Not In Use |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Client Number | Integer | 0 | Edit | Hidden Read Only Key Field |
ClientNumber | |
| Created On | FixDT | 0 | SelectEdit | Read Only Key Field |
CreatedOn | |
| Title | String | 50 | Edit | Read Only | Title | |
| Status | Values List: 0 = No Task1 = Waiting in queue 2 = Error / Rejected 3 = OK done |
Status | 0 | Select | Read Only | Status |
| File Ext | String | 6 | Edit | Hidden Read Only |
FileExt | |
| File Size MB | Money | 0 | Edit | Read Only | FileSizeMb | |
| Language | Status | 0 | Select | Read Only | Language | |
| Pre Process File | Values List: 0 = None1 = Digital Sign 2 = Encode (with Password) 3 = Encode & Block Printing |
Status | 0 | Select | Read Only | PreProcessFile |
| Pre Process Confirmation UTC | FixDT | 0 | SelectEdit | Read Only | PreProcessConfirmationUtc | |
| Target EMail Address | String | 300 | TextMemo | Read Only | TargetEmailAddress | |
| Message Body Template | String | 40 | Select | Read Only | MessageBodyTemplate | |
| Send from Mailbox | String | 50 | Edit | Read Only | SendFromMailbox | |
| Sent Confirmation UTC | FixDT | 0 | Edit | Read Only | SentConfirmationUtc | |
| First Download UTC | FixDT | 0 | SelectEdit | Read Only | FirstDownloadUtc | |
| Last Download UTC | FixDT | 0 | SelectEdit | Read Only | LastDownloadUtc | |
| Accessibility | Bool | 0 | Select | Read Only | Accessibility | |
| Attachment | Bool | 0 | Select | Read Only | Attachment | |
| Doc ID | String | 10 | Edit | Read Only | DocId |