Accounts Receivable (AR) invoice table

The AR invoice (sn_otc_invoice) table stores the invoice data.

Accounts Receivable invoice table

The following table lists the fields for AR invoice [sn_otc_invoice] table.

Table 1. Accounts Receivable invoice table

Field	Data type	Description
Account	Reference to Account	Customer in the business-to-business (B2B) business model.
Amount invoiced with tax (Reporting currency)	FX Currency	Total amount to be paid to the supplier including tax and shipping charges. This amount is displayed in reporting currency.
Amount invoiced with tax (Transaction currency)	FX Currency	Total amount to be paid to the supplier including tax and shipping charges. This amount is displayed in transactional currency.
Amount invoiced without tax (Reporting currency)	FX Currency	Total amount to be paid to the supplier excluding tax and shipping charges. This amount is displayed in reporting currency.
Amount invoiced without tax (Transaction currency)	FX Currency	Total amount to be paid to the supplier excluding tax and shipping charges. This amount is displayed in transactional currency.
Billing Contact	Reference to Account Contact	The account contact to which the invoice is sent.
Billing Location	Reference Location	Reference to the location to which the invoice is sent.
Bill to city	String	The city to which the invoice is sent.
Bill to country	Reference to Country	The country to which the invoice is sent.
Bill to state/province	String	The state to which the invoice is sent.
Bill to street	String	The street address to which the invoice is sent.
Bill to ZIP/postal code	String	The zip code to which this invoice is sent.
Business owner	Reference to User	A group who owns the invoice.
Consumer	Reference to Consumer	Customer in the business-to-consumer (B2C) business model.
Created	Date/Time	Date on which this invoice is created.
Created by	String	Person who created the invoice.
Tax Code	Reference to Tax Code	The tax code levied on the total invoice amount.
Tax Jurisdiction Code	String	The tax code jurisdiction to which you must pay the tax.
Discount (%)	Decimal	Discount % for the discounts amount.
Discount due date	Date	Date by which you must make payment for the discounts to be applicable.
Discounts Amount	FX Currency	The discount applied on the invoice amount.
Due date	Date	Date by when you must make the payment.
Early payment discount amount	FX Currency	The discount applied on the total invoice amount on early payment.
ERP number	String	Unique number generated within the ERP system for the invoice.This field is applicable when there’s an ERP integration. The value is populated after the invoice is posted in the ERP system through the integration.
ERP posting date	Date	Date on which the invoice is posted in the ERP system.
Has changed	True/False	Denotes if the invoice has changed.
Invoice date	Date	Date on which this invoice is created.
Invoice source	String	Name of the application associated with the invoice from where it is sourced.
Number	String	An auto-generated number that uniquely identifies the invoice.
Other charges	FX Currency	Additional charges incurred on the invoice.
Parent invoice	Reference to AR Invoice	Original invoice
Payment date	Date	The date by when you must make the payment.
Payment terms	Reference to payment terms	Conditions applied on the payment
Remit to Contact	Reference to Account Contact	The account contacted to which the payment is made.
Remit to Location	Reference to Location	Reference to the location to which the payment is made.
Remit to city	String	The city to which the payment is made.
Remit to country	Reference to Country	The country to which the payment is made.
Remit to state/province	String	The state to which the payment is made.
Remit to street	String	The street address to which the payment is made.
Remit to zip/postal code	String	The zip code to which this payment is made.
Requires acknowledgment	True/False	Invoice requires acknowledgment of receipt from recipient
Sales Order	Reference to Order	Sales order associated with the invoice.
Sales order number	String	Sales order associated with the invoice.
Customer tax id	String	The tax ID of the customer
Customer Contact	Reference to Account Contact	The account contact of the customer for the invoice.
Customer Location	Reference to Location	Reference to the customer location for the invoice.
Customer city	String	The city of the customer for the invoice.
Customer country	Reference to Country	The country of the customer for the invoice.
Customer state/province	String	The country of the customer for the invoice.
Customer street	String	The street address of the customer for the invoice.
Customer zip/postal code	String	The zip code of the customer for the invoice.
Shipping from Location	Reference to Location	Reference to the location from which the order on the invoice is shipped.
Ship from city	String	The city from which the order on the invoice is shipped.
Ship from country	Reference to Country	The country from which the order on the invoice is shipped.
Ship from state/province	String	The state from which the order on the invoice is shipped.
Ship from street	String	The street address from which the order on the invoice is shipped.
Ship from zip/postal code	String	The zip code from which this order is shipped.
Shipping to Contact	Reference to Account Contact	The account contacted to which the order on the invoice is shipped.
Shipping to Location	Reference to Location	Reference to the location to which the order on the invoice is shipped.
Ship to city	String	The city to which the order on the invoice is shipped.
Ship to country	Reference to Country	The country to which the order on the invoice is shipped.
Ship to state/province	String	The state to which the order on the invoice is shipped.
Ship to street	String	The street address to which the order on the invoice is shipped.
Ship to zip/postal code	String	The zip code to which this order is shipped.
Shipping Charges	FX Currency	Shipping charges incurred for the invoice.
Short description	String	Brief description about the invoice.
Status	String	Current state of the invoice.
Submitted by	Reference to User	Person who submitted the invoice.
Subtotal	FX Currency	The total amount from all the invoice lines without tax and shipping charges.
Supplier	Reference to Supplier	Supplier who delivers the product or service.
Supplier tax id	String	The tax ID of the supplier.
Tax amount	FX Currency	Tax applied on the invoice amount.
Tax rate decimal	Decimal	Tax rate % applied on the invoice - Tax rate in decimal if tax code is not used.
Tax Rate String	String	Tax rate % applied on the invoice - Tax rate in string if tax code and decimal is not used
Type	String	The type of invoice debit or credit.