invantive documentation
Invantive Support ForumsLog In / Sign Up

DeliveryTicket_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: DeliveryTicket
  • Label: itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural

Returns a single delivery ticket based on the given ID. Returns a single delivery ticket based on the given ID.

Can only retrieve data.

Summary

Returns a single delivery ticket based on the given ID.

API Source

  • Endpoint: /project/delivery-ticket/{id}
  • Operation: get /project/delivery-ticket/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table DeliveryTicket_ProjectCategoryDivisionSettings are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
branch_code varchar2 Branch Code writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_id int64 Branch ID writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name The name of this branch
canDelete char Can Delete filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canDelete Whether this delivery ticket can be deleted.
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
code varchar2 Code writable, ::ancestor.code The code for the category.
contact_contactType_id int64 Contact Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.name The name of contact type.
contact_email varchar2 Contact Email writable, ::ancestor.::ancestor.contact.email The email address.
contact_email_2 varchar2 itgen_bouw7_contact_email_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_id_2 int64 itgen_bouw7_contact_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_isVatShifted_2 char itgen_bouw7_contact_isvatshifted_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_name_2 varchar2 itgen_bouw7_contact_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contact_phoneNumber_2 varchar2 itgen_bouw7_contact_phonenumber_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contract_contractNumber varchar2 Contract Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contract.contractNumber The number of the contract.
contract_id int64 Contract ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contract.id The ID of the contract.
contract_type int64 Contract Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contract.type Type of the contract.
cost varchar2 Cost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.cost The costs for this delivery ticket.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.description The description of this delivery ticket
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
file_createdAt datetime File Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdAt The creation time of the entity.
file_createdBy varchar2 File Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdBy The user that created the entity.
file_extension varchar2 File Extension filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.extension The extension of the file.
file_id int64 File ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.id The ID of this file
file_modelId int64 File Model ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelId The ID of the associated type.
file_modelType varchar2 File Model Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelType The category of the file.
file_name varchar2 File Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.name The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
file_size int64 File Size filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.size The size of the file in bytes.
file_updatedAt datetime File Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedAt The last updated time of the entity.
file_updatedBy varchar2 File Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedBy The user that last updated the entity.
file_uri varchar2 File URI filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.uri The URI of the file, used to fetch the contents.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
generalCostsOrProfit varchar2 General Costs or Profit writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 General Costs Percentage writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Gross Profit Margin writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
hasBookedPurchaseInvoice char itgen_bouw7_hasbookedpurchaseinvoice filters on the platform, writable, ::ancestor.::ancestor.::ancestor.hasBookedPurchaseInvoice Whether or not the purchase invoice has been booked to a bookkeeping system.
hasImmutablePurchaseInvoice char itgen_bouw7_hasimmutablepurchaseinvoice filters on the platform, writable, ::ancestor.::ancestor.::ancestor.hasImmutablePurchaseInvoice Whether the purchase invoice is mutable.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of the delivery ticket.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
initialCost varchar2 Initial Cost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.initialCost Initial cost of the delivery ticket. The value cannot be modified.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
processed char Processed filters on the platform, writable, ::ancestor.::ancestor.::ancestor.processed Whether this delivery ticket is processed.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.code The code of the security code.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.projectSecurityLink.name The name of the project security link.
purchaseInvoice_bookNumber int64 itgen_bouw7_purchaseinvoice_booknumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.bookNumber The booknumber of the purchase invoice.
purchaseInvoice_branch_code varchar2 itgen_bouw7_purchaseinvoice_branch_code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.code The code for this branch
purchaseInvoice_branch_id int64 itgen_bouw7_purchaseinvoice_branch_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.id The ID of the branch.
purchaseInvoice_branch_name varchar2 itgen_bouw7_purchaseinvoice_branch_name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.name The name of this branch
purchaseInvoice_canBeDeleted char itgen_bouw7_purchaseinvoice_canbedeleted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.canBeDeleted Whether the invoice can be deleted.
purchaseInvoice_comments varchar2 itgen_bouw7_purchaseinvoice_comments filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.comments Comment associated with the purchase invoice.
purchaseInvoice_contact_email varchar2 itgen_bouw7_purchaseinvoice_contact_email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.email The email address.
purchaseInvoice_contact_id int64 itgen_bouw7_purchaseinvoice_contact_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.id ID of contact.
purchaseInvoice_contact_isVatShifted char itgen_bouw7_purchaseinvoice_contact_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.isVatShifted Whether VAT is shifted for the contact.
purchaseInvoice_contact_name varchar2 itgen_bouw7_purchaseinvoice_contact_name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.name Name of contact.
purchaseInvoice_contact_phoneNumber varchar2 itgen_bouw7_purchaseinvoice_contact_phonenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.phoneNumber The phone number of the contact.
purchaseInvoice_createdAt datetime itgen_bouw7_purchaseinvoice_createdat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.createdAt The creation time of the entity.
purchaseInvoice_createdBy varchar2 itgen_bouw7_purchaseinvoice_createdby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.createdBy The user that created the entity.
purchaseInvoice_date datetime itgen_bouw7_purchaseinvoice_date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.date Purchase invoice date.
purchaseInvoice_deliveryTicket_cost varchar2 itgen_bouw7_purchaseinvoice_deliveryticket_cost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.cost The costs for this delivery ticket.
purchaseInvoice_deliveryTicket_id int64 itgen_bouw7_purchaseinvoice_deliveryticket_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.id The ID of delivery ticket.
purchaseInvoice_deliveryTicket_initialCost varchar2 itgen_bouw7_purchaseinvoice_deliveryticket_initialcost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.initialCost The initial costs for this delivery ticket.
purchaseInvoice_deliveryTicket_processed char itgen_bouw7_purchaseinvoice_deliveryticket_processed filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.processed Whether the delivery ticket has been processed.
purchaseInvoice_deliveryTicket_ticketDate datetime itgen_bouw7_purchaseinvoice_deliveryticket_ticketdate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.ticketDate The date for which the delivery ticket were logged.
purchaseInvoice_deliveryTicket_ticketNumber varchar2 itgen_bouw7_purchaseinvoice_deliveryticket_ticketnumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.ticketNumber Ticket number of delivery ticket.
purchaseInvoice_division_description varchar2 itgen_bouw7_purchaseinvoice_division_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.description The description of the division.
purchaseInvoice_division_exactDivisionId varchar2 itgen_bouw7_purchaseinvoice_division_exactdivisionid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.exactDivisionId The division ID of an Exact Online environment.
purchaseInvoice_division_glAccountCode varchar2 itgen_bouw7_purchaseinvoice_division_glaccountcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.glAccountCode A default general ledger account code to use for sales related items.
purchaseInvoice_division_glAccountCodePurchase varchar2 itgen_bouw7_purchaseinvoice_division_glaccountcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
purchaseInvoice_division_id int64 itgen_bouw7_purchaseinvoice_division_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.id The ID of the division.
purchaseInvoice_division_journalCode varchar2 itgen_bouw7_purchaseinvoice_division_journalcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.journalCode A default journal code to use for sales related items.
purchaseInvoice_division_journalCodePurchase varchar2 itgen_bouw7_purchaseinvoice_division_journalcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.journalCodePurchase A default journal code to use for purchase related items.
purchaseInvoice_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_purchaseinvoice_division_salesinvoicenumberprefix filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
purchaseInvoice_id int64 itgen_bouw7_purchaseinvoice_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.id The ID of purchase invoice.
purchaseInvoice_invoiceNumber varchar2 itgen_bouw7_purchaseinvoice_invoicenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.invoiceNumber The invoice number of purchase invoice.
purchaseInvoice_isBooked char itgen_bouw7_purchaseinvoice_isbooked filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.isBooked Whether or not the purchase invoice has been booked to a bookkeeping system.
purchaseInvoice_orderNumber varchar2 itgen_bouw7_purchaseinvoice_ordernumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.orderNumber The order number of the purchase invoice.
purchaseInvoice_project_city varchar2 itgen_bouw7_purchaseinvoice_project_city filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.city The city of the project.
purchaseInvoice_project_createdAt datetime itgen_bouw7_purchaseinvoice_project_createdat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.createdAt The creation time of the entity.
purchaseInvoice_project_createdBy varchar2 itgen_bouw7_purchaseinvoice_project_createdby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.createdBy The user that created the entity.
purchaseInvoice_project_deliveryDate datetime itgen_bouw7_purchaseinvoice_project_deliverydate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.deliveryDate Delivery date for the project.
purchaseInvoice_project_endDate datetime itgen_bouw7_purchaseinvoice_project_enddate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.endDate End date for the project.
purchaseInvoice_project_fullProjectNumber varchar2 itgen_bouw7_purchaseinvoice_project_fullprojectnumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.fullProjectNumber The full project number including year.
purchaseInvoice_project_houseNumber varchar2 itgen_bouw7_purchaseinvoice_project_housenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.houseNumber The house number for the project.
purchaseInvoice_project_id int64 itgen_bouw7_purchaseinvoice_project_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.id The ID of the project.
purchaseInvoice_project_information varchar2 itgen_bouw7_purchaseinvoice_project_information filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.information The information of the project.
purchaseInvoice_project_name varchar2 itgen_bouw7_purchaseinvoice_project_name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.name The name of the project.
purchaseInvoice_project_projectNumber varchar2 itgen_bouw7_purchaseinvoice_project_projectnumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.projectNumber The project number.
purchaseInvoice_project_reference varchar2 itgen_bouw7_purchaseinvoice_project_reference filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.reference The reference of the project.
purchaseInvoice_project_startDate datetime itgen_bouw7_purchaseinvoice_project_startdate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.startDate Start date for the project.
purchaseInvoice_project_streetName varchar2 itgen_bouw7_purchaseinvoice_project_streetname filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.streetName The street name for the project.
purchaseInvoice_project_updatedAt datetime itgen_bouw7_purchaseinvoice_project_updatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.updatedAt The last updated time of the entity.
purchaseInvoice_project_updatedBy varchar2 itgen_bouw7_purchaseinvoice_project_updatedby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.updatedBy The user that last updated the entity.
purchaseInvoice_project_zipCode varchar2 itgen_bouw7_purchaseinvoice_project_zipcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.project.zipCode The zip code for the project.
purchaseInvoice_status int64 itgen_bouw7_purchaseinvoice_status filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.status Status of the purchase invoice.
purchaseInvoice_totalExcludingVat varchar2 itgen_bouw7_purchaseinvoice_totalexcludingvat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.totalExcludingVat Price excluding VAT of the purchase invoice.
purchaseInvoice_totalIncludingVat varchar2 itgen_bouw7_purchaseinvoice_totalincludingvat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.totalIncludingVat Price including VAT of the purchase invoice.
purchaseInvoice_updatedAt datetime itgen_bouw7_purchaseinvoice_updatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.updatedAt The last updated time of the entity.
purchaseInvoice_updatedBy varchar2 itgen_bouw7_purchaseinvoice_updatedby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseInvoice.updatedBy The user that last updated the entity.
purchaseType int64 Purchase Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.purchaseType The purchase type.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
status_closesProject char Status Closes Project writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Status ID writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char Status Invoices Project writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Status Name writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Status Plans Project writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Status Updated at writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
ticketDate datetime Ticket Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.ticketDate The date for which the delivery ticket were logged.
ticketNumber varchar2(256) Ticket Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.ticketNumber Ticket number of the delivery ticket.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: