Powered by InfoCaptor


Previous Page   Next Page

Cash Receipt Histories
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_RECEIPT_HISTORIESUnknown
NoneNone.ARFG_RECEIPT_HISTORIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AmountThe amount of revenue authorized for the agreement.Cash Receipt Histories.AmountAMOUNTAMOUNT115854
Batch IdSurrogate key for the batch for which results are recorded.Cash Receipt Histories.Batch IdBATCH_IDBATCH_ID119372
Cash Receipt History IdCash receipt history identifier.Cash Receipt Histories.Cash Receipt History IdCASH_RECEIPT_HISTORY_IDCASH_RECEIPT_HISTORY_ID121647
Cash Receipt IdUnique Identifier for Cash ReceiptCash Receipt Histories.Cash Receipt IdCASH_RECEIPT_IDCASH_RECEIPT_ID121652
Created ByStandard WHO column.Cash Receipt Histories.Created ByCREATED_BYCREATED_BY124529
Creation DateStandard WHO column.Cash Receipt Histories.Creation DateCREATION_DATECREATION_DATE125961
Creation Date - Day Cash Receipt Histories.Creation Date CREATION_DATE_DAY172089
Creation Date - Month Cash Receipt Histories.Creation Date CREATION_DATE_MONTH172543
Creation Date - Quarter Cash Receipt Histories.Creation Date CREATION_DATE_QUARTER172997
Creation Date - Year Cash Receipt Histories.Creation Date CREATION_DATE_YEAR173451
Currency Exchange DateDate exchange rate is effective. Usually the accounting date of the transaction.Cash Receipt Histories.Currency Exchange DateCURRENCY_EXCHANGE_DATECURRENCY_EXCHANGE_DATE127191
Currency Exchange Date - Day Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_DAY174172
Currency Exchange Date - Month Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_MONTH174176
Currency Exchange Date - Quarter Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_QUARTER174180
Currency Exchange Date - Year Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_YEAR174184
Currency Exchange RateExchange rate for foreign currency payments.Cash Receipt Histories.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127196
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Cash Receipt Histories.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127220
Current Record Flag Cash Receipt Histories.Current Record FlagCURRENT_RECORD_FLAGCURRENT_RECORD_FLAG266671
Factor Discount Amount Cash Receipt Histories.Factor Discount AmountFACTOR_DISCOUNT_AMOUNTFACTOR_DISCOUNT_AMOUNT134213
Factoring Flag Cash Receipt Histories.Factoring FlagFACTORING_FLAGFACTORING_FLAG266672
Functional AmountPayment amount in functional currency.Cash Receipt Histories.Functional AmountFUNCTIONAL_AMOUNTFUNCTIONAL_AMOUNT134884
Functional Factor Discount AmountFactor Discount Amount in the functional currencyCash Receipt Histories.Functional Factor Discount AmountFUNC_FACTOR_DISCOUNT_AMOUNTFUNC_FACTOR_DISCOUNT_AMOUNT134931
Last Update DateStandard WHO column.Cash Receipt Histories.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140492
Last Update Date - Day Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_DAY183494
Last Update Date - Month Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_MONTH183922
Last Update Date - Quarter Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_QUARTER184350
Last Update Date - Year Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_YEAR184778
Last Updated ByStandard WHO column.Cash Receipt Histories.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139153
Note Status Cash Receipt Histories.Note StatusNOTE_STATUSNOTE_STATUS266673
Operating Unit Cash Receipt Histories.Operating UnitOPERATING_UNITOPERATING_UNIT149494
Organization IDOrganization identifier.Cash Receipt Histories.Organization IDORG_IDORG_ID150921
Receipt Batch Name Cash Receipt Histories.Receipt Batch NameRECEIPT_BATCH_NAMERECEIPT_BATCH_NAME157971
Receipt Number Cash Receipt Histories.Receipt NumberRECEIPT_NUMBERRECEIPT_NUMBER158015
Receipt Status Cash Receipt Histories.Receipt StatusRECEIPT_STATUSRECEIPT_STATUS266670
AmountThe amount of revenue authorized for the agreement.Cash Receipt Histories.AmountAMOUNTAMOUNT115854
Batch IdSurrogate key for the batch for which results are recorded.Cash Receipt Histories.Batch IdBATCH_IDBATCH_ID119372
Cash Receipt History IdCash receipt history identifier.Cash Receipt Histories.Cash Receipt History IdCASH_RECEIPT_HISTORY_IDCASH_RECEIPT_HISTORY_ID121647
Cash Receipt IdUnique Identifier for Cash ReceiptCash Receipt Histories.Cash Receipt IdCASH_RECEIPT_IDCASH_RECEIPT_ID121652
Created ByStandard WHO column.Cash Receipt Histories.Created ByCREATED_BYCREATED_BY124529
Creation DateStandard WHO column.Cash Receipt Histories.Creation DateCREATION_DATECREATION_DATE125961
Creation Date - Day Cash Receipt Histories.Creation Date CREATION_DATE_DAY172089
Creation Date - Month Cash Receipt Histories.Creation Date CREATION_DATE_MONTH172543
Creation Date - Quarter Cash Receipt Histories.Creation Date CREATION_DATE_QUARTER172997
Creation Date - Year Cash Receipt Histories.Creation Date CREATION_DATE_YEAR173451
Currency Exchange DateDate exchange rate is effective. Usually the accounting date of the transaction.Cash Receipt Histories.Currency Exchange DateCURRENCY_EXCHANGE_DATECURRENCY_EXCHANGE_DATE127191
Currency Exchange Date - Day Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_DAY174172
Currency Exchange Date - Month Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_MONTH174176
Currency Exchange Date - Quarter Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_QUARTER174180
Currency Exchange Date - Year Cash Receipt Histories.Currency Exchange Date CURRENCY_EXCHANGE_DATE_YEAR174184
Currency Exchange RateExchange rate for foreign currency payments.Cash Receipt Histories.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127196
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Cash Receipt Histories.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127220
Current Record Flag Cash Receipt Histories.Current Record FlagCURRENT_RECORD_FLAGCURRENT_RECORD_FLAG266671
Factor Discount Amount Cash Receipt Histories.Factor Discount AmountFACTOR_DISCOUNT_AMOUNTFACTOR_DISCOUNT_AMOUNT134213
Factoring Flag Cash Receipt Histories.Factoring FlagFACTORING_FLAGFACTORING_FLAG266672
Functional AmountPayment amount in functional currency.Cash Receipt Histories.Functional AmountFUNCTIONAL_AMOUNTFUNCTIONAL_AMOUNT134884
Functional Factor Discount AmountFactor Discount Amount in the functional currencyCash Receipt Histories.Functional Factor Discount AmountFUNC_FACTOR_DISCOUNT_AMOUNTFUNC_FACTOR_DISCOUNT_AMOUNT134931
Last Update DateStandard WHO column.Cash Receipt Histories.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140492
Last Update Date - Day Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_DAY183494
Last Update Date - Month Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_MONTH183922
Last Update Date - Quarter Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_QUARTER184350
Last Update Date - Year Cash Receipt Histories.Last Update Date LAST_UPDATE_DATE_YEAR184778
Last Updated ByStandard WHO column.Cash Receipt Histories.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139153
Note Status Cash Receipt Histories.Note StatusNOTE_STATUSNOTE_STATUS266673
Operating Unit Cash Receipt Histories.Operating UnitOPERATING_UNITOPERATING_UNIT149494
Organization IDOrganization identifier.Cash Receipt Histories.Organization IDORG_IDORG_ID150921
Receipt Batch Name Cash Receipt Histories.Receipt Batch NameRECEIPT_BATCH_NAMERECEIPT_BATCH_NAME157971
Receipt Number Cash Receipt Histories.Receipt NumberRECEIPT_NUMBERRECEIPT_NUMBER158015
Receipt Status Cash Receipt Histories.Receipt StatusRECEIPT_STATUSRECEIPT_STATUS266670
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Cash Receipt Histories -> Bank Statement ReconciliationsCash Receipt Histories.Cash Receipt History Id = Bank Statement Reconciliations.Cash Receipt History IdAlways exist in master folderNoneNo