Sage Intacct: Ap Ar Enhanced

Description

• All transactions for each bill or invoice with their associated accounting period and due dates. Includes additional detail regarding the customer, location, department, vendor, and account. Lastly, contains fields like the line number and total number of items in the overall bill or invoice.

Supported Data Sources

• Sage Intacct

Columns

Type	Name	Description
STRING	document_id	Invoice or bill id
STRING	document_item_id	Unique key identifying the document item id
STRING	document_type	Whether the document is a bill or invoice
DATE	entry_date_at	Entry date
STRING	entry_description	Description of entry
DECIMAL	amount	Value of the document item
STRING	currency	Currency of item
INTEGER	due_in_days	Days until due
STRING	item_id	Item ID
STRING	item_name	Item name
INTEGER	line_no	Line number of the item out of the overall document
BOOLEAN	line_item	True or false
STRING	customer_id	ID of customer
STRING	customer_name	Name of customer
STRING	department_id	ID of department
STRING	department_name	Name of department
STRING	location_id	ID of location
STRING	location_name	Name of location
STRING	vendor_id	ID of vendor
STRING	vendor_name	Name of vendor
DECIMAL	account_no	ID of account
STRING	account_title	Name of account
STRING	class_id	ID of class
STRING	class_name	Name of class
DATETIME	created_at	Creation date as entered by user
DATETIME	modified_at	Modified date
DECIMAL	total_due	Total amount due
DECIMAL	total_entered	Total amount entered
DECIMAL	total_paid	Total amount paid
INTEGER	number_of_items	Total number of items
DECIMAL	total_item_paid	Total item paid
INTEGER	offset_gl_account_no	Offsetting account no from GL_ACCOUNT
STRING	offset_gl_account_title	Offsetting account title from GL_ACCOUNT
STRING	record_id	ID of invoice or bill. Maps to GL_DETAIL.RECORDID, which has all the records belonging to that invoice.