| Available Columns |
Description |
Date Range Available |
Chartable |
Links to Page |
| General Information
|
| Address 1 |
The first line in the main address for the company |
|
|
|
| Address 2 |
The second line in the main address for the company
Examples: suite number, building number
|
|
|
|
| Address 3 |
The third line in the main address for the company |
|
|
|
| Address |
The first line in the main address for the company
Example: street address
|
|
|
|
| City |
The city name in the main address for the company |
|
|
|
| Client Invoice Historical Synced |
This indicates that the historical sync has been run for the Bill & Pay integration.
Historical Sync is run in the Bill & Pay integration settings in Company > Preferences or Company > Companies.
|
|
|
|
| Company Order |
Order of the company in the company list |
|
|
|
| Country |
The country name for the company |
|
|
|
| Description |
The description of the company |
|
|
Company |
| Email |
The email address for the company |
|
|
|
| Employer ID |
Employer ID for the company |
|
|
|
| Fax Number |
The fax number for the company |
|
|
|
| Fax Text |
A description of the fax number for the company |
|
|
|
| Mailing Address 1 |
The first line in the mailing address for the company
Example: street address
|
|
|
|
| Mailing Address 2 |
The second line in the mailing address for the company
Examples: suite number, building number
|
|
|
|
| Mailing Address 3 |
The third line in the mailing address for the company |
|
|
|
| Mailing Address |
The first line in the mailing address for the company |
|
|
|
| Mailing City |
The city name in the mailing address for the company |
|
|
|
| Mailing Country |
The country name in the mailing address for the company |
|
|
|
| Mailing State |
The state name in the mailing address for the company |
|
|
|
| Mailing ZIP |
The ZIP code in the mailing address for the company |
|
|
|
| Payroll Type |
Indicates the way this company processes payroll |
|
|
|
| Phone 1 Number |
The primary phone number for the company |
|
|
|
| Phone 1 Text |
A description of the primary phone number for the company
Examples: Office, Cell
|
|
|
|
| Phone 2 Number |
The secondary phone number for the company |
|
|
|
| Phone 2 Text |
A description of the secondary phone number for the company
Example: Home
|
|
|
|
| Phone 3 Number |
The tertiary phone number for the company |
|
|
|
| Phone 3 Text |
A description of the tertiary phone number for the company |
|
|
|
| Phone Numbers |
The phone numbers for the company |
|
|
|
| State |
The state name in the main address for the company |
|
|
|
| Status |
The status of the company
Examples: Active, Inactive
|
|
|
|
| Website |
The website URL associated with the company |
|
|
|
| ZIP |
The ZIP code in the main address for the company |
|
|
|
| Dates
|
| Current Fiscal Year |
Indicates the current fiscal year for the company |
|
|
|
| Entry Cutoff Date |
The cutoff date associated with the company |
|
|
|
| Fiscal Start Month |
The month the current fiscal year starts |
|
|
|
| Get Payments Last Run |
The date and time of the last Get Payments retrieval for the Bill & Pay integration.
Get Payments is run in Manage > Client Receipts.
|
|
|
|
| Payroll Start Date |
The date of the first payroll for this company |
|
|
|
| Dollars |
| Cash |
Cash balance in the bank account
|
X |
X |
|
| GL Balance |
Total GL balance of all accounts
To exclude close year entries from the calculation, check the Exclude Close Year Entries check box when editing or adding the column.
|
X |
X |
|
| GL Budget |
Total budget of all accounts |
X |
X |
|
| GL Cash Basis Balance |
Total cash basis balance of all accounts
To exclude close year entries from the calculation, check the Exclude Close Year Entries check box when editing or adding the column.
|
X |
X |
|
| GL Cash Basis Budget |
Total cash basis budget of all accounts |
X |
X |
|
| Payable Balance |
The total amount remaining to be paid to the vendors associated with the phase
|
X |
X |
|
| Receivable Balance |
The total amount remaining to be paid by the client associated with the phase
|
X |
X |
|
| WIP Balance |
Total WIP balance |
X |
X |
|
| Keys
|
| Company Key |
The database identifier of the company |
|
|
Company |
| Gantt
|
unavailable in ajeraCore Select to add the Gantt chart to your table widget.
|
|
|
|
