Source Data

Questa documentazione è superata

La documentazione più completa e aggiornata è quella di Banana Contabilità Plus: Provalo subito

In this article

Invoice Json Object Source Data

This list explains where the actual information on your invoice json object is coming from

Invoice Object Property Source
customer_info.address1 Table: Accounts, View: Address, Column: Street
customer_info.address2 Table: Accounts, View: Address, Column: AddressExtra
customer_info.address3 Table: Accounts, View: Address, Column: POBox
customer_info.balance Table: Accounts, View: Address, Column: Balance
customer_info.balance_base_currency Table: Accounts, View: Address, Column: BalanceCurrency
customer_info.bank_account Table: Accounts, View: Address, Column: BankAccount
customer_info.bank_clearing Table: Accounts, View: Address, Column: BankClearing
customer_info.bank_name Table: Accounts, View: Address, Column: BankName
customer_info.business_name Table: Accounts, View: Address, Column: OrganisationName
customer_info.city Table: Accounts, View: Address, Column: Locality
customer_info.country Table: Accounts, View: Address, Column: Country
customer_info.country_code Table: Accounts, View: Address, Column: CountryCode
customer_info.courtesy Table: Accounts, View: Address, Column: NamePrefix
customer_info.credit_limit Table: Accounts, View: Address, Column: CreditLimit
customer_info.currency Table: Accounts, View: Address, Column: Currency
customer_info.date_birth Table: Accounts, View: Address, Column: DateOfBirth
customer_info.email Table: Accounts, View: Address, Column: EmailWork
customer_info.fax Table: Accounts, View: Address, Column: Fax
customer_info.first_name Table: Accounts, View: Address, Column: FirstName
customer_info.fiscal_number Table: Accounts, View: Address, Column: FiscalNumber
customer_info.iban_number Table: Accounts, View: Address, Column: BankIban
customer_info.lang Table: Accounts, View: Address, Column: Language
customer_info.last_name Table: Accounts, View: Address, Column: FamilyName
customer_info.member_fee Table: Accounts, View: Address, Column: MemberFee
customer_info.mobile Table: Accounts, View: Address, Column: PhoneMobile
customer_info.number Table: Accounts, View: Address, Column: Account
customer_info.payment_term_days Table: Accounts, View: Address, Column: PaymentTermInDays
customer_info.phone Table: Accounts, View: Address, Column: PhoneMain
customer_info.postal_code Table: Accounts, View: Address, Column: PostalCode
customer_info.state Table: Accounts, View: Address, Column: Region
customer_info.vat_number Table: Accounts, View: Address, Column: VatNumber
customer_info.web Table: Accounts, View: Address, Column: Website
document_info.currency Invoice currency which usually corresponds to the customer account currency
document_info.date Table: Transactions, Column: DateDocument or Date
document_info.decimals_amounts Decimals are the same as the decimals used in the accounting file
document_info.description Not used
document_info.doc_type Table: Transactions, Column: DocType
document_info.greetings

Table: Transactions, Column: DocType
Transactions with DocType=10:gre
If there are many rows with 10:gre the texts are joined with ','.
More info...

document_info.locale Menu: File-File and accounting properties, Other, current Language
document_info.number Table: Transactions, Column: DocInvoice
document_info.origin_row Row index of source transaction
document_info.origin_table Table name of source transaction
document_info.rounding_total

Default value for CHF: 0.05
You can overwrite this value with the menu command: Account2 - Customers - Settings - Advanced - Invoice rounding
For multicurrency accounting: you can setup the rounding value for each currency in the table ExchangeRates, column DecimalPoints

document_info.type invoice
items Table: Transactions
All rows with the same invoice number and transaction date are invoice's items (lines)
note Table: Transactions, Column: DocType
Transactions with DocType=10:not.
More info...
parameters

Table: Transactions, Column: DocType
Transactions with DocType=10:par:key
Key: any key text you wish
Value: is taken from column Description
More info...

payment_info Calculated from journal
shipping_info

Delivery address if different from the invoice address (customer_info)
Table: Transactions, Column: DocType
Transactions with DocType=10:sadr
More info...

supplier_info.address1 Menu: File-File and accounting properties, Address, Address 1
supplier_info.address2 Menu: File-File and accounting properties, Address, Address 2
supplier_info.business_name Menu: File-File and accounting properties, Address, Company
supplier_info.city Menu: File-File and accounting properties, Address, City
supplier_info.country Menu: File-File and accounting properties, Address, Country
supplier_info.courtesy Menu: File-File and accounting properties, Address, Courtesy
supplier_info.email Menu: File-File and accounting properties, Address, Email
supplier_info.fax Menu: File-File and accounting properties, Address, Fax
supplier_info.first_name Menu: File-File and accounting properties, Address, Name
supplier_info.fiscal_number Menu: File-File and accounting properties, Address, Fiscal Number
supplier_info.last_name Menu: FilevFile and accounting properties, Address, Family Name
supplier_info.mobile Menu: File-File and accounting properties, Address, Mobile
supplier_info.phone Menu: File-File and accounting properties, Address, Phone
supplier_info.postal_code Menu: File-File and accounting properties, Address, Zip
supplier_info.state Menu: File-File and accounting properties, Address, Region
supplier_info.vat_number Menu: File-File and accounting properties, Address, Vat Number
supplier_info.web Menu: File-File and accounting properties, Address, Web
transactions Table: Transactions
All rows with the same invoice number and different transaction date, which are not considered invoice items, like payments transactions

 

 

Condividi questo articolo: Twitter | Facebook | LinkedIn | Email