Projectcostshistories |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Projectcostshistories worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
AddToActuals |
boolean |
itgen_ibz_addtoactuals |
☐ |
|
AddToBaselineBudget |
boolean |
itgen_ibz_addtobaselinebudget |
☐ |
|
AddToCurrentBudget |
boolean |
itgen_ibz_addtocurrentbudget |
☐ |
|
Billable |
boolean |
itgen_ibz_billable |
☐ |
|
BookedAmount |
decimal |
itgen_ibz_bookedamount |
☐ |
|
Comment |
string |
itgen_ibz_comment |
☐ |
|
ConfirmedById |
int32 |
itgen_ibz_confirmedbyid |
☐ |
|
CostDate |
datetimeoffset |
itgen_ibz_costdate |
☐ |
|
CostPrice |
decimal |
itgen_ibz_costprice |
☐ |
|
CostSheetId |
int32 |
itgen_ibz_costsheetid |
☐ |
|
CostTypeId |
int32 |
itgen_ibz_costtypeid |
☐ |
|
CreatedByExternal |
boolean |
itgen_ibz_createdbyexternal |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
CustomerId |
int32 |
itgen_ibz_customerid |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DeliveredToCustomer |
decimal |
itgen_ibz_deliveredtocustomer |
☐ |
|
Dep_ApproverId |
int32 |
itgen_ibz_dep_approverid |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
DisapprovalReasonId |
int32 |
itgen_ibz_disapprovalreasonid |
☐ |
|
DisapprovalReasonMotivation |
string |
itgen_ibz_disapprovalreasonmotivation |
☐ |
|
ExternalAccountingCompany |
string |
itgen_ibz_externalaccountingcompany |
☐ |
|
ExternalDocDate |
datetimeoffset |
itgen_ibz_externaldocdate |
☐ |
|
ExternalDocDueDate |
datetimeoffset |
itgen_ibz_externaldocduedate |
☐ |
|
ExternalDocId |
string |
itgen_ibz_externaldocid |
☐ |
|
ExternalDocLineId |
int32 |
itgen_ibz_externaldoclineid |
☐ |
|
Hyperlink |
string |
itgen_ibz_hyperlink |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InvoiceId |
string |
itgen_ibz_invoiceid |
☐ |
|
InvoiceUponDelivery |
boolean |
itgen_ibz_invoiceupondelivery |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
ItemCompositionId |
int32 |
itgen_ibz_itemcompositionid |
☐ |
|
ItemId |
int32 |
itgen_ibz_itemid |
☐ |
|
LastExportDateTime |
datetimeoffset |
itgen_ibz_lastexportdatetime |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
OnHold |
boolean |
itgen_ibz_onhold |
☐ |
|
PartialDeliveryAllowed |
boolean |
itgen_ibz_partialdeliveryallowed |
☐ |
|
PM_ApproverId |
int32 |
itgen_ibz_pm_approverid |
☐ |
|
Postpone |
boolean |
itgen_ibz_postpone |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceApprovalHeaderId |
int32 |
itgen_ibz_projectinvoiceapprovalheaderid |
☐ |
|
ProjectInvoiceId |
int32 |
itgen_ibz_projectinvoiceid |
☐ |
|
ProjectInvoiceLineId |
int32 |
itgen_ibz_projectinvoicelineid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
ProjectItemToProduceId |
int32 |
itgen_ibz_projectitemtoproduceid |
☐ |
|
PS_ApproverId |
int32 |
itgen_ibz_ps_approverid |
☐ |
|
Purchase |
boolean |
itgen_ibz_purchase |
☐ |
|
PurchaseComment |
string |
itgen_ibz_purchasecomment |
☐ |
|
PurchaseInvoiceId |
int32 |
itgen_ibz_purchaseinvoiceid |
☐ |
|
Quantity |
decimal |
itgen_ibz_quantity |
☐ |
|
Reimbursable |
boolean |
itgen_ibz_reimbursable |
☐ |
|
ReimbursalApproverId |
int32 |
itgen_ibz_reimbursalapproverid |
☐ |
|
ReimbursedAmount |
decimal |
itgen_ibz_reimbursedamount |
☐ |
|
ReimbursedOn |
datetimeoffset |
itgen_ibz_reimbursedon |
☐ |
|
ReimburseStatusId |
int32 |
itgen_ibz_reimbursestatusid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
ResourceId |
int32 |
itgen_ibz_resourceid |
☐ |
|
SalesPrice |
decimal |
itgen_ibz_salesprice |
☐ |
|
SalesQuoteLine_Id |
int32 |
itgen_ibz_salesquoteline_id |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
Status |
int32 |
itgen_ibz_status |
☐ |
|
SupplyClosed |
boolean |
itgen_ibz_supplyclosed |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TransferToProjectId |
int32 |
itgen_ibz_transfertoprojectid |
☐ |
|
UnitTypeId |
int32 |
itgen_ibz_unittypeid |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model