This entity represents client account balance information including aged receivables. The attached contains the required format for the IClientBalance.CSV with a sample record.
The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.
Fields
Field Name | Required | Type | Description |
ClientID | Y | nvarchar(4000) | Unique record ID -maps to the PmsID in Iclient |
SiteID |
| nvarchar(MAX) | Id of site if more than one site location is being converted |
ClientBalance | Y | float | Client balance due |
AgedCurrent | Y | float | Client current balance due (30-60 days) |
Aged30 |
| float | Client current balance due (31-60 days) |
Aged60 |
| float | Client current balance due (61-90 days) |
Aged90 |
| float | Client current balance due (91-120 days) |
Aged120 |
| float | Client current balance due (>120 days) |
Key |
| nvarchar(4000) | Can be same as ClientID |
PmsID |
| nvarchar(MAX) | Same as Iclient.PmsID |