Cash Flow Entries
API Details
Property | Value |
---|---|
Endpoint | /tablesFinance/cashFlowEntries |
Table name | Cash-flowpost |
Table id | 11030484 |
Table caption | Cash Flow Entries |
Data per company | True |
Group | Finance |
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 | |||||||
volgnummer | Entry No. | Integer | 4 | * | ||||||
projecttype | Project Type | Code | 20 | Empire Projecttype | ||||||
projectnr | Project No. | Code | 20 | Empire Project | ||||||
cluster | Cluster | Code | 20 | Cluster | ||||||
werksoortcode | Work Type Code | Code | 20 | Empire Werksoort | ||||||
bedrag | Amount | Decimal | 12 | |||||||
dueDate | Cash Flow Date | Date | 4 | |||||||
budgetregelnr | Budget Line No. | Integer | 4 | |||||||
werksoortboekingsgroep | Work Type Posting Group | Code | 10 | Werksoortboekingsgroep | ||||||
btWbedrijfsboekingsgroep | VAT Bus. Posting Group | Code | 20 | |||||||
btWproductboekingsgroep | VAT Product posting Group | Code | 20 | |||||||
verkoop | Sales | Boolean | 4 | |||||||
positief | Positive | Boolean | 4 | |||||||
kladblokprojectnr | Draft Project No. | Code | 30 | |||||||
dateClosed | Date Closed | Date | 4 | |||||||
documentType | Document Type | Option | 4 | , Purchase Quote, Purchase Order, Purchase Credit Memo, Posted Purchase Invoice, Posted Purchase Credit Memo, Subsidy, Sales Quote, Sales Order, Sales Credit Memo, Posted Sales Invoice, Posted Sales Credit Memo, Purchase Invoice | ||||||
documentNo | Document No. | Code | 20 | |||||||
expiredAmount | Amount Expired | Decimal | 12 | |||||||
concernsVAT | Concerns VAT | Boolean | 4 | |||||||
glAccountNo | G/L Account No. | Code | 20 | G/L Account | ||||||
componentModelNo | Component Model No. | Code | 20 | |||||||
componentModelName | Component Model Name | Text | 50 | |||||||
projectPhase | Project Phase | Code | 10 | Empire Projectfase | ||||||
buildingBlock | Building Block | Code | 20 | |||||||
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 |