GL
GLTrialBalanceImportMap
PX.Objects.GL28 of 28 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Number | nvarchar(15) | Import Number | - | |
Description:No description available | ||||
AssetTotal | decimal(19, 4) | Asset Total | - | |
Description:Total amount of details that have Account type = Asset | ||||
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BegFinPeriodNonexistent in DB | nvarchar | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CreditTotalBalance | decimal(19, 4) | Credit Total | - | |
Description:No description available | ||||
DebitTotalBalance | decimal(19, 4) | Debit Total | - | |
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
ExpenseTotal | decimal(19, 4) | Expense Total | - | |
Description:Total amount of details that have Account type = Expense | ||||
FinPeriodID | char(6) | Period | - | |
Description:No description available | ||||
ImportDate | datetime2 | Import Date | - | |
Description:No description available | ||||
IncomeTotal | decimal(19, 4) | Income Total | - | |
Description:Total amount of details that have Account type = Income | ||||
IsEditableNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsHold | bit | Hold | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LedgerID | int | Ledger | Ledger | |
Description:No description available | ||||
LiabilityTotal | decimal(19, 4) | Liability Total | - | |
Description:Total amount of details that have Account type = Liability | ||||
LineCntr | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrganizationIDNonexistent in DB | int | - | ||
Description:Organization ID corresponds to the value of GLTrialBalanceImportMap.OrgBAccountID field. | ||||
OrgBAccountID | int | Company/Branch | BAccount | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TotalBalance | decimal(19, 4) | Control Total | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||