| Account_Number |
Yes |
Text |
"1-00-00-1010-000" |
See GL Account Mapping for more info. |
| Account_Name |
Yes |
Text |
"Cash - Cash Register" |
|
| Account_Category |
Yes |
Lookup |
"Asset" |
See GL Account Category / Account Type for list of categories. |
| Account_Type |
Yes |
Lookup |
"Bank Account" |
See GL Account Category / Account Type for list of types. |
| Account_Detail_Type |
No |
Lookup |
"Fund Raising" |
Used for "Account Sub Types" in GL Account. |
| Account_Description |
No |
Text |
"School Clothing Store" |
|
| Contra_to_Account_Number |
No |
Lookup |
"1-00-00-4000-000" |
See GL Account for more info. |
| Is_Active |
Yes |
Boolean |
"1" or "0" |
See GL Account for more info. |
Summarize_to_Account_Number
|
Yes |
Lookup |
"1-00-00-4000-000"
|
Required for all revenue, expense, gain, or loss accounts. See GL Account for more info. |
| Surpress_Reporting |
No |
Boolean |
"1" or "0" |
See GL Account for more info. |
| Attribute1_ID |
No |
Identifier |
"64" |
|
| Attribute1_Name |
No |
Lookup |
Austin |
If the attribute ID is unknown, provide the account attribute Name in this field. The system will use the attribute name and category to find the attribute ID. |
| Attribute1_Category |
No |
Lookup |
Campus |
If the attribute ID is unknown, provide the account attribute category in this field. The system will use the attribute name and category to find the attribute ID. |
| Attribute1_Comment |
No |
Lookup |
PCR Educator - Texas |
A comment relating to the attribute. |