invantive documentation
Invantive Support ForumsLog In / Sign Up

ContactDefaultValuesByContactId: Yuki Contact Default Values by Contact ID

read only per partition XML

  • Catalog: Yuki
  • Schema: AccountingInfo
  • Label: Contact Default Values by Contact ID

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: GetContactDefaultValues
  • XML path: /tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue

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 ``
contactID ``

Table Columns

The columns of the table ContactDefaultValuesByContactId 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(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CREATED datetime itgen_yuki_created /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:Created
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
INPUTAMOUNT varchar2 itgen_yuki_inputamount /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:Amount
INPUTCONTACTNAME varchar2 itgen_yuki_inputcontactname /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:ContactName
INPUTCURRENCY varchar2 itgen_yuki_inputcurrency /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:Currency
INPUTDOCUMENTTYPE varchar2 itgen_yuki_inputdocumenttype /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:DocumentType
INPUTENDDATE varchar2 itgen_yuki_inputenddate /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:EndDate
INPUTPRIORITY int32 itgen_yuki_inputpriority /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:Priority
INPUTSTARTDATE varchar2 itgen_yuki_inputstartdate /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:StartDate
INPUTTEXT varchar2 itgen_yuki_inputtext /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:InputFields/tns:Text
OUTPUTGLACCOUNT varchar2 itgen_yuki_outputglaccount /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:OutputFields/tns:GLAccount
OUTPUTPAYMENTMETHOD varchar2 itgen_yuki_outputpaymentmethod /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:OutputFields/tns:PaymentMethod
OUTPUTPAYMENTTERM varchar2 itgen_yuki_outputpaymentterm /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:OutputFields/tns:PaymentTerm
OUTPUTVATCODE varchar2 itgen_yuki_outputvatcode /soap11:Envelope/soap11:Body/tns:GetContactDefaultValuesResponse/tns:GetContactDefaultValuesResult/tns:ContactDefaultValues/tns:DefaultValues/tns:DefaultValue/tns:OutputFields/tns:VATCode

Release Notes

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

Changes of This Table, 26.0 to 27.0

Table function Yuki.AccountingInfo.ContactDefaultValuesByContactId is added

The table function has 17 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0