invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectTaskAttributes: Visma.net Financials itgen_vnet_projecttaskattributes_plural

read only REST

  • Catalog: VismaNet
  • Schema: Project
  • Label: itgen_vnet_projecttaskattributes_plural

Get a range of Projects - ScreenId=PM301000 The requested page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size

Can only retrieve data.

API Source

  • Endpoint: /v1/project
  • Operation: get /v1/project

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
attributes `` Identifies the attributes
branch `` The branch name.
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
expandAttribute `` Expands project atributes
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
nonProject `` Set to true to return the non-project.
onHold `` If the project is on hold
publicId `` Identifies the Project by its publicId
restrictedEmployee `` ID of the employee where access restrictions apply
restrictedUser `` Id of the odp user where access restrictions apply
startDate `` Project’s start date
status `` Use drop down and select Status. (Values: Planned, Active, Completed, Cancelled, OnHold, PendingApproval)
systemTemplate `` If the project is a template
taskStatus `` Use drop down and select Status. (Values: Planned, Active, Cancelled, Canceled, Completed)
taskVisibleInAp `` If the project task is visible in the Supplier ledger
taskVisibleInAr `` If the project task is visible in the Customer ledger
taskVisibleInCa `` If the project task is visible in the Cash management workspace
taskVisibleInCr `` If the project task is visible in the CRM workspace
taskVisibleInEa `` If the project task is visible in the Expense workspace
taskVisibleInGl `` If the project task is visible in the General ledger workspace
taskVisibleInIn `` If the project task is visible in the Inventory workspace
taskVisibleInPo `` If the project task is visible in the Purchases workspace
taskVisibleInSo `` If the project task is visible in the Sales workspace
taskVisibleInTa `` If the project task is visible in the Time entities workspace
visibleInAP `` If the project is visible in AP

Table Columns

