PurchaseInvoiceLines: Bouw7 Purchase Invoice Lines
read only
- Catalog:
Bouw7 - Schema:
Views - Label: Purchase Invoice Lines
Can only retrieve data.
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.
Table Columns
The columns of the table PurchaseInvoiceLines 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 |
|---|---|---|---|---|---|
approval_ |
char |
itgen_bouw7_approval_canapprove | filters on the platform, writable | Whether or not the current authenticated user can approve the approval. | |
approval_ |
datetime |
itgen_bouw7_approval_createdat | filters on the platform, writable | The creation time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_createdby | filters on the platform, writable | The user that created the entity. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_approvaldate | filters on the platform, writable | The date at which the approver denied/approved the approval. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_approvalstatus | filters on the platform, writable | The approval status of this approver. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_comment | filters on the platform, writable | Comment left by the approver. Can be null. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_createdat | filters on the platform, writable | The creation time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_createdby | filters on the platform, writable | The user that created the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_id | filters on the platform, writable | ID of the approver. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_index | filters on the platform, writable | Current index of the approver. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_updatedat | filters on the platform, writable | The last updated time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_updatedby | filters on the platform, writable | The user that last updated the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_currentindex | filters on the platform, writable | The current index of the approver which turn it is to vote on the approval. | |
approval_ |
int64 |
itgen_bouw7_approval_id | filters on the platform, writable | ID of the approval. | |
approval_ |
char |
itgen_bouw7_approval_isapproved | filters on the platform, writable | Whether or not the approval has been approved. | |
approval_ |
datetime |
itgen_bouw7_approval_lastactiondate | filters on the platform, writable | Date of the last action done to this approval. Will be null when no action has been made. | |
approval_ |
datetime |
itgen_bouw7_approval_updatedat | filters on the platform, writable | The last updated time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_updatedby | filters on the platform, writable | The user that last updated the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_workflowid | filters on the platform, writable | The workflow that this approval is based of. | |
book |
int64 |
Book Number | filters on the platform, writable | The booknumber of the purchase invoice. | |
branch_ |
varchar2 |
Branch Code | filters on the platform, writable | The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable | The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable | The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable | A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable | A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable | The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable | A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable | A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable | The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable | The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable | The name of this branch | |
can |
char |
Can Be Deleted | filters on the platform, writable | Whether the invoice can be deleted. | |
can |
char |
Can Be Edited | writable | Whether the line can be edited or removed. | |
can |
char |
Can Book to Exact | filters on the platform, writable | Whether it is allowed to book to Exact. | |
can |
char |
Can Book to Twinfield | filters on the platform, writable | Whether it is allowed to book to Twinfield. | |
can |
char |
Can Use Cost Centre | filters on the platform, writable | True if the user can use cost center functionality. | |
chain |
datetime |
Chain Liability Document Expiration Date | filters on the platform, writable | The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. | |
comments |
varchar2 |
Comments | filters on the platform, writable | Comment associated with the purchase invoice. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable | The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable | The name of contact type. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable | The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable | ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable | Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable | Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable | The phone number of the contact. | |
cost |
varchar2 |
Cost Centre | writable | A reference to the cost center associated with the invoice line. | |
create |
char |
Create Delivery Ticket | filters on the platform, writable | Whether or not to create a delivery ticket. | |
create |
char |
Create Delivery Ticket for Remaining Costs | writable | Whether or not to create a delivery ticket for remaining costs between this line and the delivery ticket | |
create |
char |
itgen_bouw7_createdeliveryticketforremainingcosts_2 | filters on the platform, writable | Whether or not to create a delivery ticket for the remaining costs. | |
created |
datetime |
Created at | writable | The creation time of the entity. | |
created |
datetime |
Created at | filters on the platform, writable | The creation time of the entity. | |
created |
varchar2 |
Created by | writable | The user that created the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable | The user that created the entity. | |
date |
datetime |
Date | filters on the platform, writable | Purchase invoice date. | |
date |
varchar2 |
Date Paid | filters on the platform, writable | Purchase invoice paid date. | |
delivery |
varchar2 |
Delivery Ticket Cost | writable | The costs for this delivery ticket. | |
delivery |
varchar2 |
itgen_bouw7_deliveryticket_cost_2 | filters on the platform, writable | The costs for this delivery ticket. | |
delivery |
int64 |
Delivery Ticket ID | writable | The ID of delivery ticket. | |
delivery |
int64 |
itgen_bouw7_deliveryticket_id_2 | filters on the platform, writable | The ID of delivery ticket. | |
delivery |
varchar2 |
Delivery Ticket Initial Cost | writable | The initial costs for this delivery ticket. | |
delivery |
varchar2 |
itgen_bouw7_deliveryticket_initialcost_2 | filters on the platform, writable | The initial costs for this delivery ticket. | |
delivery |
char |
Delivery Ticket Processed | writable | Whether the delivery ticket has been processed. | |
delivery |
char |
itgen_bouw7_deliveryticket_processed_2 | filters on the platform, writable | Whether the delivery ticket has been processed. | |
delivery |
datetime |
Delivery Ticket Ticket Date | writable | The date for which the delivery ticket were logged. | |
delivery |
datetime |
itgen_bouw7_deliveryticket_ticketdate_2 | filters on the platform, writable | The date for which the delivery ticket were logged. | |
delivery |
varchar2 |
Delivery Ticket Ticket Number | writable | Ticket number of delivery ticket. | |
delivery |
varchar2 |
itgen_bouw7_deliveryticket_ticketnumber_2 | filters on the platform, writable | Ticket number of delivery ticket. | |
description |
varchar2 |
Description | writable | The description of the purchase invoice line. | |
division_ |
varchar2 |
Division Description | filters on the platform, writable | The description of the division. | |
division_ |
varchar2 |
Division Exact Division ID | filters on the platform, writable | The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable | A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable | A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Division ID | filters on the platform, writable | The ID of the division. | |
division_ |
varchar2 |
Division Journal Code | filters on the platform, writable | A default journal code to use for sales related items. | |
division_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable | A default journal code to use for purchase related items. | |
division_ |
varchar2 |
Division Sales Invoice Number Prefix | filters on the platform, writable | The prefix (3 digits) used to generate invoice number range per division. | |
due |
datetime |
Due Date | filters on the platform, writable | Purchase invoice due date. | |
exact |
datetime |
itgen_bouw7_exactfinancialperiod_enddate | filters on the platform, writable | The end date of the exact financial period in Y-m-d format. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_financialperiod | filters on the platform, writable | The period of the exact financial period. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_financialyear | filters on the platform, writable | The year of the exact financial period. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_id | filters on the platform, writable | The ID of the exact financial period. | |
exact |
datetime |
itgen_bouw7_exactfinancialperiod_startdate | filters on the platform, writable | The start date of the exact financial period in Y-m-d format. | |
exact |
varchar2 |
Exact Payment Condition | filters on the platform, writable | The code of the Exact Online payment condition for this purchase invoice. | |
file_ |
datetime |
File Created at | filters on the platform, writable | The creation time of the entity. | |
file_ |
varchar2 |
File Created by | filters on the platform, writable | The user that created the entity. | |
file_ |
varchar2 |
File Extension | filters on the platform, writable | The extension of the file. | |
file_ |
int64 |
File ID | filters on the platform, writable | The ID of this file | |
file_ |
int64 |
File Model ID | filters on the platform, writable | The ID of the associated type. | |
file_ |
varchar2 |
File Model Type | filters on the platform, writable | The category of the file. | |
file_ |
varchar2 |
File Name | filters on the platform, writable | The public name of the file. | |
file_ |
varchar2 |
itgen_bouw7_file_securehash | filters on the platform, writable | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
file_ |
int64 |
File Size | filters on the platform, writable | The size of the file in bytes. | |
file_ |
datetime |
File Updated at | filters on the platform, writable | The last updated time of the entity. | |
file_ |
varchar2 |
File Updated by | filters on the platform, writable | The user that last updated the entity. | |
file_ |
varchar2 |
File URI | filters on the platform, writable | The URI of the file, used to fetch the contents. | |
from |
char |
From Basecone | filters on the platform, writable | Whether the invoice is imported from Basecone. | |
g |
varchar2 |
G-Account Amount | filters on the platform, writable | The g account amount of the purchase invoice. | |
gross |
varchar2 |
Gross Price | writable | The gross price of the purchase invoice line. | |
id |
int64 |
ID | writable | The ID of the purchase invoice line. Must be omitted to create a new purchase invoice line. | |
id_2 |
int64 |
ID | filters on the platform, writable | The ID of purchase invoice. | |
invoice |
varchar2 |
Invoice Number | filters on the platform, writable | The invoice number of purchase invoice. | |
invoice_ |
int64 |
Branch ID | filters on the platform, writable | The ID of the branch. | |
invoice_ |
varchar2 |
Branch Name | filters on the platform, writable | The name of the branch. | |
invoice_ |
datetime |
This field is dynamically hydrated by the 'addChainLiabilityDocumentExpirationDate'-method in the schema factory. | filters on the platform, writable | The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. | |
invoice_ |
varchar2 |
Comment | filters on the platform, writable | A comment placed on this purchase invoice. | |
invoice_ |
datetime |
Created at | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format | |
invoice_ |
int64 |
Created by ID | filters on the platform, writable | The ID of the user. | |
invoice_ |
varchar2 |
Created by User Name | filters on the platform, writable | The username of the user. | |
invoice_ |
varchar2 |
This field is dynamically hydrated by the 'addCurrentApprover'-method in the schema factory. | filters on the platform, writable | The full name of the current approver. | |
invoice_ |
datetime |
Date | filters on the platform, writable | The entry date of this purchase invoice. | |
invoice_ |
varchar2 |
Date Paid | filters on the platform, writable | The date this purchase invoice was paid. | |
invoice_ |
int64 |
Delivery Ticket Booking Status | filters on the platform, writable | The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. | |
invoice_ |
datetime |
Delivery Ticket Date | filters on the platform, writable | The date of the delivery ticket, represented in ATOM-format. | |
invoice_ |
varchar2 |
Delivery Ticket Description | filters on the platform, writable | The description of this delivery ticket. May contain HTML content. | |
invoice_ |
int64 |
Delivery Ticket ID | filters on the platform, writable | The ID of this delivery ticket. | |
invoice_ |
char |
Delivery Ticket Is Processed | filters on the platform, writable | Whether this delivery ticket has been processed. | |
invoice_ |
varchar2 |
Delivery Ticket Number | filters on the platform, writable | The ticket number of this delivery ticket. | |
invoice_ |
varchar2 |
Delivery Ticket Price | filters on the platform, writable | The price of this delivery ticket. | |
invoice_ |
int64 |
Delivery Ticket Purchase Type ID | filters on the platform, writable | The ID of the purchase type of this delivery ticket. | |
invoice_ |
varchar2 |
Delivery Ticket Purchase Type Name | filters on the platform, writable | The name of the purchase type of this delivery ticket. | |
invoice_ |
varchar2 |
Division Description | filters on the platform, writable | The description of the division. | |
invoice_ |
varchar2 |
Division Exact Division ID | filters on the platform, writable | The division ID of an Exact Online environment. | |
invoice_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable | A default general ledger account code to use for sales related items. | |
invoice_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable | A default general ledger account code to use for purchase related items. | |
invoice_ |
int64 |
Division ID | filters on the platform, writable | The ID of the division. | |
invoice_ |
varchar2 |
Division Journal Code | filters on the platform, writable | A default journal code to use for sales related items. | |
invoice_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable | A default journal code to use for purchase related items. | |
invoice_ |
datetime |
Due Date | filters on the platform, writable | The due date of this purchase invoice. | |
invoice_ |
int64 |
Entry Number | filters on the platform, writable | A sequential tracking number assigned to this purchase invoice. Also known as voucher number, serial number or tracking number. | |
invoice_ |
int64 |
ID | filters on the platform, writable | The ID of this purchase invoice. | |
invoice_ |
varchar2 |
Invoice Number | filters on the platform, writable | The invoice number of this purchase invoice. | |
invoice_ |
char |
Is Booked in Exact | filters on the platform, writable | Whether this purchase invoice is booked in Exact. | |
invoice_ |
char |
Is Booked in Twinfield | filters on the platform, writable | Whether this purchase invoice is booked in Twinfield. | |
invoice_ |
char |
itgen_bouw7_ismutable | filters on the platform, writable | Whether the purchase invoice is mutable. | |
invoice_ |
char |
Is Originating from Basecone | filters on the platform, writable | Whether this purchase invoice originates from Basecone. | |
invoice_ |
varchar2 |
Order Number | filters on the platform, writable | The order number associated with this purchase invoice. | |
invoice_ |
varchar2 |
Payment Reference | filters on the platform, writable | The payment reference of this purchase invoice. | |
invoice_ |
int64 |
Project Branch ID | filters on the platform, writable | The ID of the branch of this project. | |
invoice_ |
int64 |
Project Category ID | filters on the platform, writable | The ID of the category of this project. | |
invoice_ |
int64 |
Project Division ID | filters on the platform, writable | The ID of the division of this project. | |
invoice_ |
int64 |
Project ID | filters on the platform, writable | The ID of the project. | |
invoice_ |
varchar2 |
Project Name | filters on the platform, writable | The name of the project. | |
invoice_ |
varchar2 |
Project Number | filters on the platform, writable | The number of the project. | |
invoice_ |
varchar2 |
Project Status | filters on the platform, writable | The name of the current status of this project. | |
invoice_ |
int64 |
Project Status ID | filters on the platform, writable | The ID of the status of this project. | |
invoice_ |
int64 |
Status | filters on the platform, writable | The status of this purchase invoice. (0 = New, 1 = Approved, 2 = Open, 3 = Expired, 4 = Paid, 5 = Declined) | |
invoice_ |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable | The sum of all purchase invoice line subtotals, excluding VAT. | |
invoice_ |
varchar2 |
Supplier Email Address | filters on the platform, writable | The email address of the contact. | |
invoice_ |
int64 |
Supplier ID | filters on the platform, writable | The ID of the contact. | |
invoice_ |
varchar2 |
Supplier Name | filters on the platform, writable | The name of this contact. | |
invoice_ |
varchar2 |
Supplier Type | filters on the platform, writable | The type of this contact. | |
invoice_ |
int64 |
Supplier Type ID | filters on the platform, writable | The type ID of this contact. | |
invoice_ |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable | The sum of all purchase invoice line subtotals, including VAT. | |
invoice_ |
datetime |
Updated At | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format | |
invoice_ |
int64 |
Updated by ID | filters on the platform, writable | The ID of the user. | |
invoice_ |
varchar2 |
Updated by User Name | filters on the platform, writable | The username of the user. | |
invoice_ |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable | The sum of all purchase invoice line VAT totals. | |
is |
char |
Is Booked | filters on the platform, writable | Whether the invoice is already booked. | |
is |
char |
itgen_bouw7_ismutable | filters on the platform, writable | Whether the purchase invoice is mutable. | |
ledger |
varchar2 |
Ledger | writable | A reference to the ledger of the purchase invoice line. | |
model |
int64 |
Model ID | writable | The model ID. Will be the ID of the selected modelType. | |
model |
int64 |
Model Type | writable | The model type, possible options: 1 = SubcontractorContract / 2 = PurchaseOrderContract / 3 = Project. | |
next |
int64 |
Next Purchase Invoice ID | filters on the platform, writable | The ID of the next purchase invoice starting from this purchase invoice. Null when no next purchase invoice available. | |
order |
varchar2 |
Order Number | filters on the platform, writable | The order number of the purchase invoice. | |
payment |
varchar2 |
Payment Reference | filters on the platform, writable | The payment reference of the purchase invoice. | |
previous |
int64 |
Previous Purchase Invoice ID | filters on the platform, writable | The ID of the previous purchase invoice starting from this purchase invoice. Null when no previous purchase invoice available. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable | The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable | The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable | The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable | The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable | The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable | The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable | The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable | The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable | The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable | The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable | The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable | The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable | ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable | Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable | Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable | The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable | The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable | Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable | End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable | The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable | The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable | The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable | The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable | The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable | The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable | The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable | Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable | Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable | The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable | The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable | The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable | Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable | The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable | Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable | The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable | The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable | The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable | The zip code for the project. | |
quantity |
varchar2 |
Quantity | writable | The unit quantity of the purchase invoice line. | |
status |
int64 |
Status | filters on the platform, writable | Status of the purchase invoice. | |
sub |
varchar2 |
Subtotal | writable | The sub-total price of the purchase invoice line. | |
unit |
varchar2 |
Unit Name | writable | The name of the unit in the purchase invoice line. | |
unit |
varchar2 |
Unit Price | writable | The unit price of the purchase invoice line. | |
updated |
datetime |
Updated At | writable | The last updated time of the entity. | |
updated |
datetime |
Updated at | filters on the platform, writable | The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable | The user that last updated the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable | The user that last updated the entity. | |
vat |
int64 |
VAT Tariff ID | writable | The VAT-tariff ID used on the purchase invoice line. | |
vat |
varchar2 |
VAT Tariff Percentage | writable | The VAT-tariff percentage used on the purchase invoice line. Must be set to 0 if VAT is shifted. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: