Powered by InfoCaptor


Previous Page   Next Page

Cash Receipts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CASH_RECEIPTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Anticipated Clearing Date Cash Receipts.Anticipated Clearing DateANTICIPATED_CLEARING_DATEANTICIPATED_CLEARING_DATE116046
Anticipated Clearing Date - Day Cash Receipts.Anticipated Clearing Date ANTICIPATED_CLEARING_DATE_DAY168966
Anticipated Clearing Date - Month Cash Receipts.Anticipated Clearing Date ANTICIPATED_CLEARING_DATE_MONTH168968
Anticipated Clearing Date - Quarter Cash Receipts.Anticipated Clearing Date ANTICIPATED_CLEARING_DATE_QUARTER168970
Anticipated Clearing Date - Year Cash Receipts.Anticipated Clearing Date ANTICIPATED_CLEARING_DATE_YEAR168972
Cash Receipt IdUnique Identifier for Cash ReceiptCash Receipts.Cash Receipt IdCASH_RECEIPT_IDCASH_RECEIPT_ID121651
CommentsFreeform text/comments.Cash Receipts.CommentsCOMMENTSCOMMENTS122502
Context Value Cash Receipts.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266659
Created ByStandard WHO column.Cash Receipts.Created ByCREATED_BYCREATED_BY124528
Creation DateStandard WHO column.Cash Receipts.Creation DateCREATION_DATECREATION_DATE125960
Creation Date - Day Cash Receipts.Creation Date CREATION_DATE_DAY172087
Creation Date - Month Cash Receipts.Creation Date CREATION_DATE_MONTH172541
Creation Date - Quarter Cash Receipts.Creation Date CREATION_DATE_QUARTER172995
Creation Date - Year Cash Receipts.Creation Date CREATION_DATE_YEAR173449
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Cash Receipts.Currency CodeCURRENCY_CODECURRENCY_CODE126993
Currency Description Cash Receipts.Currency DescriptionCURRENCY_DESCRIPTIONCURRENCY_DESCRIPTION127187
Currency Exchange RateExchange rate for foreign currency payments.Cash Receipts.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127195
Currency Exchange Rate Date Cash Receipts.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127207
Currency Exchange Rate Date - Day Cash Receipts.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174194
Currency Exchange Rate Date - Month Cash Receipts.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174210
Currency Exchange Rate Date - Quarter Cash Receipts.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174226
Currency Exchange Rate Date - Year Cash Receipts.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174242
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Cash Receipts.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127219
Customer Bank Account IDUnique Identifier for Customer Bank AccountCash Receipts.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127526
Customer Bank Account NumberCustomer Bank Account NumberCash Receipts.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127541
Customer Bank Branch Name Cash Receipts.Customer Bank Branch NameCUSTOMER_BANK_BRANCH_NAMECUSTOMER_BANK_BRANCH_NAME127546
Customer Bank Name Cash Receipts.Customer Bank NameCUSTOMER_BANK_NAMECUSTOMER_BANK_NAME127547
Customer Name Cash Receipts.Customer NameCUSTOMER_NAMECUSTOMER_NAME127657
Customer Receipt Reference Cash Receipts.Customer Receipt ReferenceCUSTOMER_RECEIPT_REFERENCECUSTOMER_RECEIPT_REFERENCE127747
Customer Site Use IdUnique Identifier for Customer Site UseCash Receipts.Customer Site Use IdCUSTOMER_SITE_USE_IDCUSTOMER_SITE_USE_ID127760
Deposit Date Cash Receipts.Deposit DateDEPOSIT_DATEDEPOSIT_DATE129219
Deposit Date - Day Cash Receipts.Deposit Date DEPOSIT_DATE_DAY176101
Deposit Date - Month Cash Receipts.Deposit Date DEPOSIT_DATE_MONTH176103
Deposit Date - Quarter Cash Receipts.Deposit Date DEPOSIT_DATE_QUARTER176105
Deposit Date - Year Cash Receipts.Deposit Date DEPOSIT_DATE_YEAR176107
Document Category Cash Receipts.Document CategoryGLOBAL_FLEX_DOCUMENT_CATEGOR_3GLOBAL_FLEX_DOCUMENT_CATEGOR_3266662
Document Category 1 Cash Receipts.Document Category 1GLOBAL_FLEX_DOCUMENT_CATEGOR_4GLOBAL_FLEX_DOCUMENT_CATEGOR_4266665
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.Cash Receipts.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130357
Factor Discount Amount Cash Receipts.Factor Discount AmountFACTOR_DISCOUNT_AMOUNTFACTOR_DISCOUNT_AMOUNT134212
Factoring Flag Cash Receipts.Factoring FlagFACTORING_FLAGFACTORING_FLAG266657
Global Flex Receipt Acknowle 3 Cash Receipts.Global Flex Receipt Acknowle 3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3GLOBAL_FLEX_RECEIPT_ACKNOWLE_3266660
Global Flex Receipt Acknowle 4 Cash Receipts.Global Flex Receipt Acknowle 4GLOBAL_FLEX_RECEIPT_ACKNOWLE_4GLOBAL_FLEX_RECEIPT_ACKNOWLE_4266663
Issuer Bank Branch IdUnique Identifier for Issuer Bank BranchCash Receipts.Issuer Bank Branch IdISSUER_BANK_BRANCH_IDISSUER_BANK_BRANCH_ID137624
Issuer Bank Branch Name Cash Receipts.Issuer Bank Branch NameISSUER_BANK_BRANCH_NAMEISSUER_BANK_BRANCH_NAME137626
Issuer Bank Name Cash Receipts.Issuer Bank NameISSUER_BANK_NAMEISSUER_BANK_NAME137627
Last Update DateStandard WHO column.Cash Receipts.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140491
Last Update Date - Day Cash Receipts.Last Update Date LAST_UPDATE_DATE_DAY183492
Last Update Date - Month Cash Receipts.Last Update Date LAST_UPDATE_DATE_MONTH183920
Last Update Date - Quarter Cash Receipts.Last Update Date LAST_UPDATE_DATE_QUARTER184348
Last Update Date - Year Cash Receipts.Last Update Date LAST_UPDATE_DATE_YEAR184776
Last Updated ByStandard WHO column.Cash Receipts.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139152
LocationA shorthand way to refer to a customer address.Cash Receipts.LocationLOCATIONLOCATION144996
Note Receivable Issue Date Cash Receipts.Note Receivable Issue DateNOTE_RECEIVABLE_ISSUE_DATENOTE_RECEIVABLE_ISSUE_DATE148518
Note Receivable Issue Date - Day Cash Receipts.Note Receivable Issue Date NOTE_RECEIVABLE_ISSUE_DATE_DAY186986
Note Receivable Issue Date - Month Cash Receipts.Note Receivable Issue Date NOTE_RECEIVABLE_ISSUE_DATE_MONTH186988
Note Receivable Issue Date - Quarter Cash Receipts.Note Receivable Issue Date NOTE_RECEIVABLE_ISSUE_DATE_QUARTER186990
Note Receivable Issue Date - Year Cash Receipts.Note Receivable Issue Date NOTE_RECEIVABLE_ISSUE_DATE_YEAR186992
Note Receivable Issuer Name Cash Receipts.Note Receivable Issuer NameNOTE_RECEIVABLE_ISSUER_NAMENOTE_RECEIVABLE_ISSUER_NAME148516
Operating Unit Cash Receipts.Operating UnitOPERATING_UNITOPERATING_UNIT149493
Organization IDOrganization identifier.Cash Receipts.Organization IDORG_IDORG_ID150920
Override Remit Account Cash Receipts.Override Remit AccountOVERRIDE_REMIT_ACCOUNTOVERRIDE_REMIT_ACCOUNT266658
Package Number Cash Receipts.Package NumberGLOBAL_FLEX_PACKAGE_NUMBER_5GLOBAL_FLEX_PACKAGE_NUMBER_5266666
Pay From Customer Cash Receipts.Pay From CustomerPAY_FROM_CUSTOMERPAY_FROM_CUSTOMER152510
Payment Method Name Cash Receipts.Payment Method NamePAYMENT_METHOD_NAMEPAYMENT_METHOD_NAME152235
Receipt Acknowledgement Number Cash Receipts.Receipt Acknowledgement NumberGLOBAL_FLEX_RECEIPT_ACKNOW_3_1GLOBAL_FLEX_RECEIPT_ACKNOW_3_1266661
Receipt Acknowledgment Number Cash Receipts.Receipt Acknowledgment NumberGLOBAL_FLEX_RECEIPT_ACKNOW_4_1GLOBAL_FLEX_RECEIPT_ACKNOW_4_1266664
Receipt Amount Cash Receipts.Receipt AmountRECEIPT_AMOUNTRECEIPT_AMOUNT157969
Receipt Date Cash Receipts.Receipt DateRECEIPT_DATERECEIPT_DATE157979
Receipt Date - Day Cash Receipts.Receipt Date RECEIPT_DATE_DAY189405
Receipt Date - Month Cash Receipts.Receipt Date RECEIPT_DATE_MONTH189411
Receipt Date - Quarter Cash Receipts.Receipt Date RECEIPT_DATE_QUARTER189417
Receipt Date - Year Cash Receipts.Receipt Date RECEIPT_DATE_YEAR189423
Receipt Method IdUnique Identifier for Receipt MethodCash Receipts.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157997
Receipt Number Cash Receipts.Receipt NumberRECEIPT_NUMBERRECEIPT_NUMBER158014
Receipt Status Cash Receipts.Receipt StatusRECEIPT_STATUSRECEIPT_STATUS266654
Remittance Bank Account IDUnique Identifier for Remittance Bank AccountCash Receipts.Remittance Bank Account IDREMITTANCE_BANK_ACCOUNT_IDREMITTANCE_BANK_ACCOUNT_ID158536
Remittance Bank Account NumberRemittance Bank Account NumberCash Receipts.Remittance Bank Account NumberREMITTANCE_BANK_ACCOUNT_NUMBERREMITTANCE_BANK_ACCOUNT_NUMBER158538
Remittance Bank Branch Name Cash Receipts.Remittance Bank Branch NameREMITTANCE_BANK_BRANCH_NAMEREMITTANCE_BANK_BRANCH_NAME158539
Remittance Bank Name Cash Receipts.Remittance Bank NameREMITTANCE_BANK_NAMEREMITTANCE_BANK_NAME158540
Reversal Category Cash Receipts.Reversal CategoryREVERSAL_CATEGORYREVERSAL_CATEGORY266656
Reversal Comments Cash Receipts.Reversal CommentsREVERSAL_COMMENTSREVERSAL_COMMENTS159446
Reversal DateThe journal entry reversal effective date.Cash Receipts.Reversal DateREVERSAL_DATEREVERSAL_DATE159448
Reversal Date - Day Cash Receipts.Reversal Date REVERSAL_DATE_DAY189886
Reversal Date - Month Cash Receipts.Reversal Date REVERSAL_DATE_MONTH189890
Reversal Date - Quarter Cash Receipts.Reversal Date REVERSAL_DATE_QUARTER189894
Reversal Date - Year Cash Receipts.Reversal Date REVERSAL_DATE_YEAR189898
Reversal Reason Cash Receipts.Reversal ReasonREVERSAL_REASONREVERSAL_REASON266655
Tax Regime Reporting Code Cash Receipts.Tax Regime Reporting CodeGLOBAL_FLEX_TAX_REGIME_REPOR_5GLOBAL_FLEX_TAX_REGIME_REPOR_5266669
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Cash Receipts.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167044
Withholding Certificate Date Cash Receipts.Withholding Certificate DateGLOBAL_FLEX_WITHHOLDING_CERT_5GLOBAL_FLEX_WITHHOLDING_CERT_5266667
Withholding Certificate Number Cash Receipts.Withholding Certificate NumberGLOBAL_FLEX_WITHHOLDING_CE_5_1GLOBAL_FLEX_WITHHOLDING_CE_5_1266668
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Cash Receipts -> Cash ApplicationsCash Receipts.Cash Receipt Id = Cash Applications.Cash Receipt IdMight not exist in master folderOuter join on master No
Cash Receipts -> Cash DistributionsCash Receipts.Cash Receipt Id = Cash Distributions.Cash Receipt IdAlways exist in master folderOuter join on detail No
Cash Receipts -> Cash Receipt HistoriesCash Receipts.Cash Receipt Id = Cash Receipt Histories.Cash Receipt IdAlways exist in master folderOuter join on detail No
Cash Receipts -> Payment SchedulesCash Receipts.Cash Receipt Id = Payment Schedules.Cash Receipt IdMight not exist in master folderNoneNo
Cash Receipts -> Payment Schedules 1Cash Receipts.Cash Receipt Id = Payment Schedules.Cash Receipt IdAlways exist in master folderNoneNo