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

OutstandingCreditorItemsWithPaymentReference: Yuki itgen_yuki_outstanding_creditor_items_with_payment_reference

read only per partition XML

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

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: OutstandingCreditorWithPaymentReference
  • Ruta XML: /tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem

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 OutstandingCreditorItemsWithPaymentReference. 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:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/AddressLine_1
ADDRESSLINE2 varchar2 Línea de la Dirección 2 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/City
COCNUMBER varchar2 Número CoC /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/CoCNumber
COMPANY_CODE varchar2(36) Código de partición
COMPANY_NAME varchar2(240) Nombre de partición
CONTACT varchar2 Contact /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Contact
CONTACTCODE varchar2 Código de contacto /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/ContactCode
CONTACTID guid ID de contacto /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/ContactID
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Description
DOMAINID varchar2(36) ID de dominio
DOMAINNAME varchar2(240) Nombre de dominio
DUEDATE datetime Fecha de Vencimiento /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/DueDate
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/EmailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/EmailWork
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/MailAddressLine_2
MAILCITY varchar2 Ciudad postal /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/MailCity
MAILPOSTCODE varchar2 Código postal del correo /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/MailPostcode
OPENAMOUNT decimal Monto Abierto /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/OpenAmount
ORIGINALAMOUNT decimal Importe original /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/PaymentMethod
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/PhoneWork
POSTCODE varchar2 Código Postal /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Postcode
RECIPIENTEMAIL varchar2 itgen_yuki_recipientemail /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/RecipientEmail
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Type
TYPEID varchar2 Escriba el id /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/Type/ID
VATNUMBER varchar2 Número VAT /soap11:Envelope/soap11:Body/tns:OutstandingCreditorWithPaymentReferenceResponse/tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem/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.OutstandingCreditorItemsWithPaymentReference

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