Powered by InfoCaptor


Previous Page   Next Page

Payment Terms
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_AP_PAYMENT_TERMSUnknown
NoneNone.APFG_AP_PAYMENT_TERMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created ByStandard WHO column.Payment Terms.Created ByCREATED_BYCREATED_BY124520
Creation DateStandard WHO column.Payment Terms.Creation DateCREATION_DATECREATION_DATE125952
DescriptionDescriptione of payment terms.Payment Terms.DescriptionDESCRIPTIONDESCRIPTION129520
Due Cutoff DayUsed for proxima terms only, day of a month after which Oracle Payables schedules payment using a day after the current month.Payment Terms.Due Cutoff DayDUE_CUTOFF_DAYDUE_CUTOFF_DAY130631
End Effective DateDate to which payment term is invalid.Payment Terms.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133093
End Effective Date Day Payment Terms.End Effective Date END_EFFECTIVE_DATE_DAY178573
End Effective Date Month Payment Terms.End Effective Date END_EFFECTIVE_DATE_MONTH178669
End Effective Date Quarter Payment Terms.End Effective Date END_EFFECTIVE_DATE_QUARTER178765
End Effective Date Year Payment Terms.End Effective Date END_EFFECTIVE_DATE_YEAR178861
Last Update DateStandard WHO column.Payment Terms.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140483
Last Updated ByStandard WHO column.Payment Terms.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139144
Payment Term IdTerm unique identifier.Payment Terms.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152295
Payment Term NameName of payment terms.Payment Terms.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152299
RankUnique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act.Payment Terms.RankRANKRANK157480
Start Effective DateDate from which payment term is valid.Payment Terms.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163255
Start Effective Date Day Payment Terms.Start Effective Date START_EFFECTIVE_DATE_DAY191107
Start Effective Date Month Payment Terms.Start Effective Date START_EFFECTIVE_DATE_MONTH191193
Start Effective Date Quarter Payment Terms.Start Effective Date START_EFFECTIVE_DATE_QUARTER191279
Start Effective Date Year Payment Terms.Start Effective Date START_EFFECTIVE_DATE_YEAR191365
Created ByStandard WHO column.Payment Terms.Created ByCREATED_BYCREATED_BY124520
Creation DateStandard WHO column.Payment Terms.Creation DateCREATION_DATECREATION_DATE125952
DescriptionDescriptione of payment terms.Payment Terms.DescriptionDESCRIPTIONDESCRIPTION129520
Due Cutoff DayUsed for proxima terms only, day of a month after which Oracle Payables schedules payment using a day after the current month.Payment Terms.Due Cutoff DayDUE_CUTOFF_DAYDUE_CUTOFF_DAY130631
End Effective DateDate to which payment term is invalid.Payment Terms.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133093
End Effective Date Day Payment Terms.End Effective Date END_EFFECTIVE_DATE_DAY178573
End Effective Date Month Payment Terms.End Effective Date END_EFFECTIVE_DATE_MONTH178669
End Effective Date Quarter Payment Terms.End Effective Date END_EFFECTIVE_DATE_QUARTER178765
End Effective Date Year Payment Terms.End Effective Date END_EFFECTIVE_DATE_YEAR178861
Last Update DateStandard WHO column.Payment Terms.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140483
Last Updated ByStandard WHO column.Payment Terms.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139144
Payment Term IdTerm unique identifier.Payment Terms.Payment Term IdPAYMENT_TERM_IDPAYMENT_TERM_ID152295
Payment Term NameName of payment terms.Payment Terms.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152299
RankUnique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act.Payment Terms.RankRANKRANK157480
Start Effective DateDate from which payment term is valid.Payment Terms.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163255
Start Effective Date Day Payment Terms.Start Effective Date START_EFFECTIVE_DATE_DAY191107
Start Effective Date Month Payment Terms.Start Effective Date START_EFFECTIVE_DATE_MONTH191193
Start Effective Date Quarter Payment Terms.Start Effective Date START_EFFECTIVE_DATE_QUARTER191279
Start Effective Date Year Payment Terms.Start Effective Date START_EFFECTIVE_DATE_YEAR191365
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Payment Terms -> InvoicesPayment Terms.Payment Term Id = Invoices.Terms IdAlways exist in master folderNoneNo
Payment Terms -> PA Customer AgreementsPayment Terms.Payment Term Id = PA Customer Agreements.Term IdAlways exist in master folderNoneNo