Sage Data Exchange GL Account Table
| Element Name | Description | Type | Length |
|---|---|---|---|
| AccountKey | Account Number | String | 9 |
| AccountDesc | Account Description | String | 50 |
| Account | Fully Formatted Account Number | String | 41 |
| RawAccount | Unformatted Account Number | String | 32 |
| MainAccountCode | Main Account | String | 15 |
| DateStart | Start Date | String | 8 |
| DateEnd | End Date | String | 8 |
| Status | Status | String | 1 |
| ClearBalance | Clear Balance | String | 1 |
| AccountType | Account Type | String | 2 |
| CashFlowsType | Cash Flows Type | String | 1 |
| RollupCode1 | Rollup Code 1 | String | 20 |
| RollupCode2 | Rollup Code 2 | String | 20 |
| RollupCode3 | Rollup Code 3 | String | 20 |
| RollupCode4 | Rollup Code 4 | String | 20 |
| AccountGroup | Account Group | String | 15 |
| AccountCategory | Account Category | String | 1 |
| CompanyCode | Company Code | String | 3 |
| DateCreated | Creation Date | String | 8 |
| TimeCreated | Creation Time | String | 8 |
| UserCreatedKey | Creation User ID | String | 10 |
| DateUpdated | Last Update Date | String | 8 |
| TimeUpdated | Last Update Time | String | 8 |
| UserUpdatedKey | Last Update User ID | String | 10 |