AgicapSincroInvoices

Name Type Length Is Key Nullable Description Values
customer_ID int K No customer_ID
accountCode nvarchar 20 K No account code
accountNumber nvarchar 20 K No 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 K No Chiave
invoiceNumber varchar 15 Si Invoice Number
issueDate datetime Si Issue Date
label varchar 50 Si label
paymentDate datetime Si Payment Date
status varchar 50 Si Staus
name nvarchar 60 Si Ragione Sociale
ts_update timestamp No ts_update
flg_isdeleted bit No flg_isdeleted
dat_ultvar datetime2 Si dat_ultvar
Id int No Id