invantive documentation
Invantive Support ForumsLog In / Sign Up

DocumentsByType: Yuki itgen_yuki_documents_by_type

read only XML

  • Catalog: Yuki
  • Schema: Archive
  • Label: itgen_yuki_documents_by_type

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/Archive.asmx
  • XML topic: DocumentsByType
  • XML path: /tns:DocumentsByTypeResult/Documents/Document

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
documentType ``
endDate ``
sortOrder `` CreatedDesc or CreatedAsc or ModifiedDesc or ModifiedAsc or DocumentDateDesc or DocumentDateAsc or ContactNameAsc or ContactNameDesc
startDate ``

Table Columns

The columns of the table DocumentsByType 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
AMOUNT decimal Amount /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Amount
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/ContactName
CONTENTTYPE varchar2 itgen_yuki_contenttype /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/ContentType
CREATED datetime itgen_yuki_created /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Created
CREATOR varchar2 itgen_yuki_creator /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Creator
DOCUMENTDATE datetime itgen_yuki_documentdate /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/DocumentDate
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
FILENAME varchar2 File Name /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/FileName
FILESIZE int32 itgen_yuki_filesize /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/FileSize
FOLDERDESCRIPTION varchar2 itgen_yuki_folderdescription /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Folder
FOLDERID varchar2 itgen_yuki_folderid /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Folder/ID
ID varchar2 ID /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/ID
MODIFIED datetime itgen_yuki_modified /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Modified
MODIFIER varchar2 itgen_yuki_modifier /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Modifier
PAYMENTID varchar2 itgen_yuki_paymentid /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/PaymentID
PAYMENTREFERENCE varchar2 itgen_yuki_paymentreference /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/PaymentReference
SUBJECT varchar2 itgen_yuki_subject /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Subject
TABDESCRIPTION varchar2 itgen_yuki_tabdescription /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Tab
TABID varchar2 itgen_yuki_tabid /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Tab/ID
TYPE varchar2 Type /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/Type
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/TypeDescription
VATAMOUNT decimal itgen_yuki_vatamount /soap11:Envelope/soap11:Body/tns:DocumentsByTypeResponse/tns:DocumentsByTypeResult/Documents/Document/VATAmount

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.Archive.DocumentsByType is added

The table function has 23 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0