Powered by InfoCaptor


Previous Page   Next Page

AP Payment Schedules
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_PAYMENT_SCHEDULESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Amount RemainingThe invoice amount remaining for payment.AP Payment Schedules.Amount RemainingAMOUNT_REMAININGAMOUNT_REMAINING115907
Associated AP Payment Schedules.AssociatedGLBL_ASSOCIATED_2GLBL_ASSOCIATED_2266427
BANK_COLLECTION_ID AP Payment Schedules.BANK_COLLECTION_IDGLBL_BANK_COLLECTION_ID_2GLBL_BANK_COLLECTION_ID_2266428
Context Value AP Payment Schedules.Context ValueGLBL_CONTEXT_VALUEGLBL_CONTEXT_VALUE266419
Created ByStandard WHO columnAP Payment Schedules.Created ByCREATED_BYCREATED_BY124519
Creation DateStandard WHO columnAP Payment Schedules.Creation DateCREATION_DATECREATION_DATE125951
Discount Amount AvailableThe discount amount available at the first discount date.AP Payment Schedules.Discount Amount AvailableDISCOUNT_AMOUNT_AVAILABLEDISCOUNT_AMOUNT_AVAILABLE130151
Discount Amount RemainingThe remaining discount amount still available for payment.AP Payment Schedules.Discount Amount RemainingDISCOUNT_AMOUNT_REMAININGDISCOUNT_AMOUNT_REMAINING130152
Discount DateThe date the first discount is available.AP Payment Schedules.Discount DateDISCOUNT_DATEDISCOUNT_DATE130153
Discount Date Day AP Payment Schedules.Discount Date DISCOUNT_DATE_DAY176253
Discount Date Month AP Payment Schedules.Discount Date DISCOUNT_DATE_MONTH176255
Discount Date Quarter AP Payment Schedules.Discount Date DISCOUNT_DATE_QUARTER176257
Discount Date Year AP Payment Schedules.Discount Date DISCOUNT_DATE_YEAR176259
Due DateThe payment due date of the invoice.AP Payment Schedules.Due DateDUE_DATEDUE_DATE130632
Due Date Day AP Payment Schedules.Due Date DUE_DATE_DAY176335
Due Date Month AP Payment Schedules.Due Date DUE_DATE_MONTH176351
Due Date Quarter AP Payment Schedules.Due Date DUE_DATE_QUARTER176367
Due Date Year AP Payment Schedules.Due Date DUE_DATE_YEAR176383
External Bank Account IDThe Unique system ID of the External bank accountAP Payment Schedules.External Bank Account IDEXTERNAL_BANK_ACCOUNT_IDEXTERNAL_BANK_ACCOUNT_ID134148
Future Pay Due DateThe negotiable date for future dated payment.AP Payment Schedules.Future Pay Due DateFUTURE_PAY_DUE_DATEFUTURE_PAY_DUE_DATE134972
Future Pay Due Date Day AP Payment Schedules.Future Pay Due Date FUTURE_PAY_DUE_DATE_DAY180577
Future Pay Due Date Month AP Payment Schedules.Future Pay Due Date FUTURE_PAY_DUE_DATE_MONTH180581
Future Pay Due Date Quarter AP Payment Schedules.Future Pay Due Date FUTURE_PAY_DUE_DATE_QUARTER180585
Future Pay Due Date Year AP Payment Schedules.Future Pay Due Date FUTURE_PAY_DUE_DATE_YEAR180589
Gross AmountThe gross amount due for a scheduled payment.AP Payment Schedules.Gross AmountGROSS_AMOUNTGROSS_AMOUNT135479
Hold FlagYes/No flag that indicates if a scheduled payment is on hold.AP Payment Schedules.Hold FlagHOLD_FLAGHOLD_FLAG135845
Interest Formula AP Payment Schedules.Interest FormulaGLBL_INTEREST_FORMULA_2GLBL_INTEREST_FORMULA_2266423
Interest Grace Days AP Payment Schedules.Interest Grace DaysGLBL_INTEREST_GRACE_DAYS_2GLBL_INTEREST_GRACE_DAYS_2266424
Interest Period AP Payment Schedules.Interest PeriodGLBL_INTEREST_PERIOD_2GLBL_INTEREST_PERIOD_2266422
Interest Rate / Amount AP Payment Schedules.Interest Rate / AmountGLBL_INTEREST_RATE_AMOUNT_2GLBL_INTEREST_RATE_AMOUNT_2266421
Interest Type AP Payment Schedules.Interest TypeGLBL_INTEREST_TYPE_2GLBL_INTEREST_TYPE_2266420
Invoice CurrencyThe currency code of the invoice. Note, the invoice currency and payment currency must be the same.AP Payment Schedules.Invoice CurrencyINVOICE_CURRENCYINVOICE_CURRENCY137401
Invoice DateThe invoice date for this payment schedule.AP Payment Schedules.Invoice DateINVOICE_DATEINVOICE_DATE137417
Invoice Date Day AP Payment Schedules.Invoice Date INVOICE_DATE_DAY181642
Invoice Date Month AP Payment Schedules.Invoice Date INVOICE_DATE_MONTH181652
Invoice Date Quarter AP Payment Schedules.Invoice Date INVOICE_DATE_QUARTER181662
Invoice Date Year AP Payment Schedules.Invoice Date INVOICE_DATE_YEAR181680
Invoice IdUnique system ID for this invoiceAP Payment Schedules.Invoice IdINVOICE_IDINVOICE_ID137439
Invoice NumberThe invoice number for this payment schedule.AP Payment Schedules.Invoice NumberINVOICE_NUMBERINVOICE_NUMBER137462
Invoice Type AP Payment Schedules.Invoice TypeINVOICE_TYPEINVOICE_TYPE266416
Last Update DateStandard WHO columnAP Payment Schedules.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140482
Last Update LoginStandard WHO columnAP Payment Schedules.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141443
Last Updated ByStandard WHO columnAP Payment Schedules.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139143
Payment CurrencyThe currency code of the payment. Note, the payment currency and invoice currency must be the same.AP Payment Schedules.Payment CurrencyPAYMENT_CURRENCYPAYMENT_CURRENCY152192
Payment GroupThe name of the pay group. The names are delivered in Oracle Payables as a list of values, but are not delivered in the view.AP Payment Schedules.Payment GroupPAYMENT_GROUPPAYMENT_GROUP152209
Payment NumberThe payment number of the scheduled payment.AP Payment Schedules.Payment NumberPAYMENT_NUMBERPAYMENT_NUMBER152238
Payment PriorityThe number representing the payment priority of a scheduled payment (1-99)AP Payment Schedules.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152242
Payment Status AP Payment Schedules.Payment StatusPAYMENT_STATUSPAYMENT_STATUS266417
Penalty Rate / Amount AP Payment Schedules.Penalty Rate / AmountGLBL_PENALTY_RATE_AMOUNT_2GLBL_PENALTY_RATE_AMOUNT_2266426
Penalty Type AP Payment Schedules.Penalty TypeGLBL_PENALTY_TYPE_2GLBL_PENALTY_TYPE_2266425
Pmt Method Lookup Code AP Payment Schedules.Pmt Method Lookup CodePMT_METHOD_LOOKUP_CODEPMT_METHOD_LOOKUP_CODE266418
Second Discount Amt AvailableThe discount amount available at the second discount date.AP Payment Schedules.Second Discount Amt AvailableSECOND_DISC_AMT_AVAILABLESECOND_DISC_AMT_AVAILABLE160966
Second Discount DateThe date the second discount is available.AP Payment Schedules.Second Discount DateSECOND_DISCOUNT_DATESECOND_DISCOUNT_DATE160965
Second Discount Date Day AP Payment Schedules.Second Discount Date SECOND_DISCOUNT_DATE_DAY190245
Second Discount Date Month AP Payment Schedules.Second Discount Date SECOND_DISCOUNT_DATE_MONTH190247
Second Discount Date Quarter AP Payment Schedules.Second Discount Date SECOND_DISCOUNT_DATE_QUARTER190249
Second Discount Date Year AP Payment Schedules.Second Discount Date SECOND_DISCOUNT_DATE_YEAR190251
Third Discount Amt AvailableThe discount amount available at the third discount date.AP Payment Schedules.Third Discount Amt AvailableTHIRD_DISC_AMT_AVAILABLETHIRD_DISC_AMT_AVAILABLE165077
Third Discount DateThe date the third discount is available.AP Payment Schedules.Third Discount DateTHIRD_DISCOUNT_DATETHIRD_DISCOUNT_DATE165076
Third Discount Date Day AP Payment Schedules.Third Discount Date THIRD_DISCOUNT_DATE_DAY192104
Third Discount Date Month AP Payment Schedules.Third Discount Date THIRD_DISCOUNT_DATE_MONTH192106
Third Discount Date Quarter AP Payment Schedules.Third Discount Date THIRD_DISCOUNT_DATE_QUARTER192108
Third Discount Date Year AP Payment Schedules.Third Discount Date THIRD_DISCOUNT_DATE_YEAR192110
Vendor NameThe name of the supplier in which payment is made.AP Payment Schedules.Vendor NameVENDOR_NAMEVENDOR_NAME167448
Vendor NumberThe supplier number that corresponds to the supplier name in which payment is made.AP Payment Schedules.Vendor NumberVENDOR_NUMBERVENDOR_NUMBER167466
Vendor Site IDThe supplier site of the supplier to which payment is made.AP Payment Schedules.Vendor Site IDVENDOR_SITE_IDVENDOR_SITE_ID167478
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto