E-CUBE Data Services WebAPI Platform

AgicapSincroInvoices

Name Type Length Is Key Nullable Description Values
customer_ID int K No customer_ID
key_documento nvarchar 500 K No Key Documento
id_invio varchar 255 No Id invio
accountCode nvarchar 20 Si account code
accountNumber nvarchar 20 Si Codice conto
amount varchar 50 Si Descrizione
currency nvarchar 5 Si Sigla
dueAmount decimal Si Total a pagare
taxesAmount decimal Si Tax amount
totalAmount decimal Si Total Amount
due_date datetime Si Due date
erpIdentificationField nvarchar 500 Si Id Identification FIeld
externalId nvarchar 500 Si Chiave
invoiceNumber varchar 15 Si Invoice Number
issueDate datetime Si Issue Date
label nvarchar 250 Si label
paymentDate datetime Si Payment Date
status varchar 50 Si Staus due= da_pagare | paid=pagato | draft=bozza
name nvarchar 60 Si Ragione Sociale
AgicapSincroInstalments list Si AgicapSincroInstalments
ts_update timestamp No ts_update
flg_isdeleted bit No flg_isdeleted
dat_ultvar datetime2 Si dat_ultvar
Id int No Id