CM
TranslationHistory
Represents currency translation history. The records of this type are created together with details (TranslationHistoryDetails) by the currency translation process (TranslationProcess). The header records store general results of the currency translation, including the dates, status, link to the resulting batch, and totals.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Translation Batch Number | Batch | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ControlTot | decimal | Control Total | - | |
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 | ||||
CreditTot | decimal | Credit Total | - | |
Description:No description available | ||||
CuryEffDate | datetime | Currency Effective Date | - | |
Description:No description available | ||||
DateEntered | datetime | Translation Date | - | |
Description:No description available | ||||
DebitTot | decimal | Debit Total | - | |
Description:No description available | ||||
Description | nvarchar(60) | Description | - | |
Description:No description available | ||||
DestCuryID | nvarchar(5) | Destination Currency | Currency | |
Description:No description available | ||||
FinPeriodID | string | Fin. Period | FinPeriod | |
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 | Destination Ledger | Ledger | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ReferenceNbr | nvarchar(15) | Translation Number | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TranslDefId | nvarchar(10) | Translation ID | TranslDef | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||