Prol Run
API Details
Property | Value |
---|---|
Endpoint | /tablesHousing/prolongationRuns |
Table name | Prol Run |
Table id | 11024148 |
Table caption | Prol Run |
Data per company | True |
Group | Housing |
Schema
Properties
Property | Table Fieldname | Type | Max.Length | Key | Options | Table relation | Version introduced | Version removed | Obsolete state | Obsolete reason |
---|---|---|---|---|---|---|---|---|---|---|
id | System Id | GUID | 16 | |||||||
entryNo | Entry No. | Integer | 4 | * | ||||||
type | Type | Option | 4 | , Backdated, Offer | ||||||
dateTo | Date To | Date | 4 | |||||||
postingDate | Posting Date | Date | 4 | |||||||
documentDate | Document Date | Date | 4 | |||||||
status | Status | Option | 4 | Created, Queued, Contract Errors, Contract Checked, Prol Finished, Document Errors, Documents Checked, Posting Finished, Cancelled | ||||||
prolYear | Prol Year | Integer | 4 | |||||||
prolMonth | Prol Month | Integer | 4 | |||||||
prolPeriodName | Prol Period Name | Text | 50 | |||||||
longLease | LongLease | Boolean | 4 | |||||||
rent | Rent | Boolean | 4 | |||||||
allowance | Allowance | Boolean | 4 | |||||||
allowanceDueDate | Allowance Due Date | Date | 4 | |||||||
immediatePosting | Immediate Posting | Boolean | 4 | |||||||
userID | User ID | Code | 50 | |||||||
dateCreated | Date Created | DateTime | 8 | |||||||
dateQueued | Date Queued | DateTime | 8 | |||||||
currentActivity | Current Activity | Option | 4 | Idle, In Process, In Process (Posting), Contract Check, Document Check | ||||||
clusterFilter | Cluster Filter | Code | 250 | Cluster | ||||||
ogeFilter | OGE Filter | Code | 250 | |||||||
customerFilter | Customer Filter | Code | 20 | |||||||
noOfInvoices | No. of Invoices | Integer | 4 | |||||||
noOfContracts | No. of Contracts | Integer | 4 | |||||||
noOfOGEs | Number of Filtered OGE's | Integer | 4 | |||||||
startTime | Start Time | DateTime | 8 | |||||||
endTime | End Time | DateTime | 8 | |||||||
startTimePosting | Start Time Posting | DateTime | 8 | |||||||
endTimePosting | End Time Posting | DateTime | 8 | |||||||
startTimeContractCheck | Start Time Contract Check | DateTime | 8 | |||||||
endTimeContractCheck | End Time Contract Check | DateTime | 8 | |||||||
startTimeDocumentCheck | Start Time Document Check | DateTime | 8 | |||||||
endTimeDocumentCheck | End Time Document Check | DateTime | 8 | |||||||
startDateTimeSchedule | Start Date/Time Schedule | DateTime | 8 | |||||||
scheduled | Scheduled | Boolean | 4 | |||||||
updateAddress | UpdateAddress | Boolean | 4 | |||||||
serverInstanceID | Server Instance ID | Integer | 4 | |||||||
sessionID | Session ID | Integer | 4 | |||||||
onlyContractCheck | Only Contract Check | Boolean | 4 | |||||||
systemId | System ID | GUID | 16 | |||||||
systemCreatedAt | Created At | DateTime | 8 | |||||||
systemCreatedBy | Created By | GUID | 16 | User | ||||||
systemModifiedAt | Modified At | DateTime | 8 | |||||||
systemModifiedBy | Modified By | GUID | 16 | User | ||||||
lastModifiedDateTime | Last Modified Date Time | DateTime | 8 |