Accounts payable—open balances described

When importing subledger transactions from a CSV or Excel file you must assign fields in the source file to Caseware fields in the subledger dataset type you select on import, so that the transaction data displays correctly in the engagement. This topic details the fields in the Accounts payable—open balances subledger.

For more information on the subledger dataset descriptions, see Understand subledger data.

For more information on importing transaction data from CSV files, see Import the client’s transactions from a CSV.

Feld Usage
Transaction ID
(ap_open_balance_transaction_id)

The unique identifier for accounts payable—open balance transactions. These include invoice and cash paid.

Data type: Text

Required: No

Primary key: The value of this field is used to form the unique identifier of this entry.

Transaction Date
(ap_open_balance_transaction_date)

The date of the transaction, regardless of the date the transaction is created. This is the date from which the due date is calculated based on the invoice terms.

Data type: Datum

Required: No

Invoice Date
(ap_open_balance_invoice_date)

The date of the invoice, regardless of the date the invoice is entered. This is the date from which the due date is calculated based on the invoice terms.

Data type: Datum

Required: No

Primary key: Third alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the identifier of the entry, for example <FirstAlternate>-<SecondAlternate>-<ThirdAlternate>.

Balance Amount
(ap_open_balance_balance_amount)

The balance monetary amount recorded in the functional or group currency.

Data type: Money

Required: No

Reporting Balance Amount
(ap_open_balance_balance_amount_reporting)

The balance monetary amount recorded in the reporting currency.

Data type: Money

Required: No

Local Balance Amount
(ap_open_balance_balance_amount_local)

The balance monetary amount in the local currency.

Data type: Money

Required: No

Original Amount
(ap_open_balance_original_balance_amount)

The monetary amount for the original balance (original invoice amount) recorded in the functional or group currency.

Data type: Money

Required: No

Project ID
(ap_open_balance_project_id)

The unique identifier for the project, from which accounts payable (AP) is derived.

Data type: Text

Required: No

Primary key: No

Fiscal Year (ap_open_balance_fiscal_year)

The fiscal year in which Transaction Date occurs.

Data type: Text

Required: No

Accounting Period
(ap_open_balance_accounting_period)

The accounting period in which Transaction Date occurs.

Data type: Text

Required: No

Transaction Due Date
(ap_open_balance_transaction_due_date)

The date payment is due from the supplier. Not all transactions have a due date.

Data type: Datum

Required: No

Beschreibung
(ap_open_balance_remark)

A free-form text description.

Data type: Text

Required: No

Invoice Number
(ap_open_balance_invoice_number)

The number of an internally or externally generated transaction. Examples include check number, wire transfer number or original document identifier.

Data type: Text

Required: Yes

Primary key: First alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example <FirstAlternate>-<SecondAlternate>-<ThirdAlternate>

Invoice Due Date
(ap_open_balance_invoice_due_date)

The date payment is due to the supplier. Not all transactions will have a due date, for example, credit memos.

Data type: Datum

Required: No

Business Unit Code
(ap_open_balance_business_unit_code)

Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited.

Data type:

Text Required: No

Balance Amount Currency
(ap_open_balance_balance_amount_currency)

The functional or group currency related to the balance amount.

Data type: Text

Required: No

Reporting Balance Currency
(ap_open_balance_balance_reporting_currency)

The reporting currency related to the balance reporting amount for nonconsolidated reporting.

Data type: Text

Required: No

Local Balance Currency
(ap_open_balance_balance_local_currency)

The currency for local reporting requirements.

Data type: Text

Required: No

Entry ID
(ap_open_balance_journal_id)

The unique identifier for the journal entry.

Data type: Text

Required: No

Supplier ID
(ap_open_balance_supplier_account_id)

The identifier of the supplier to whom payment is expected or from whom unused credits have been applied.

Data type: Text

Required: No

Primary key: Second alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the identifier of the entry, for example <FirstAlternate>-<SecondAlternate>-<ThirdAlternate>

Supplier Name
(ap_open_balance_ upplier_account_name)

The name of the supplier.

Data type: Text

Required: No