invantive documentation
Invantive Support ForumsLog In / Sign Up

SuppliersAndCustomers: Yuki Suppliers and Customers

read only

  • Catalog: Yuki
  • Schema: Views
  • Label: Suppliers and Customers

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Table Columns

The columns of the table SuppliersAndCustomers 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
ADDRESSLINE1 varchar2 itgen_yuki_addressline1
ADDRESSLINE2 varchar2 Address Line 2
BACKOFFICESTATUS varchar2 itgen_yuki_backofficestatus
CITY varchar2 City
COCNUMBER varchar2 CoC Number
CODE varchar2 Code
COUNTRY varchar2 Country
CREATED datetime itgen_yuki_created
DOMAINNAME varchar2(240) Domain Name
DOMAINNAME2 varchar2(240) Domain Name
EMAILHOME varchar2 itgen_yuki_emailhome
EMAILWORK varchar2 itgen_yuki_emailwork
HID int32 Human ID
ID guid ID
INCOMETAXNUMBER varchar2 itgen_yuki_incometaxnumber
ISCUSTOMER char itgen_yuki_iscustomer
ISSUPPLIER char itgen_yuki_issupplier
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2
MAILCITY varchar2 Mail City
MAILPOSTCODE varchar2 Mail ZIP Code
MAINCONTACTPERSON varchar2 itgen_yuki_maincontactperson
MOBILEHOME varchar2 itgen_yuki_mobilehome
MOBILEWORK varchar2 itgen_yuki_mobilework
MODIFIED datetime itgen_yuki_modified
NAME varchar2 Name
PHONEHOME varchar2 itgen_yuki_phonehome
PHONEWORK varchar2 itgen_yuki_phonework
POSTCODE varchar2 ZIP Code
TAGS varchar2 Tags
TYPE varchar2 Type
VATNUMBER varchar2 VAT Number
WEBSITE varchar2 itgen_yuki_website
domain_ID guid ID
domain_NAME varchar2 Name
domain_STATUS varchar2 itgen_yuki_status
domain_STATUSID varchar2 itgen_yuki_statusid
domain_URL varchar2 URL

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

View Yuki.Views.SuppliersAndCustomers is added

The view has 38 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0