Payment Increase Agreement Template
These are the payment increase agreement template setups.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.PaymentIncreaseAgreementTemplatesExtractPVO
Primary Keys : PymtIncrAgrmtTmplIncrementTemplateId
Initial Extract Date : PymtIncrAgrmtTmplCreationDate
Incremental Extract Date : PymtIncrAgrmtTmplLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| PymtIncrAgrmtTmplActivationDerivationCode | Indicates the way the missing index should be derived during the activation of payment increase agreement |
| PymtIncrAgrmtTmplAgreementDescription | The payment increase agreement template description. |
| PymtIncrAgrmtTmplAssessInYearsNum | Defines the breaks for the assessment. This is applicable if the assessment frequency is annual only. |
| PymtIncrAgrmtTmplAssessmentDerivationCode | Indicates the way the missing index should be derived during the assessment of an assessment period |
| PymtIncrAgrmtTmplAssessmentFrequencyCode | This is the assessment frequency. User choices are annual or semiannual. |
| PymtIncrAgrmtTmplAttribute1 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute10 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute11 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute12 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute13 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute14 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute15 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute2 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute3 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute4 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute5 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute6 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute7 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute8 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttribute9 | A segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeCategory | The structure definition of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeDate1 | A date segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeDate2 | A date segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeDate3 | A date segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeDate4 | A date segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeDate5 | A date segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeNumber1 | A number segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeNumber2 | A number segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeNumber3 | A number segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeNumber4 | A number segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplAttributeNumber5 | A number segment of the user descriptive flexfield. |
| PymtIncrAgrmtTmplBasisCompoundingCode | Defines whether payment increases compound when the payment basis is amount. |
| PymtIncrAgrmtTmplBasisFactorPercent | Defines the basis factor percent which will be defaulted when the assessment periods are generated. |
| PymtIncrAgrmtTmplBasisTypeCode | This is the basis type, which defines how the basis amount is calculated. User choices are previous cycle or current cycle. |
| PymtIncrAgrmtTmplBillToCustomerId | This is the bill-to customer defined in the payment increase agreement template. |
| PymtIncrAgrmtTmplBillToSiteUseId | This is the bill-to site defined in the payment increase agreement template. |
| PymtIncrAgrmtTmplCreatedBy | The user who created the row. |
| PymtIncrAgrmtTmplCreationDate | The row's creation date and time. |
| PymtIncrAgrmtTmplCustomerTrxTypeId | This is the transaction type identifier to be sent to Receivables. |
| PymtIncrAgrmtTmplFixedIncreaseAmount | This is the fixed increase amount which will be defaulted when the assessment periods are generated. |
| PymtIncrAgrmtTmplFixedIncreasePercent | This is the fixed increase percent which will be defaulted when the assessment periods are generated. |
| PymtIncrAgrmtTmplIncreaseAmountRoundingCode | This is the rounding code indicating how to round off the increase amount. |
| PymtIncrAgrmtTmplIncreaseCalcMethodCode | Defines whether the payment increase is index based or fixed rate based, or a combination of both. |
| PymtIncrAgrmtTmplIncrementIndexHeaderId | This is the payment increase index identifier referenced from FLA_INCREMENT_INDEX_HDRS_ALL. |
| PymtIncrAgrmtTmplIncrementTemplateId | This is the payment increase agreement template identifier. |
| PymtIncrAgrmtTmplIncrementTemplateNumber | The payment increase agreement template number. |
| PymtIncrAgrmtTmplIndexFinderMonths | Indicates the number of months over which the system attempts to find an index value to apply to the payment increase. |
| PymtIncrAgrmtTmplLastUpdateDate | The row's last update date and time. |
| PymtIncrAgrmtTmplLastUpdateLogin | The session's login associated to the user who last updated the row. |
| PymtIncrAgrmtTmplLastUpdatedBy | Indicates the user who last updated the row. |
| PymtIncrAgrmtTmplMaximumIncreasePercent | This is the maximum increase percent. |
| PymtIncrAgrmtTmplMinimumIncreasePercent | This is the minimum increase percent. |
| PymtIncrAgrmtTmplObjectVersionNumber | This is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| PymtIncrAgrmtTmplOrgId | The business unit associated to the row. |
| PymtIncrAgrmtTmplPaymentCurrencyCode | This is the payment increase agreement's currency. |
| PymtIncrAgrmtTmplPaymentPurposeCode | This is the payment purpose. Values are populated from the lookup FND_LOOKUPS where the lookup type is FLA_PAYMENT_PURPOSE. |
| PymtIncrAgrmtTmplResponsibleUserName | This is the name of the user responsible for the lease agreement template. |
| PymtIncrAgrmtTmplScheduleTypeCode | Indicates the type of payment increase agreement template, user choices are revenue and expense. |
| PymtIncrAgrmtTmplShipToSiteUseId | This is the ship-to customer site identifier. |
| PymtIncrAgrmtTmplTemplateEndDate | This is the end date of the payment increase agreement template. |
| PymtIncrAgrmtTmplTemplateName | This is the payment increase agreement template name. |
| PymtIncrAgrmtTmplTemplateStartDate | The start date of the payment increase agreement template. |
| PymtIncrAgrmtTmplTemplateStatusCode | Indicates the payment increase agreement template status. |
| PymtIncrAgrmtTmplUnusedIncreaseTreatmentCode | Indicates the way the unused increase amount should be treated. |
| PymtIncrAgrmtTmplVendorId | This the supplier identifier that's sent to Oracle Payables during the payment process. |