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.
| Field | 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 |
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: Date Required: No |
Inactive Date (ar_customer_inactive_date) | The date the customer was declared inactive. Data type: Date 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: Date 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: Date 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 (
| The date the customer record was last modified. Data type: Date Required: No |
Last Modified Time (ar_customer_last_modified_time) | The time the entry was last modified. Data type: Date/time Required: No |
