invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

OutstandingDebtorItemsByDateOutstanding: Yuki itgen_yuki_outstanding_debtor_items_by_date_outstanding

read only per partition XML

  • Catálogo: Yuki
  • Esquema: Accounting
  • Etiqueta: itgen_yuki_outstanding_debtor_items_by_date_outstanding

Los datos de esta tabla están divididos por el valor de la columna COMPANY_CODE.

Solo puede recuperar datos.

Fuente de la API

  • Servicio XML: https://api.yukiworks.nl/ws/Accounting.asmx
  • Tema XML: OutstandingDebtorItemsByDateOutstanding
  • Ruta XML: /tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 31

El resultado se puede almacenar en la Caché del cliente.

Parámetros

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

Columnas de la Tabla

A continuación se muestran las columnas de la tabla OutstandingDebtorItemsByDateOutstanding. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/AddressLine_1
ADDRESSLINE2 varchar2 Línea de la Dirección 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 Número CoC /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/CoCNumber
COMPANY_CODE varchar2(36) Código de partición
COMPANY_NAME varchar2(240) Nombre de partición
CONTACTCODE varchar2 Código de contacto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ContactCode
CONTACTID guid ID de contacto /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 de dominio
DOMAINNAME varchar2(240) Nombre de dominio
DUEDATE datetime Fecha de Vencimiento /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 Ciudad postal /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailCity
MAILPOSTCODE varchar2 Código postal del correo /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailPostcode
OPENAMOUNT decimal Monto Abierto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/OpenAmount
ORIGINALAMOUNT decimal Importe original /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 Código Postal /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 Escriba el id /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Type/ID
VATNUMBER varchar2 Número VAT /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/VATNumber

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

Modificaciones de esta tabla, De 26.0 a 27.0

Se añade la función de tabla Yuki.Accounting.OutstandingDebtorItemsByDateOutstanding

La función de tabla tiene 33 columnas y permite realizar selecciones.

  • importancia 3

Todos los cambios del conductor, De 26.0 a 27.0