Powered by InfoCaptor


Previous Page   Next Page

Cash Applications
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CASH_APPLICATIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Allocated Receipt Amount Cash Applications.Allocated Receipt AmountALLOCATED_RECEIPT_AMOUNTALLOCATED_RECEIPT_AMOUNT115482
Allocated Receipt Amount Base Cash Applications.Allocated Receipt Amount BaseALLOCATED_RECEIPT_AMOUNT_BASEALLOCATED_RECEIPT_AMOUNT_BASE115484
Amount Applied Cash Applications.Amount AppliedAMOUNT_APPLIEDAMOUNT_APPLIED115885
Amount Applied Base Cash Applications.Amount Applied BaseAMOUNT_APPLIED_BASEAMOUNT_APPLIED_BASE115889
Application Status Cash Applications.Application StatusAPPLICATION_STATUSAPPLICATION_STATUS266628
Applied Payment Schedule IdUnique Identifier for Applied Payment ScheduleCash Applications.Applied Payment Schedule IdAPPLIED_PAYMENT_SCHEDULE_IDAPPLIED_PAYMENT_SCHEDULE_ID116258
Applied Transaction Number Cash Applications.Applied Transaction NumberAPPLIED_TRANSACTION_NUMBERAPPLIED_TRANSACTION_NUMBER116264
Apply Date Cash Applications.Apply DateAPPLY_DATEAPPLY_DATE116268
Apply Date - Day Cash Applications.Apply Date APPLY_DATE_DAY169003
Apply Date - Month Cash Applications.Apply Date APPLY_DATE_MONTH169007
Apply Date - Quarter Cash Applications.Apply Date APPLY_DATE_QUARTER169011
Apply Date - Year Cash Applications.Apply Date APPLY_DATE_YEAR169015
Base Interest Calculation Cash Applications.Base Interest CalculationGLOBAL_FLEX_BASE_INTEREST_CA_2GLOBAL_FLEX_BASE_INTEREST_CA_2266632
Calculated Interest Cash Applications.Calculated InterestGLOBAL_FLEX_CALCULATED_INT_2_1GLOBAL_FLEX_CALCULATED_INT_2_1266639
Calculated Interest Tmp Cash Applications.Calculated Interest TmpGLOBAL_FLEX_CALCULATED_INTER_2GLOBAL_FLEX_CALCULATED_INTER_2266633
Cash Receipt IdUnique Identifier for Cash ReceiptCash Applications.Cash Receipt IdCASH_RECEIPT_IDCASH_RECEIPT_ID121649
Charges Earned Discount Cash Applications.Charges Earned DiscountCHARGES_EARNED_DISCOUNTCHARGES_EARNED_DISCOUNT121909
Charges Unearned Discount Cash Applications.Charges Unearned DiscountCHARGES_UNEARNED_DISCOUNTCHARGES_UNEARNED_DISCOUNT121911
CommentsFreeform text/comments.Cash Applications.CommentsCOMMENTSCOMMENTS122501
Confirmed Flag Cash Applications.Confirmed FlagCONFIRMED_FLAGCONFIRMED_FLAG266629
Context Value Cash Applications.Context ValueGLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266630
Created ByStandard WHO column.Cash Applications.Created ByCREATED_BYCREATED_BY124526
Creation DateStandard WHO column.Cash Applications.Creation DateCREATION_DATECREATION_DATE125958
Creation Date - Day Cash Applications.Creation Date CREATION_DATE_DAY172083
Creation Date - Month Cash Applications.Creation Date CREATION_DATE_MONTH172537
Creation Date - Quarter Cash Applications.Creation Date CREATION_DATE_QUARTER172991
Creation Date - Year Cash Applications.Creation Date CREATION_DATE_YEAR173445
Cross Currency Rate Cash Applications.Cross Currency RateCROSS_CURRENCY_RATECROSS_CURRENCY_RATE126842
Days Late Cash Applications.Days LateDAYS_LATEDAYS_LATE128666
Earned Discount Cash Applications.Earned DiscountEARNED_DISCOUNTEARNED_DISCOUNT130695
Earned Discount Base Cash Applications.Earned Discount BaseEARNED_DISCOUNT_BASEEARNED_DISCOUNT_BASE130697
Freight Amount Applied Cash Applications.Freight Amount AppliedFREIGHT_AMOUNT_APPLIEDFREIGHT_AMOUNT_APPLIED134652
Freight Earned Discount Cash Applications.Freight Earned DiscountFREIGHT_EARNED_DISCOUNTFREIGHT_EARNED_DISCOUNT134681
Freight Unearned Discount Cash Applications.Freight Unearned DiscountFREIGHT_UNEARNED_DISCOUNTFREIGHT_UNEARNED_DISCOUNT134689
Int Date Cash Applications.Int DateGLOBAL_FLEX_INTEREST_PAYME_2_1GLOBAL_FLEX_INTEREST_PAYME_2_1266641
Interest Difference Action Cash Applications.Interest Difference ActionGLOBAL_FLEX_INTEREST_DIFFERE_2GLOBAL_FLEX_INTEREST_DIFFERE_2266635
Interest Payment Date Cash Applications.Interest Payment DateGLOBAL_FLEX_INTEREST_PAYMENT_2GLOBAL_FLEX_INTEREST_PAYMENT_2266637
Last Update DateStandard WHO column.Cash Applications.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140489
Last Update Date - Day Cash Applications.Last Update Date LAST_UPDATE_DATE_DAY183488
Last Update Date - Month Cash Applications.Last Update Date LAST_UPDATE_DATE_MONTH183916
Last Update Date - Quarter Cash Applications.Last Update Date LAST_UPDATE_DATE_QUARTER184344
Last Update Date - Year Cash Applications.Last Update Date LAST_UPDATE_DATE_YEAR184772
Last Updated ByStandard WHO column.Cash Applications.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139150
Line Amount Applied Cash Applications.Line Amount AppliedLINE_AMOUNT_APPLIEDLINE_AMOUNT_APPLIED144587
Line Earned Discount Cash Applications.Line Earned DiscountLINE_EARNED_DISCOUNTLINE_EARNED_DISCOUNT144616
Line Unearned Discount Cash Applications.Line Unearned DiscountLINE_UNEARNED_DISCOUNTLINE_UNEARNED_DISCOUNT144806
Main Amount Received Cash Applications.Main Amount ReceivedGLOBAL_FLEX_MAIN_AMOUNT_RECE_2GLOBAL_FLEX_MAIN_AMOUNT_RECE_2266631
Operating Unit Cash Applications.Operating UnitOPERATING_UNITOPERATING_UNIT149491
Organization IDOrganization identifier.Cash Applications.Organization IDORG_IDORG_ID150918
Receipt Number Cash Applications.Receipt NumberRECEIPT_NUMBERRECEIPT_NUMBER158012
Receivable Application IdUnique Identifier for Receivable ApplicationCash Applications.Receivable Application IdRECEIVABLE_APPLICATION_IDRECEIVABLE_APPLICATION_ID158035
Receivables Charges Applied Cash Applications.Receivables Charges AppliedRECEIVABLES_CHARGES_APPLIEDRECEIVABLES_CHARGES_APPLIED158029
Received Interest Cash Applications.Received InterestGLOBAL_FLEX_RECEIVED_INTER_2_1GLOBAL_FLEX_RECEIVED_INTER_2_1266640
Received Interest Tmp Cash Applications.Received Interest TmpGLOBAL_FLEX_RECEIVED_INTERES_2GLOBAL_FLEX_RECEIVED_INTERES_2266634
Tax Amount Applied Cash Applications.Tax Amount AppliedTAX_AMOUNT_APPLIEDTAX_AMOUNT_APPLIED164700
Tax Earned Discount Cash Applications.Tax Earned DiscountTAX_EARNED_DISCOUNTTAX_EARNED_DISCOUNT164731
Tax Unearned Discount Cash Applications.Tax Unearned DiscountTAX_UNEARNED_DISCOUNTTAX_UNEARNED_DISCOUNT164812
Transaction Line IdUnique Identifier for Transaction LineCash Applications.Transaction Line IdTRANSACTION_LINE_IDTRANSACTION_LINE_ID165712
Transaction Line NumberThe user-defined sequence number for a GIS transaction line.Cash Applications.Transaction Line NumberTRANSACTION_LINE_NUMBERTRANSACTION_LINE_NUMBER165719
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Cash Applications.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167043
Unearned Discount Cash Applications.Unearned DiscountUNEARNED_DISCOUNTUNEARNED_DISCOUNT166217
Unearned Discount Base Cash Applications.Unearned Discount BaseUNEARNED_DISCOUNT_BASEUNEARNED_DISCOUNT_BASE166219
Write Off Reason Cash Applications.Write Off ReasonGLOBAL_FLEX_WRITE_OFF_REASON_2GLOBAL_FLEX_WRITE_OFF_REASON_2266636
WriteOff Date Cash Applications.WriteOff DateGLOBAL_FLEX_WRITE_OFF_DATE_2GLOBAL_FLEX_WRITE_OFF_DATE_2266638
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Cash Applications -> Application DistributionsCash Applications.Receivable Application Id = Application Distributions.Receivable Application IdAlways exist in master folderOuter join on detail No
Cash Applications -> Invoice AdjustmentsCash Applications.Receivable Application Id = Invoice Adjustments.Associated Application IdAlways exist in master folderNoneNo
Cash Applications -> Invoice Adjustments 1Cash Applications.Receivable Application Id = Invoice Adjustments.Associated Application IdAlways exist in master folderNoneNo