bow_contract.postsubcontractor: Bouw7 Package for contract operations that could not be mapped to a table.

id

int64

☐

The ID of the subcontractor contract.

id_2

int64

☐

ID of contact.

name

string

☐

Name of contact.

email

string

☐

The email address.

phoneNumber

string

☐

The phone number of the contact.

isVatShifted

boolean

☐

Whether VAT is shifted for the contact.

contactType_id

int64

☐

The ID of contact type.

contactType_name

string

☐

The name of contact type.

status

int64

☑

Status of the contract.

type

int64

☑

Type of the contract.

startDate

datetime

☐

The starting date of the subcontractor contract.

startDateText

string

☐

The starting date text of the subcontractor contract.

expectedCompletionDate

datetime

☐

The expected completion date of the subcontractor contract.

expectedCompletionDateText

string

☐

The expected completion date text of the subcontractor contract.

calledReceipts

int64

☐

The amount of called receipt documents.

logEntries

int64

☐

The amount of log entries.

id_3

int64

☐

ID of the approval.

currentIndex

int64

☐

The current index of the approver which turn it is to vote on the approval.

workflowId

int64

☐

The workflow that this approval is based of.

currentApprover_id

int64

☐

ID of the approver.

currentApprover_index

int64

☐

Current index of the approver.

currentApprover_employee_id

int64

☐

ID of the employee.

currentApprover_employee_firstName

string

☐

First name of the employee.

currentApprover_employee_lastName

string

☐

Last name of the employee.

currentApprover_approvalStatus

int64

☐

The approval status of this approver.

currentApprover_approvalDate

datetime

☐

The date at which the approver denied/approved the approval.

currentApprover_comment

string

☐

Comment left by the approver. Can be null.

currentApprover_createdAt

datetime

☐

The creation time of the entity.

currentApprover_createdBy

string

☐

The user that created the entity.

currentApprover_updatedAt

datetime

☐

The last updated time of the entity.

currentApprover_updatedBy

string

☐

The user that last updated the entity.

lastActionDate

datetime

☐

Date of the last action done to this approval. Will be null when no action has been made.

isApproved

boolean

☐

Whether or not the approval has been approved.

canApprove

boolean

☐

Whether or not the current authenticated user can approve the approval.

createdAt

datetime

☐

The creation time of the entity.

createdBy

string

☐

The user that created the entity.

updatedAt

datetime

☐

The last updated time of the entity.

updatedBy

string

☐

The user that last updated the entity.

oneTwoBuildCommunicationId

int64

☐

The ID used by 12Build for this contract

id_4

int64

☐

The ID of the project.

projectNumber

string

☐

The project number.

fullProjectNumber

string

☐

The full project number including year.

name_2

string

☐

The name of the project.

streetName

string

☐

The street name for the project.

houseNumber

string

☐

The house number for the project.

zipCode

string

☐

The zip code for the project.

city

string

☐

The city of the project.

information

string

☐

The information of the project.

reference

string

☐

The reference of the project.

startDate_2

datetime

☐

Start date for the project.

endDate

datetime

☐

End date for the project.

deliveryDate

datetime

☐

Delivery date for the project.

contact_id

int64

☐

ID of contact.

contact_name

string

☐

Name of contact.

contact_email

string

☐

The email address.

contact_phoneNumber

string

☐

The phone number of the contact.

contact_isVatShifted

boolean

☐

Whether VAT is shifted for the contact.

contact_contactType_id

int64

☐

The ID of contact type.

contact_contactType_name

string

☐

The name of contact type.

category_id

int64

☐

The ID of the category.

category_name

string

☐

The name of the category.

category_code

string

☐

The code for the category.

category_generalCostsPercentage

string

☐

The general costs percentage for the category.

category_generalCostsOrProfit

string

☐

The general costs or profit for the category.

category_grossProfitMargin

string

☐

The gross profit margin for the category.

category_createdAt

datetime

☐

The creation time of the entity.

category_createdBy

string

☐

The user that created the entity.

category_updatedAt

datetime

☐

The last updated time of the entity.

category_updatedBy

string

☐

The user that last updated the entity.

status_2_id

int64

☐

The ID of the status.

status_2_name

string

☐

The name of the status.

status_2_closesProject

boolean

☐

Whether or not this status closes a project.

status_2_invoicesProject

boolean

☐

Whether or not this status invoices a project.

status_2_plansProject

boolean

☐

Whether or not this status plans a project.

status_2_createdAt

datetime

☐

The creation time of the entity.

status_2_createdBy

string

☐

The user that created the entity.

status_2_updatedAt

datetime

☐

The last updated time of the entity.

status_2_updatedBy

string

☐

The user that last updated the entity.

branch_id

int64

☐

The ID of the branch.

branch_name

string

☐

The name of this branch

branch_code

string

☐

The code for this branch

branch_division_id

int64

☐

The ID of the division.

branch_division_description

string

☐

The description of the division.

branch_division_exactDivisionId

string

☐

The division ID of an Exact Online environment.

branch_division_glAccountCode

string

☐

A default general ledger account code to use for sales related items.

branch_division_glAccountCodePurchase

string

☐

A default general ledger account code to use for purchase related items.

branch_division_journalCode

string

☐

A default journal code to use for sales related items.

branch_division_journalCodePurchase

string

☐

A default journal code to use for purchase related items.

branch_division_salesInvoiceNumberPrefix

string

☐

The prefix (3 digits) used to generate invoice number range per division.

createdAt_2

datetime

☐

The creation time of the entity.

createdBy_2

string

☐

The user that created the entity.

updatedAt_2

datetime

☐

The last updated time of the entity.

updatedBy_2

string

☐

The user that last updated the entity.

number

string

☐

Number of the contract.

contractNumber

string

☐

The contract number of the contract.

name1

string

☐

The name of the contract.

description

string

☐

The description of the contract.

internalNote

string

☐

Internal note about the contract.

paymentAgreement

string

☐

The payment agreement of the contract.

id_5

int64

☐

The ID of delivery ticket.

ticketNumber

string

☐

Ticket number of delivery ticket.

ticketDate

datetime

☐

The date for which the delivery ticket were logged.

cost

string

☐

The costs for this delivery ticket.

processed

boolean

☐

Whether the delivery ticket has been processed.

initialCost

string

☐

The initial costs for this delivery ticket.

id_6

int64

☐

The unique identifier of the project security link.

name_3

string

☐

The name of the project security link.

code

string

☐

The code of the security code.

cost1

string

☑

The cost of the contract.

mailSent

boolean

☐

Flag to indicate if mail was sent.

mailSentAt

string

☐

The date the contract was sent.

mailSentBy

string

☐

The user that sent the email.

acceptedAt

string

☐

Datetime when contract was accepted.

deniedAt

string

☐

Datetime when contract was denied.

language

string

☐

The locale used by this contract, e.g.: nl-NL.

createDeliveryTicket

boolean

☐

Whether or not to create a delivery ticket.

createdAt1

datetime

☐

The creation time of the entity.

createdBy1

string

☐

The user that created the entity.

updatedAt1

datetime

☐

The last updated time of the entity.

updatedBy1

string

☐

The user that last updated the entity.