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 |