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

OutstandingDebtorItemsByDate: Yuki Partidas pendientes de deudores por fecha

read only per partition XML

  • Catálogo: Yuki
  • Esquema: Accounting
  • Etiqueta: Partidas pendientes de deudores por fecha

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: OutstandingDebtorItemsByDate
  • Ruta XML: /tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item

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 ``
endDate ``
includeBankTransactions ``
sortOrder `` ContactAsc o ContactDesc o AmountAsc o AmountDesc o DateAsc o DateDesc
startDate ``

Columnas de la Tabla

A continuación se muestran las columnas de la tabla OutstandingDebtorItemsByDate. 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:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/AddressLine_1
ADDRESSLINE2 varchar2 Línea de la Dirección 2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/City
COCNUMBER varchar2 Número CoC /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/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:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/ContactCode
CONTACTID guid ID de contacto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Contact
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Description
DOMAINID varchar2(36) ID de dominio
DOMAINNAME varchar2(240) Nombre de dominio
DUEDATE datetime Fecha de Vencimiento /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/DueDate
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/MailAddressLine_2
MAILCITY varchar2 Ciudad postal /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/MailCity
MAILPOSTCODE varchar2 Código postal del correo /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/MailPostcode
OPENAMOUNT decimal Monto Abierto /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/OpenAmount
ORIGINALAMOUNT decimal Importe original /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/PaymentMethod
POSTCODE varchar2 Código Postal /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Postcode
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Type
TYPEID varchar2 Escriba el id /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/Type/ID
VATNUMBER varchar2 Número VAT /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateResponse/tns:OutstandingDebtorItemsByDateResult/OutstandingDebtorItems/Item/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

Yuki.Accounting.OutstandingDebtorItemsByDate: cambios en los parámetros de las tablas

Los parámetros de tabla de Yuki.Accounting.OutstandingDebtorItemsByDate cambian de administrationID, includeBankTransactions, startDate, endDate a administrationID, includeBankTransactions, startDate, endDate, sortOrder.

  • administrationID, includeBankTransactions, startDate, endDate → administrationID, includeBankTransactions, startDate, endDate, sortOrder
  • importancia 3
Se ha añadido el parámetro sortOrder a Yuki.Accounting.OutstandingDebtorItemsByDate

Opcional.

  • importancia 2

Todos los cambios del conductor, De 26.0 a 27.0