GL
GLTrialBalanceImportMap
No summary is documented for this DAC in the release source.
View API Entity: TrialBalance
/entity/Default/22.200.001/TrialBalance| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AssetTotal | decimal | Asset Total | - | |
Description:Total amount of details that have Account type = Asset | ||||
BatchNbr API | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BegFinPeriodNonexistent in DB | string | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | Created On | - | |
Description:No description available | ||||
CreditTotalBalance API | decimal | Credit Total | - | |
Description:No description available | ||||
DebitTotalBalance API | decimal | Debit Total | - | |
Description:No description available | ||||
Description API | nvarchar | Description | - | |
Description:No description available | ||||
ExpenseTotal | decimal | Expense Total | - | |
Description:Total amount of details that have Account type = Expense | ||||
FinPeriodID API | string | Period | FinPeriod | |
Description:No description available | ||||
ImportDate API | datetime | Import Date | - | |
Description:No description available | ||||
IncomeTotal | decimal | Income Total | - | |
Description:Total amount of details that have Account type = Income | ||||
IsEditableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsHold API | bit | Hold | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LedgerID API | int | Ledger | Ledger | |
Description:No description available | ||||
LiabilityTotal | decimal | Liability Total | - | |
Description:Total amount of details that have Account type = Liability | ||||
LineCntr | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Number API | nvarchar(15) | Import Number | - | |
Description:No description available | ||||
OrgBAccountID API | int | Company/Branch | - | |
Description:A reference to the BAccount An integer identifier of the organizational entity. BAccountID of the Organization if OrganizationType != OrganizationTypes.WithBranchesBalancing BAccountID of the Branch if OrganizationType = OrganizationTypes.WithBranchesBalancing Corresponds to the BAccount.BAccountID field. | ||||
OrganizationIDNonexistent in DB | int? | - | ||
Description:Organization ID corresponds to the value of GLTrialBalanceImportMap.OrgBAccountID field. | ||||
Status API | nvarchar | Status | - | |
Description:No description available | ||||
TotalBalance API | decimal | Control Total | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||