invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectDetails: Yuki Project Details

read only per partition XML

  • Catalog: Yuki
  • Schema: AccountingInfo
  • Label: Project Details

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/AccountingInfo.asmx
  • XML topic: GetProjectsAndID
  • XML path: /tns:GetProjectsAndIDResult/tns:Project

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
administrationID ``
searchOption `` All or Company or Code or Description
searchValue ``

Table Columns

The columns of the table ProjectDetails 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
BUDGETPURCHASE decimal Budget Purchase /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:budgetPurchase
BUDGETSALES decimal Budget Sales /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:budgetSales
CODE varchar2 Code /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:code
COMPANY varchar2 Company /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:company
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CONTACT varchar2 Contact /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:contact
CONTACTID guid Contact ID /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:contactID
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:description
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
ENDDATE datetime End Date /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:endDate
HID int32 Human ID /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:HID
ID varchar2 ID /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:id
STARTDATE datetime Start Date /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:startDate
TAGS varchar2 Tags /soap11:Envelope/soap11:Body/tns:GetProjectsAndIDResponse/tns:GetProjectsAndIDResult/tns:Project/tns:tags

Release Notes

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