Skip to main content
CM

TranslationHistoryDetails

PX.Objects.CMRelease 2025.2

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 NameTypeDisplay NameForeign Key
AccountIDDefault Navigation
intAccountAccount
Description:No description available
BatchNbr
nvarchar(15)Translation Batch Number-
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:No description available
CalcMode
smallintTranslation Method-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CreditAmt
decimalTransaction Credit Amount-
Description:No description available
CuryEffDate
datetimeCurrency Effective Date-
Description:No description available
CuryIDDefault Navigation
nvarchar(5)CurrencyCurrency
Description:No description available
CuryMultDiv
char(1)Mult/Div-
Description:No description available
CuryRate
decimalCurrency Rate-
Description:No description available
DebitAmt
decimalTransaction Debit Amount-
Description:No description available
FinPeriodID
string-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LedgerIDDefault Navigation
intLedger
Description:No description available
LineNbr
intLine Nbr.-
Description:No description available
LineType
char(1)Line Type-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OrigTranslatedAmt
decimalOrig. Translated Amount-
Description:No description available
RateTypeIDDefault Navigation
nvarchar(6)Rate TypeCurrencyRateType
Description:No description available
ReferenceNbr
nvarchar(15)Translation NumberTranslationHistory
Description:No description available
Released
bitReleased-
Description:No description available
SourceAmt
decimalSource Amount-
Description:No description available
SubIDDefault Navigation
intSubaccountSub
Description:No description available
TranslDefIdDefault Navigation
nvarchar(10)TranslDef
Description:No description available
TranslatedAmt
decimalTranslated Amount-
Description:No description available
tstamp
timestamp-
Description:No description available