invantive documentation
Invantive Support ForumsLog In / Sign Up

ModifiedDocumentsByFolderId: Yuki itgen_yuki_modified_documents_by_folder_id

read only XML

  • Catalog: Yuki
  • Schema: Archive
  • Label: itgen_yuki_modified_documents_by_folder_id

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/Archive.asmx
  • XML topic: ModifiedDocumentsInFolder
  • XML path: /tns:ModifiedDocumentsInFolderResult/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
folderID ``
modifiedSince ``
sortOrder `` CreatedDesc or CreatedAsc or ModifiedDesc or ModifiedAsc or DocumentDateDesc or DocumentDateAsc or ContactNameAsc or ContactNameDesc

Table Columns

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

The table function has 23 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0