CM
TranslationHistoryDetails
Represents the details of the currency translation history. The records of this type are created together with the header (TranslationHistory) by the currency translation process (TranslationProcess). The detail records store the results of currency translation for a particular account and subaccount, including the currency and rate information, link to the resulting GL transaction, status, and amounts.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountID | int | Account | Account | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Translation Batch Number | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CalcMode | smallint | Translation Method | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CreditAmt | decimal | Transaction Credit Amount | - | |
Description:No description available | ||||
CuryEffDate | datetime | Currency Effective Date | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryMultDiv | char(1) | Mult/Div | - | |
Description:No description available | ||||
CuryRate | decimal | Currency Rate | - | |
Description:No description available | ||||
DebitAmt | decimal | Transaction Debit Amount | - | |
Description:No description available | ||||
FinPeriodID | string | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LedgerID | int | Ledger | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
LineType | char(1) | Line Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigTranslatedAmt | decimal | Orig. Translated Amount | - | |
Description:No description available | ||||
RateTypeID | nvarchar(6) | Rate Type | CurrencyRateType | |
Description:No description available | ||||
ReferenceNbr | nvarchar(15) | Translation Number | TranslationHistory | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SourceAmt | decimal | Source Amount | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TranslDefId | nvarchar(10) | TranslDef | ||
Description:No description available | ||||
TranslatedAmt | decimal | Translated Amount | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||