Accounts receivable—customers 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 receivable—customers 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
Customer Account ID (ar_customer_customer_account_id)

The identifier of the customer from whom payment is expected or to 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.

Customer Account Name (ar_customer_customer_account_name) The name of the customer.

Data type: Text

Required: No

Primary key: First alternate. If Customer Account 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>

Customer Group (ar_customer_customer_group) If the organization segments customers into groups, the group to which this customer is assigned.

Data type: Text

Required: No

Customer Physical Street Address Line 1 (ar_customer_customer_physical_street_address1) The physical street address line 1 of the customer.

Data type: Text

Required: No

Customer Physical Street Address Line 2 (ar_customer_customer_physical_street_address2) The physical street address line 2 of the customer.

Data type: Text

Required: No

Customer Physical City (ar_customer_customer_physical_city) The physical city where the customer is located.

Data type: Text

Required: No

Customer Physical State Province (ar_customer_customer_physical_state_province) The physical state or province where the customer is located.

Data type: Text

Required: No

Customer Physical Zip Postal Code (ar_customer_customer_physical_zip_postal_code) The zip code of the city where the customer is physically located.

Data type: Text

Required: No

Customer Physical Country (ar_customer_customer_physical_country) The country code where the customer is physically located.

Data type: Text

Required: No

Customer TIN (ar_customer_customer_tin) The customer’s tax identification number.

Data type: Text

Required: No

Customer Billing Address Line 1 (ar_customer_customer_billing_address1) The billing address line 1 of the customer

Data type: Text

Required: No

Customer Billing Address Line 2 (ar_customer_customer_billing_address2) The billing address line 2 of the customer.

Data type: Text

Required: No

Customer Billing City (ar_customer_customer_billing_city) The billing city of the customer.

Data type: Text

Required: No

Customer Billing State Province (ar_customer_customer_billing_state_province) The billing state or province of the customer.

Data type: Text

Required: No

Customer Billing Zip Postal Code (ar_customer_customer_billing_zip_postal_code) The billing zip code of the customer’s city.

Data type: Text

Required: No

Customer Billing Country (ar_customer_customer_billing_country) The billing country code of the customer.

Data type: Text

Required: No

Active Date (ar_customer_active_date)

The date the customer was declared active.

Data type: Datum

Required: No

Inactive Date (ar_customer_inactive_date)

The date the customer was declared inactive.

Data type: Datum

Required: No

Transaction Credit Limit (ar_customer_transaction_credit_limit)

The per invoice credit limit established for this customer.

Data type: Money

Required: No

Overall Credit Limit (ar_customer_overall_credit_limit)

The credit limit for this customer’s total outstanding balance.

Data type: Money

Required: No

Invoice Terms Discount Percentage (ar_customer_terms_discount_percentage)

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

Data type: Decimal

Required: No

Invoice Terms Discount Days (ar_customer_terms_discount_days)

The number of days from the invoice date the customer has to take advantage of discounted terms.

Data type: Integer

Required: No

Invoice Term Due Days (ar_customer_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 (ar_customer_primary_contact_name) The name of the primary contact at the customer.

Data type: Text

Required: No

Primary Contact Phone (ar_customer_primary_contact_phone) The phone number of the primary contact at the customer.

Data type: Text

Required: No

Primary Contact Email (ar_customer_primary_contact_email) The email address of the primary contact at the customer.

Data type: Text

Required: No

Parent Customer ID (ar_customer_parent_customer_id) The unique identifier for the parent customer.

Data type: Text

Required: No

Corresponding Supplier ID (ar_customer_corresponding_supplier_id) The unique identifier for the corresponding supplier in case that the customer is also a supplier.

Data type: Text

Required: No

Customer Type ID (ar_customer_type_id) The unique identifier for the customer type.

Data type: Text

Required: No

Entered By (ar_customer_entered_by) The user identifier of the person who created the record.

Data type: Text

Required: No

Entered Date (ar_customer_entered_date)

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

Data type: Datum

Required: No

Entered Time (ar_customer_entered_time)

The time this transaction was entered into the source system.

Data type: Date/time

Required: No

Approved By (ar_customer_approved_by) The user identifier of the person who approved customer master additions or changes.

Data type: Text

Required: No

Approval Date (ar_customer_approved_by_date)

The date the customer master additions or changes were approved.

Data type: Datum

Required: No

Approval Time (ar_customer_approved_by_time)

The time the entry was approved.

Data type: Date/time

Required: No

Last Modified By (ar_customer_last_modified_by) The user identifier of the last person to modify this entry.

Data type: Text

Required: No

Last Modified Date (ar_customer_last_modified_date)

 

The date the customer record was last modified.

Data type: Datum

Required: No

Last Modified Time (ar_customer_last_modified_time)

The time the entry was last modified.

Data type: Date/time

Required: No