invantive documentation
Forum di supporto InvantiveAccedi / Registrati

OutstandingDebtorItemsByDateOutstanding: Yuki itgen_yuki_outstanding_debtor_items_by_date_outstanding

read only per partition XML

  • Catalogo: Yuki
  • Schema: Accounting
  • Etichetta: itgen_yuki_outstanding_debtor_items_by_date_outstanding

I dati in questa tabella sono partizionati per valore della colonna COMPANY_CODE.

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Servizio XML: https://api.yukiworks.nl/ws/Accounting.asmx
  • Argomento XML: OutstandingDebtorItemsByDateOutstanding
  • Percorso XML: /tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 31

Il risultato può essere memorizzato nella memoria cache sul client.

Parametri

Name Tipo di dati Required Default Documentation
administrationID ``
dateOutstanding ``
includeBankTransactions ``
sortOrder `` ContactAsc o ContactDesc o AmountAsc o AmountDesc o DateAsc o DateDesc

Colonne della tabella

Di seguito sono riportate le colonne della tabella OutstandingDebtorItemsByDateOutstanding. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/AddressLine_1
ADDRESSLINE2 varchar2 Indirizzo 2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/City
COCNUMBER varchar2 Numero CoC /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/CoCNumber
COMPANY_CODE varchar2(36) Codice di partizione
COMPANY_NAME varchar2(240) Nome della partizione
CONTACTCODE varchar2 Codice di contatto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ContactCode
CONTACTID guid ID contatto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Contact
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Description
DOMAINID varchar2(36) ID dominio
DOMAINNAME varchar2(240) Nome di dominio
DUEDATE datetime Scadenza /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/DueDate
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/EmailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/EmailWork
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailAddressLine_2
MAILCITY varchar2 Città di posta /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailCity
MAILPOSTCODE varchar2 Codice postale /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailPostcode
OPENAMOUNT decimal Importo aperto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/OpenAmount
ORIGINALAMOUNT decimal Importo originario /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PaymentMethod
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PhoneWork
POSTCODE varchar2 Codice postale /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Postcode
RECIPIENTEMAIL varchar2 itgen_yuki_recipientemail /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/RecipientEmail
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Type
TYPEID varchar2 Tipo di ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Type/ID
VATNUMBER varchar2 Numero di partita IVA /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/VATNumber

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

Modifiche apportate a questa tabella, da 26.0 a 27.0

È stata aggiunta la funzione tabella Yuki.Accounting.OutstandingDebtorItemsByDateOutstanding

La funzione tabella presenta le colonne 33 e supporta l’operazione SELECT.

  • importanza 3

Tutte le sostituzioni del conducente, da 26.0 a 27.0