AgicapSincroNote

Name Type Length Is Key Nullable Description Values
customer_ID int K No customer_ID
accountCode nvarchar 20 K No Id invio
accountNumber nvarchar 20 K No Codice conto
amount varchar 50 Si Descrizione
currency nvarchar 5 Si Sigla
remainingAmount decimal Si resto da 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
creditNoteNumber varchar 15 Si Credit Note Number
issueDate datetime Si Issue Date
label varchar 50 Si label
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