# bow_contact.postcontact: Bouw7 Package for contact operations that could not be mapped to a table. bow_contact.postcontact: Bouw7 Package for contact operations that could not be mapped to a table. Create or update a contact with the schema.Parameters of Procedure The following parameters can be used to control the behaviour of the procedure `bow_contact.postcontact`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `begin package.procedure(value1, value2, value3); end` on a procedure with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `begin package.procedure(name1 => value1, name3 => value3); end` on the same procedure will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `int64` | ☐ | | The ID of contact. | | `name` | `string` | ☑ | | The contact name. | | `streetName` | `string` | ☐ | | The street name of contact. | | `houseNumber` | `string` | ☐ | | The house number (incl. additions). | | `zipCode` | `string` | ☐ | | The zip-code. | | `city` | `string` | ☐ | | The city name. | | `countryCode` | `string` | ☐ | | An ISO 3166-2 representation of the country. | | `information` | `string` | ☐ | | Additional information about the contact. | | `contactPersonName` | `string` | ☐ | | The name of person to contact. | | `planning` | `string` | ☐ | | The planning text. | | `cocNumber` | `string` | ☐ | | The chamber of commerce number. | | `vatNumber` | `string` | ☐ | | The value added tax number. | | `accountNumber` | `string` | ☐ | | The account number. | | `hourlyRate` | `string` | ☐ | | The hourly rate. | | `sellingHourlyRate` | `string` | ☐ | | The selling hourly rate. | | `agreedHourlyRate` | `string` | ☐ | | The agreed hourly rate. | | `email` | `string` | ☐ | | The email address. | | `phoneNumber` | `string` | ☐ | | The phone number. | | `mobileNumber` | `string` | ☐ | | The mobile phone number. | | `glAccountCodePurchase` | `string` | ☐ | | A default general ledger account code to use for purchase related items. | | `glAccountCodeInvoice` | `string` | ☐ | | A default general ledger account code to use for invoice related items. | | `debtorNumber` | `string` | ☐ | | The debtor number. | | `glnNumber` | `string` | ☐ | | The Global Location Number. | | `id_2` | `int64` | ☐ | | The ID of contact type. | | `name_2` | `string` | ☐ | | The name of contact type. | | `isVatShifted` | `boolean` | ☐ | | Whether VAT is shifted for the contact. | | `nAccountText` | `string` | ☐ | | N-account text. | | `wageComponentPercentage` | `string` | ☐ | | Wage component percentage. | | `gAccountText` | `string` | ☐ | | G-account text. | | `gAccountPercentage` | `string` | ☐ | | G-account percentage. | | `expirationReminder` | `int64` | ☐ | | Expiration reminder days. | | `invoiceMail` | `string` | ☐ | | The invoice mail. | | `invoiceSubject` | `string` | ☐ | | The invoice subject. | | `reminderMail` | `string` | ☐ | | The reminder mail. | | `socialSecurityNumber` | `string` | ☐ | | The Social Security Number. | | `firstReminder` | `int64` | ☐ | | The first reminder. | | `secondReminder` | `int64` | ☐ | | The second reminder. | | `deliveryTicket` | `string` | ☐ | | The delivery ticket. | | `workOutsourcing` | `string` | ☐ | | The work outsourcing. | | `purchaseInvoice` | `string` | ☐ | | The purchase invoice. | | `material` | `string` | ☐ | | The material. | | `equipment` | `string` | ☐ | | The equipment. | | `subcontracting` | `string` | ☐ | | Subcontracting. | | `others` | `string` | ☐ | | Others. | | `invoiceUblVersion` | `string` | ☐ | | The preferred UBL invoice version for this contact. | | `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. |