Accounts payable—suppliers described

When importing subledger transactions from a CSV or Excel file you must assign fields in the 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—suppliers 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.

Field Usage
Supplier ID
(ap_supplier_supplier_account_id)

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

Data type: Text

Required: Yes

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

Supplier Name
(ap_supplier_supplier_account_name)

The name of the supplier.

Data type: Text

Required: No

Primary key: First alternate. If Supplier 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>
Supplier Grouping Code
(ap_supplier_supplier_group)

If the organization segments suppliers into groups, the group to which this supplier is assigned.

Data type: Text

Required: No
Supplier Street Address 1
(ap_supplier_supplier_physical_street_address1)

The physical street address line 1 of the supplier.

Data type: Text

Required: No
Supplier Street Address 2
(ap_supplier_supplier_physical_street_address2)

The physical street address line 2 of the supplier.

Data type: Text

Required: No
Supplier City (
ap_supplier_supplier_physical_city)

The physical city where the supplier is located.

Data type: Text

Required: No
Supplier State
(ap_supplier_supplier_physical_state_province)

The physical state or province where the supplier is located.

Data type: Text

Required: No
Supplier Zip Code
(ap_supplier_supplier_physical_zip_postal_code)

The zip code of the city where the supplier is physically located.

Data type: Text

Required: No
Supplier Country
(ap_supplier_supplier_physical_country)

The country code where the supplier is physically located.

Data type: Text

Required: No
Supplier TIN
(ap_supplier_supplier_tin)

The supplier’s tax identification number.

Data type: Text

Required: No

Billing Address 1
(ap_supplier_supplier_billing_address1)

The billing address line 1 of the supplier.

Data type: Text

Required: No

Billing Address 2
(ap_supplier_supplier_billing_address2)

The billing address line 2 of the supplier.

Data type: Text

Required: No
Billing City
(ap_supplier_supplier_billing_city)

The billing city of the supplier.

Data type: Text

Required: No

Billing State (ap_supplier_supplier_billing_state_province)

The billing state or province of the supplier.

Data type: Text

Required: No

Billing Zip
(ap_supplier_supplier_billing_zip_postal_code)

The billing zip code of the supplier’s city.

Data type: Text

Required: No

Billing Country
(ap_supplier_supplier_billing_country)

The billing country code of the supplier.

Data type: Text

Required: No

Active Date
(ap_supplier_active_date)

The date the supplier declared active.

Data type: Date

Required: No

Inactive Date
(ap_supplier_inactive_date)

The date the supplier was declared inactive.

Data type: Date

Required: No

Transaction Credit Limit
(ap_supplier_transaction_credit_limit)

The per invoice credit limit established with this supplier.

Data type: Money

Required: No
Overall Credit Limit
(ap_supplier_overall_credit_limit)

The credit limit for the total outstanding balance approved for the supplier.

Data type: Money

Required: No
Invoice Terms Discount Percentage
(ap_supplier_terms_discount_percentage)

The discount percentage the supplier may provide if an invoice is paid before a certain number of days.

Data type: Decimal

Required: No
Invoice Terms Discount Days
(ap_supplier_terms_discount_days)

The number of days from the invoice date the supplier allows to take advantage of discounted terms.

Data type: Integer

Required: No
Invoice Term Due Days
(ap_supplier_terms_due_days)

The number of days allowed to meet the obligation before an invoice becomes overdue.

Data type: Integer

Required: No
Primary Contact Name
(ap_supplier_primary_contact_name)

The name of the primary contact at the supplier.

Data type: Text

Required: No
Primary Contact Phone
(ap_supplier_primary_contact_phone)

The phone number of the primary contact at the supplier.

Data type: Text

Required: No
Primary Contact Email (
ap_supplier_primary_contact_email)

The email address of the primary contact at the supplier.

Data type: Text

Required: No

Created By
(ap_supplier_entered_by)

The user identifier of the person who created the record.

Data type: Text

Required: No
Created Date
(ap_supplier_entered_date)

The date the transaction was entered into the source system. This is sometimes referred to as the creation date.

Data type: Date

Required: No

Created Time
(ap_supplier_entered_time)

The time this transaction was entered into the source system.

Data type: Date/time

Required: No

Approved By
(ap_supplier_approved_by)

The user identifier of the person who approved the entry.

Data type: Text

Required: No
Approved Date
(ap_supplier_approved_by_date)

The date the entry was approved.

Data type: Date

Required: No
Approved Time
(ap_supplier_approved_by_time)

The time the entry was approved.

Data type: Date/time

Required: No
Last Modified By
(ap_supplier_last_modified_by)

The user identifier of the last person to modify this entry.

Data type: Text

Required: No
Last Modified Date
(ap_supplier_last_modified_date)

The date the entry was last modified.

Data type: Date

Required: No
Last Modified Time
(ap_supplier_last_modified_time)

The time the entry was last modified.

Data type: Date/time

Required: No