The columns of the table ProjectTaskAttributes 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
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
allocationRule_active char Allocation Rule Active filters on the platform, writable, ::ancestor.::ancestor.allocationRule.active
allocationRule_description varchar2 Allocation Rule Description filters on the platform, writable, ::ancestor.::ancestor.allocationRule.description Click on the magnifier. > The description.
allocationRule_id varchar2 Allocation Rule ID filters on the platform, writable, ::ancestor.::ancestor.allocationRule.id Click on the magnifier. > The identifier.
assets double Assets filters on the platform, writable, ::ancestor.::ancestor.assets The top part > Assest > The actual assets for the project.
autoAllocate char Auto Allocate filters on the platform, writable, ::ancestor.::ancestor.autoAllocate Summary tab > Invoicing and allocation settings section > Run allocation when you release project transactions > A check box that indicates (if selected) that allocation is run automatically during the release of the documents associated with this project.
automaticReleaseAr char Automatic Release AR filters on the platform, writable, ::ancestor.::ancestor.automaticReleaseAr Summary tab > Invoicing and allocation settings section > Automatically release customer documents > A check box that indicates (if selected) that invoice documents are released automatically after the project invoicing is completed.
billingPeriod varchar2 Billing Period filters on the platform, writable, ::ancestor.::ancestor.billingPeriod Summary tab > Invoicing and allocation settings section > Invoicing period > The frequency of invoicing, which can be one of the following options: Week, Month, Quarter, Year, On demand.
billingRule_active char Billing Rule Active filters on the platform, writable, ::ancestor.::ancestor.billingRule.active
billingRule_description varchar2 Billing Rule Description filters on the platform, writable, ::ancestor.::ancestor.billingRule.description Click on the magnifier. > The description.
billingRule_id varchar2 Billing Rule ID filters on the platform, writable, ::ancestor.::ancestor.billingRule.id Click on the magnifier. > The identifier.
branch_name varchar2 Branch Name writable, ::ancestor.branch.name Click the magnifier. > The name.
branch_name_2 varchar2 Branch Name 2 filters on the platform, writable, ::ancestor.::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, ::ancestor.branch.number Click the magnifier. > The identifier.
branch_number_2 varchar2 Branch Number 2 filters on the platform, writable, ::ancestor.::ancestor.branch.number Click the magnifier. > The identifier.
customerLocation_id int32 Customer Location ID filters on the platform, writable, ::ancestor.::ancestor.customerLocation.id Click the magnifier > The identifier
customerLocation_name varchar2 Customer Location Name filters on the platform, writable, ::ancestor.::ancestor.customerLocation.name Click the magnifier > The displayed name
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.::ancestor.customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number filters on the platform, writable, ::ancestor.::ancestor.customer.number
defAccount_description varchar2 Default Account Description filters on the platform, writable, ::ancestor.::ancestor.defAccount.description Name of item/description
defAccount_number varchar2 Default Account Number filters on the platform, writable, ::ancestor.::ancestor.defAccount.number Number of item
defAccount_type varchar2 Default Account Type filters on the platform, writable, ::ancestor.::ancestor.defAccount.type
defAccrualAccount_description varchar2 Default Accrual Account Description filters on the platform, writable, ::ancestor.::ancestor.defAccrualAccount.description Name of item/description
defAccrualAccount_number varchar2 Default Accrual Account Number filters on the platform, writable, ::ancestor.::ancestor.defAccrualAccount.number Number of item
defAccrualAccount_type varchar2 Default Accrual Account Type filters on the platform, writable, ::ancestor.::ancestor.defAccrualAccount.type
defAccrualSub_active char Default Accrual Account Sub Active filters on the platform, writable, ::ancestor.::ancestor.defAccrualSub.active
defAccrualSub_description varchar2 Default Accrual Account Sub Description filters on the platform, writable, ::ancestor.::ancestor.defAccrualSub.description Click on the magnifier. > The description.
defAccrualSub_id varchar2 Default Accrual Account Sub ID filters on the platform, writable, ::ancestor.::ancestor.defAccrualSub.id Click on the magnifier. > The identifier.
defSub_active char Default Sub Active filters on the platform, writable, ::ancestor.::ancestor.defSub.active
defSub_description varchar2 Default Sub Description filters on the platform, writable, ::ancestor.::ancestor.defSub.description Click on the magnifier. > The description.
defSub_id varchar2 Default Sub ID filters on the platform, writable, ::ancestor.::ancestor.defSub.id Click on the magnifier. > The identifier.
description varchar2 Description writable, description Attribute > The description of the attribute.
description_2 varchar2 Description 2 writable, ::ancestor.description Mandatory field: Description > The description of the task.
description_3 varchar2 itgen_vnet_description_3 filters on the platform, writable, ::ancestor.::ancestor.description Mandatory field: The top part > Description* > The description of the project.
endDate datetime End Date writable, ::ancestor.endDate End date > The date when the task was actually finished.
endDate_2 datetime itgen_vnet_enddate_2 filters on the platform, writable, ::ancestor.::ancestor.endDate Summary tab > Project properties section > End date > The date when the project is expected to end.
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.::ancestor.errorInfo
expenses double Expenses filters on the platform, writable, ::ancestor.::ancestor.expenses The top part > Expenses > The total of the current expenses incurred by the project.
hold char Hold filters on the platform, writable, ::ancestor.::ancestor.hold The top part > Hold > A check box that you select to indicate that the project should have the In planning status.
id varchar2 ID writable, id
income double Income filters on the platform, writable, ::ancestor.::ancestor.income The top part > Income > The income expected from the project.
internalID int32 Internal ID filters on the platform, writable, ::ancestor.::ancestor.internalID
lastBillingDate datetime Last Billing Date filters on the platform, writable, ::ancestor.::ancestor.lastBillingDate Summary tab > Invoicing and allocation settings section > Last invoicing date > The date when the latest invoicing was performed for the project.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.::ancestor.lastModifiedDateTime System generated information
liability double Liability filters on the platform, writable, ::ancestor.::ancestor.liability The top part > Liabilities > The actual liabilities for the project.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.::ancestor.metadata.totalCount
nextBillingDate datetime Next Billing Date filters on the platform, writable, ::ancestor.::ancestor.nextBillingDate Summary tab > Invoicing and allocation settings section > Next invoicing date > The date for which the next invoicing is scheduled for the project.
note varchar2 Note filters on the platform, writable, ::ancestor.::ancestor.note The note on the project.
plannedEnd datetime itgen_vnet_plannedend writable, ::ancestor.plannedEnd
plannedStart datetime itgen_vnet_plannedstart writable, ::ancestor.plannedStart
projectID varchar2 Project ID filters on the platform, writable, ::ancestor.::ancestor.projectID Mandatory field: The top part > Project ID* > The unique ID for the project.
projectManager_address_addressId int32 itgen_vnet_projectmanager_address_addressid filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.addressId
projectManager_address_addressLine1 varchar2 itgen_vnet_projectmanager_address_addressline1 filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
projectManager_address_addressLine2 varchar2 itgen_vnet_projectmanager_address_addressline2 filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.addressLine2 Address 2 > The second line of the address.
projectManager_address_addressLine3 varchar2 itgen_vnet_projectmanager_address_addressline3 filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.addressLine3 Address 3 > The third line of the address.
projectManager_address_city varchar2 itgen_vnet_projectmanager_address_city filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.city City > The city.
projectManager_address_country_errorInfo varchar2 itgen_vnet_projectmanager_address_country_errorinfo filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.country.errorInfo
projectManager_address_country_id varchar2 itgen_vnet_projectmanager_address_country_id filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
projectManager_address_country_metadata_maxPageSize int64 itgen_vnet_projectmanager_address_country_metadata_maxpagesize filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.country.metadata.maxPageSize
projectManager_address_country_metadata_totalCount int64 itgen_vnet_projectmanager_address_country_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.country.metadata.totalCount
projectManager_address_country_name varchar2 itgen_vnet_projectmanager_address_country_name filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.country.name Mandatory field: Country name* > The complete name of the country.
projectManager_address_county_id varchar2 itgen_vnet_projectmanager_address_county_id filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.county.id Click the magnifier > The identifier
projectManager_address_county_name varchar2 itgen_vnet_projectmanager_address_county_name filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.county.name Click the magnifier > The displayed name
projectManager_address_postalCode varchar2 itgen_vnet_projectmanager_address_postalcode filters on the platform, writable, ::ancestor.::ancestor.projectManager.address.postalCode Postcode > The postcode.
projectManager_branch_name varchar2 itgen_vnet_projectmanager_branch_name filters on the platform, writable, ::ancestor.::ancestor.projectManager.branch.name Click the magnifier. > The name.
projectManager_branch_number varchar2 itgen_vnet_projectmanager_branch_number filters on the platform, writable, ::ancestor.::ancestor.projectManager.branch.number Click the magnifier. > The identifier.
projectManager_calendarID varchar2 itgen_vnet_projectmanager_calendarid filters on the platform, writable, ::ancestor.::ancestor.projectManager.calendarID
projectManager_contact_attention varchar2 itgen_vnet_projectmanager_contact_attention filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
projectManager_contact_contactId int32 itgen_vnet_projectmanager_contact_contactid filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.contactId
projectManager_contact_email varchar2 itgen_vnet_projectmanager_contact_email filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.email Email > The email address of the customer/supplier/company as a business entity.
projectManager_contact_employeeContact varchar2 itgen_vnet_projectmanager_contact_employeecontact filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.employeeContact Employee contact > The link to the contact record associated with the employee.
projectManager_contact_fax varchar2 itgen_vnet_projectmanager_contact_fax filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.fax Fax > The fax number.
projectManager_contact_firstName varchar2 itgen_vnet_projectmanager_contact_firstname filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.firstName First name > The first name of the employee.
projectManager_contact_lastName varchar2 itgen_vnet_projectmanager_contact_lastname filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.lastName Mandatory field: Last name* > The last name of the employee.
projectManager_contact_midName varchar2 itgen_vnet_projectmanager_contact_midname filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.midName Middle name > The middle name of the employee.
projectManager_contact_name varchar2 itgen_vnet_projectmanager_contact_name filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.name Name > The legal name of to appear on the documents.
projectManager_contact_phone1 varchar2 itgen_vnet_projectmanager_contact_phone1 filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.phone1 Phone 1 > The default phone number.
projectManager_contact_phone2 varchar2 itgen_vnet_projectmanager_contact_phone2 filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.phone2 Phone 2 > An additional phone number.
projectManager_contact_phone3 varchar2 itgen_vnet_projectmanager_contact_phone3 filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.phone3 Phone 3 > An additional phone number of the employee.
projectManager_contact_title varchar2 itgen_vnet_projectmanager_contact_title filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.title Title > The courtesy title to be used for the employee.
projectManager_contact_web varchar2 itgen_vnet_projectmanager_contact_web filters on the platform, writable, ::ancestor.::ancestor.projectManager.contact.web Web > The website of the company, if one exists.
projectManager_department varchar2 Project Manager Department filters on the platform, writable, ::ancestor.::ancestor.projectManager.department Mandatory field: General information tab > Employee section > Department* > The department the employee works for.
projectManager_employeeClass_description varchar2 itgen_vnet_projectmanager_employeeclass_description filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeClass.description Click on the magnifier. > The description.
projectManager_employeeClass_id varchar2 itgen_vnet_projectmanager_employeeclass_id filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeClass.id Click on the magnifier. > The identifier.
projectManager_employeeId int32 Project Manager Employee ID filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeId Mandatory field: The top part > Employee ID* > The unique identifier, which is assigned to the employee in accordance with the configuration of the EMPLOYEE segmented key.
projectManager_employeeLogin varchar2 itgen_vnet_projectmanager_employeelogin filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeLogin
projectManager_employeeName varchar2 Project Manager Employee Name filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeName The top part > Employee name > The name of this employee.
projectManager_employeeNumber varchar2 Project Manager Employee Number filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeNumber General information tab > Employee settings section > Employee ref. no. > A reference number for the employee.
projectManager_employeeUserId guid itgen_vnet_projectmanager_employeeuserid filters on the platform, writable, ::ancestor.::ancestor.projectManager.employeeUserId Employee internal user ID. This is the ID of the user linked to the employee
projectManager_errorInfo varchar2 itgen_vnet_projectmanager_errorinfo filters on the platform, writable, ::ancestor.::ancestor.projectManager.errorInfo
projectManager_lastModifiedDateTime datetime itgen_vnet_projectmanager_lastmodifieddatetime filters on the platform, writable, ::ancestor.::ancestor.projectManager.lastModifiedDateTime
projectManager_metadata_maxPageSize int64 itgen_vnet_projectmanager_metadata_maxpagesize filters on the platform, writable, ::ancestor.::ancestor.projectManager.metadata.maxPageSize
projectManager_metadata_totalCount int64 itgen_vnet_projectmanager_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.projectManager.metadata.totalCount
projectManager_status varchar2 Project Manager Status filters on the platform, writable, ::ancestor.::ancestor.projectManager.status Mandatory field: The top part > Status > The status of the employee. The following options are available: Active, On hold, Hold payments, Inactive, One-time.
projectManager_timeStamp blob itgen_vnet_projectmanager_timestamp filters on the platform, writable, ::ancestor.::ancestor.projectManager.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
publicId guid Public ID filters on the platform, writable, ::ancestor.::ancestor.publicId
rateTable_description varchar2 Rate Table Description writable, ::ancestor.rateTable.description Click on the magnifier. > The description.
rateTable_description_2 varchar2 itgen_vnet_ratetable_description_2 filters on the platform, writable, ::ancestor.::ancestor.rateTable.description Click on the magnifier. > The description.
rateTable_id varchar2 Rate Table ID writable, ::ancestor.rateTable.id Click on the magnifier. > The identifier.
rateTable_id_2 varchar2 itgen_vnet_ratetable_id_2 filters on the platform, writable, ::ancestor.::ancestor.rateTable.id Click on the magnifier. > The identifier.
restrictEmployees char Restrict Employees writable, ::ancestor.restrictEmployees Summary tab > Task properties section > Restrict employees > A check box that indicates (if selected) that only the employees listed on the Employees tab of this window can create activities and documents associated with the current task.
restrictEmployees_2 char itgen_vnet_restrictemployees_2 filters on the platform, writable, ::ancestor.::ancestor.restrictEmployees Summary tab > Project properties section > Restrict employees > A check box that indicates (if selected) that only the employees listed on the Employees tab of this window can create activities and documents associated with the current project.
restrictEquipment char Restrict Equipment filters on the platform, writable, ::ancestor.::ancestor.restrictEquipment
startDate datetime Start Date writable, ::ancestor.startDate Start date > The date when the task was actually started.
startDate_2 datetime itgen_vnet_startdate_2 filters on the platform, writable, ::ancestor.::ancestor.startDate Mandatory field: Summary tab > Project properties section > Start date* > The date when the project starts.
status varchar2 Status writable, ::ancestor.status Mandatory field: Status* > The status of the task, which can be one of the following: In planning, Active, Cancelled, Completed.
status_2 varchar2 itgen_vnet_status_2 filters on the platform, writable, ::ancestor.::ancestor.status The top part > Status > The status of the project, which can be one of the following options: In planning, Active, Completed, Suspended, Cancelled.
systemTemplate char System Template filters on the platform, writable, ::ancestor.::ancestor.systemTemplate
taskId varchar2 Task ID writable, ::ancestor.taskId Mandatory field: > Task ID* > The ID of the task.
template_description varchar2 Template Description filters on the platform, writable, ::ancestor.::ancestor.template.description Name of item/description
template_number varchar2 Template Number filters on the platform, writable, ::ancestor.::ancestor.template.number Number of item
template_status varchar2 Template Status filters on the platform, writable, ::ancestor.::ancestor.template.status
timeStamp blob Timestamp writable, ::ancestor.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
timeStamp_2 blob itgen_vnet_timestamp_2 filters on the platform, writable, ::ancestor.::ancestor.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
value varchar2 Value writable, value Value > The value of the attribute.
visibility_visibleInAp char itgen_vnet_visibility_visibleinap writable, ::ancestor.visibility.visibleInAp Supplier ledger
visibility_visibleInAp_2 char itgen_vnet_visibility_visibleinap_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInAp Supplier ledger
visibility_visibleInAr char itgen_vnet_visibility_visibleinar writable, ::ancestor.visibility.visibleInAr Customer ledger
visibility_visibleInAr_2 char itgen_vnet_visibility_visibleinar_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInAr Customer ledger
visibility_visibleInCa char itgen_vnet_visibility_visibleinca writable, ::ancestor.visibility.visibleInCa Cash management
visibility_visibleInCa_2 char itgen_vnet_visibility_visibleinca_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInCa Cash management
visibility_visibleInCr char itgen_vnet_visibility_visibleincr writable, ::ancestor.visibility.visibleInCr
visibility_visibleInCr_2 char itgen_vnet_visibility_visibleincr_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInCr
visibility_visibleInEa char itgen_vnet_visibility_visibleinea writable, ::ancestor.visibility.visibleInEa Expenses
visibility_visibleInEa_2 char itgen_vnet_visibility_visibleinea_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInEa Expenses
visibility_visibleInGl char itgen_vnet_visibility_visibleingl writable, ::ancestor.visibility.visibleInGl General ledger
visibility_visibleInGl_2 char itgen_vnet_visibility_visibleingl_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInGl General ledger
visibility_visibleInIn char itgen_vnet_visibility_visibleinin writable, ::ancestor.visibility.visibleInIn Inventory
visibility_visibleInIn_2 char itgen_vnet_visibility_visibleinin_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInIn Inventory
visibility_visibleInPo char itgen_vnet_visibility_visibleinpo writable, ::ancestor.visibility.visibleInPo Purchases
visibility_visibleInPo_2 char itgen_vnet_visibility_visibleinpo_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInPo Purchases
visibility_visibleInSo char itgen_vnet_visibility_visibleinso writable, ::ancestor.visibility.visibleInSo Sales
visibility_visibleInSo_2 char itgen_vnet_visibility_visibleinso_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInSo Sales
visibility_visibleInTa char itgen_vnet_visibility_visibleinta writable, ::ancestor.visibility.visibleInTa Time entries
visibility_visibleInTa_2 char itgen_vnet_visibility_visibleinta_2 filters on the platform, writable, ::ancestor.::ancestor.visibility.visibleInTa Time entries

Keys

Key Column Refers to Kind Description
ProjectTaskAttributes_branch_number_fk branch_number Branches.number Key
ProjectTaskAttributes_customer_number_fk customer_number Customers.number Key
ProjectTaskAttributes_defAccount_number_fk defAccount_number Accounts.accountCD Key
ProjectTaskAttributes_defAccrualAccount_number_fk defAccrualAccount_number Accounts.accountCD Key

Release Notes

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