Sage Intacct: General Ledger

Description

• Records all transactions from Sage general ledger. Additionally adds category, classification, and account type.

Supported Data Sources

• Sage Intacct

Columns

Type	Name	Description
STRING	gl_detail_id	Unique identifier of the gl_detail entry.
STRING	account_no	ID of the account
STRING	account_title	Name of the account
INTEGER	amount	Value of transaction
STRING	book_id	ID of the book
DECIMAL	credit_amount	If credit, the value
DECIMAL	debit_amount	If debit, the value
STRING	currency	Currency of transaction
STRING	description	Description of the transaction
STRING	doc_number	Document number
STRING	customer_id	ID of the customer
STRING	customer_name	Name of the customer
DATE	entry_date_at	Timestamp of entry
STRING	entry_state	State of entry
STRING	entry_description	Description of entry
INTEGER	line_no	The number of each line item of the transaction
STRING	record_id	ID of record, which corresponds to the bill or invoice ID.
STRING	record_type	Type of record, for example AP Bill
DECIMAL	total_due	Value of amount due
DECIMAL	total_entered	Value entered
DECIMAL	total_paid	Value paid
INTEGER	tr_type	Transaction type
DECIMAL	trx_amount	Transaction amount
DECIMAL	trx_credit_amount	If credit, transaction amount
DECIMAL	trx_debit_amount	If debit, transaction amount
STRING	vendor_id	Id of vendor
STRING	vendor_name	Name of vendor
DATE	created_at	Creation date as entered by user
DATE	due_at	When transaction is due
DATETIME	modified_at	When transaction is modified
DATE	paid_at	When transaction was paid
STRING	category	Accounting category, like Cost of Sales Revenue
STRING	classification	Accounting classification, like Revenue
STRING	account_type	Income statement or balance sheet