# bow_organization.postbranch: Bouw7 Package for organization operations that could not be mapped to a table. bow_organization.postbranch: Bouw7 Package for organization operations that could not be mapped to a table. Create or update a branch with the schema.Parameters of Procedure The following parameters can be used to control the behaviour of the procedure `bow_organization.postbranch`. 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` | ☐ | | ID of the branch. | | `useOrganizationInfo` | `boolean` | ☐ | | If organization information should be used instead of branch information. | | `name` | `string` | ☑ | | Name of the branch. | | `code` | `string` | ☐ | | The code of the branch. | | `companyName` | `string` | ☐ | | The company name of the branch. | | `address` | `string` | ☐ | | Address of the branch. | | `zipCode` | `string` | ☐ | | ZIP code of the branch. | | `city` | `string` | ☐ | | City of the branch. | | `countryCode` | `string` | ☐ | | An ISO 3166-2 representation of the country. | | `phoneNumber` | `string` | ☐ | | Phone number of the branch. | | `email` | `string` | ☐ | | Email of the branch. | | `website` | `string` | ☐ | | The website of the branch. | | `cocNumber` | `string` | ☐ | | The COC number. | | `vatNumber` | `string` | ☐ | | VAT number of the branch. | | `accountNumber` | `string` | ☐ | | Account number of the branch. | | `afasAdministration` | `string` | ☐ | | Afas administration code of the branch. | | `afasProjectLeader` | `string` | ☐ | | Afas project leader of the branch. | | `wageComponentPercentage` | `string` | ☐ | | The wage component percentage of the branch. | | `gAccountPercentage` | `string` | ☐ | | The g account percentage of the branch. | | `gAccountText` | `string` | ☐ | | The g account text of the branch. | | `nAccountText` | `string` | ☐ | | The n account text of the branch. | | `id_2` | `int64` | ☐ | | The ID of this file | | `modelType` | `string` | ☐ | | The category of the file. | | `modelId` | `int64` | ☐ | | The ID of the associated type. | | `name_2` | `string` | ☐ | | The public name of the file. | | `size` | `int64` | ☐ | | The size of the file in bytes. | | `extension` | `string` | ☐ | | The extension of the file. | | `uri` | `string` | ☐ | | The URI of the file, used to fetch the contents. | | `secureHash` | `string` | ☐ | | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | | `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. | | `id_3` | `int64` | ☐ | | The ID of the division this object is associated with. | | `description` | `string` | ☐ | | The description of the division this object is associated with. | | `glAccountCode` | `string` | ☐ | | A general ledger account code to use for sales related items. | | `glAccountCodePurchase` | `string` | ☐ | | A general ledger account code to use for purchase related items. | | `journalCode` | `string` | ☐ | | A journal code to use for sales related items. | | `journalCodePurchase` | `string` | ☐ | | A journal code to use for purchase related items. | | `journalCodeWorkInProgress` | `string` | ☐ | | A default journal code to use for work in progress related items. | | `exactPaymentConditionSales` | `string` | ☐ | | A default payment condition to use for sales related items. | | `exactPaymentConditionPurchase` | `string` | ☐ | | A default payment condition to use for purchase related items. | | `workInProgressSettings_id` | `int64` | ☐ | | The ID of the work in progress settings. | | `workInProgressSettings_glAccountCodeSales` | `string` | ☐ | | A general ledger account code to use for sales related items. | | `workInProgressSettings_glAccountCodeSalesDebit` | `string` | ☐ | | A general ledger account code to use for sales debit related items. | | `workInProgressSettings_glAccountCodeSalesClosing` | `string` | ☐ | | A general ledger account code to use for sales closing related items. | | `workInProgressSettings_glAccountCodePurchase` | `string` | ☐ | | A general ledger account code to use for purchase related items. | | `workInProgressSettings_glAccountCodePurchaseDebit` | `string` | ☐ | | A general ledger account code to use for purchase debit related items. | | `workInProgressSettings_glAccountCodePurchaseClosing` | `string` | ☐ | | A general ledger account code to use for purchase closing related items. | | `workInProgressSettings_glAccountCodeHours` | `string` | ☐ | | A general ledger account code to use for hours related items. | | `workInProgressSettings_glAccountCodeHoursDebit` | `string` | ☐ | | A general ledger account code to use for hours debit related items. | | `workInProgressSettings_glAccountCodeHoursClosing` | `string` | ☐ | | A general ledger account code to use for hours closing related items. | | `workInProgressSettings_glAccountCodeMaterial` | `string` | ☐ | | A general ledger account code to use for material related items. | | `workInProgressSettings_glAccountCodeMaterialDebit` | `string` | ☐ | | A general ledger account code to use for material debit related items. | | `workInProgressSettings_glAccountCodeMaterialClosing` | `string` | ☐ | | A general ledger account code to use for material closing related items. | | `workInProgressSettings_glAccountCodeEquipment` | `string` | ☐ | | A general ledger account code to use for equipment related items. | | `workInProgressSettings_glAccountCodeEquipmentDebit` | `string` | ☐ | | A general ledger account code to use for equipment debit related items. | | `workInProgressSettings_glAccountCodeEquipmentClosing` | `string` | ☐ | | A general ledger account code to use for equipment closing related items. | | `workInProgressSettings_glAccountCodeWaste` | `string` | ☐ | | A general ledger account code to use for waste related items. | | `workInProgressSettings_glAccountCodeWasteDebit` | `string` | ☐ | | A general ledger account code to use for waste debit related items. | | `workInProgressSettings_glAccountCodeWasteClosing` | `string` | ☐ | | A general ledger account code to use for waste closing related items. | | `workInProgressSettings_costCenterSales` | `string` | ☐ | | A cost center to use for sales related items. | | `workInProgressSettings_costCenterSalesDebit` | `string` | ☐ | | A cost center to use for sales debit related items. | | `workInProgressSettings_costCenterPurchase` | `string` | ☐ | | A cost center to use for purchase related items. | | `workInProgressSettings_costCenterPurchaseDebit` | `string` | ☐ | | A cost center to use for purchase debit related items. | | `workInProgressSettings_costCenterHours` | `string` | ☐ | | A cost center to use for hours related items. | | `workInProgressSettings_costCenterHoursDebit` | `string` | ☐ | | A cost center to use for hours debit related items. | | `workInProgressSettings_costCenterMaterial` | `string` | ☐ | | A cost center to use for material related items. | | `workInProgressSettings_costCenterMaterialDebit` | `string` | ☐ | | A cost center to use for material debit related items. | | `workInProgressSettings_costCenterEquipment` | `string` | ☐ | | A cost center to use for equipment related items. | | `workInProgressSettings_costCenterEquipmentDebit` | `string` | ☐ | | A cost center to use for equipment debit related items. | | `workInProgressSettings_costCenterWaste` | `string` | ☐ | | A cost center to use for waste related items. | | `workInProgressSettings_costCenterWasteDebit` | `string` | ☐ | | A cost center to use for waste debit related items. | | `invoiceFooter` | `string` | ☐ | | The invoice footer text. | | `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. | | `p_addAsDepartmentBranch` | `int64` | ☐ | | Option to add branch automatically to department as allowed branch. |