Lease Increment Headers
These are lease increment headers.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.LeaseIncrementHeadersExtractPVO
Primary Keys : LeaseIncrementHeaderIncrementHeaderId
Initial Extract Date : LeaseIncrementHeaderCreationDate
Incremental Extract Date : LeaseIncrementHeaderLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| LeaseIncrementHeaderActivationDerivationCode | Specifies how the missing index is to be derived during the activation of the payment increase agreement. |
| LeaseIncrementHeaderAgreementDescription | The description of payment increase agreement. |
| LeaseIncrementHeaderAgreementEndDate | The end date of the payment increase agreement. |
| LeaseIncrementHeaderAgreementName | The payment increase agreement name. |
| LeaseIncrementHeaderAgreementNumber | The payment increase agreement number. |
| LeaseIncrementHeaderAgreementSignedDate | The date on which the payment increase agreement was signed. |
| LeaseIncrementHeaderAgreementStartDate | The start date of the payment increase agreement. |
| LeaseIncrementHeaderAgreementStatusCode | The status of the payment increase agreement. |
| LeaseIncrementHeaderAgreementTerminationDate | The termination date of the payment increase agreement. |
| LeaseIncrementHeaderAssessInYearsNum | Defines the breaks for the assessment. This is applicable if the assessment frequency is annual. |
| LeaseIncrementHeaderAssessmentDerivationCode | Indicates the way the missing index should be derived during assessment of an assessment period. |
| LeaseIncrementHeaderAssessmentFrequencyCode | The assessment frequency. Possible values are annual or semiannual. |
| LeaseIncrementHeaderAttribute1 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute10 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute11 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute12 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute13 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute14 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute15 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute2 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute3 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute4 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute5 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute6 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute7 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute8 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttribute9 | A segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeCategory | The structure definition of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeDate1 | A date segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeDate2 | A date segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeDate3 | A date segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeDate4 | A date segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeDate5 | A date segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeNumber1 | A number segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeNumber2 | A number segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeNumber3 | A number segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeNumber4 | A number segment of the user descriptive flexfield. |
| LeaseIncrementHeaderAttributeNumber5 | A number segment of the user descriptive flexfield. |
| LeaseIncrementHeaderBaseIndexValue | The base index value specified for a fixed index type. |
| LeaseIncrementHeaderBasisCompoundingCode | Defines if compounding of payment basis amount is applicable. |
| LeaseIncrementHeaderBasisFactorPercent | This is the basis factor percent which will be applicable as default when the assessment periods are generated. |
| LeaseIncrementHeaderBasisTypeCode | The basis type defines how the basis amount is arrived at. Possible values are previous cycle or current cycle. |
| LeaseIncrementHeaderBillToCustomerId | The bill-to customer's unique identifier for the billing. |
| LeaseIncrementHeaderBillToSiteUseId | The bill-to customer site use identifier. |
| LeaseIncrementHeaderChangeTypeCode | Indicates the type of change to the record, such as insert, update, or delete. |
| LeaseIncrementHeaderChangedInVersionNum | The version number where the change occurred. |
| LeaseIncrementHeaderCreatedBy | Indicates the user who created the row. |
| LeaseIncrementHeaderCreationDate | Indicates the date and time of the creation of the row. |
| LeaseIncrementHeaderCustomerTrxTypeId | The transaction type identifier to be sent to receivables. |
| LeaseIncrementHeaderDataSourceCode | This is the feeder system from which lease data was created. |
| LeaseIncrementHeaderFirstAssessmentDate | The date when the first assessment of the agreement starts. |
| LeaseIncrementHeaderFixedIncreaseAmount | The fixed increase amount which will be applicable as default when the assessment periods are generated. |
| LeaseIncrementHeaderFixedIncreasePercent | The fixed increase percent which will be applicable as default when the assessment periods are generated. |
| LeaseIncrementHeaderIncreaseAmountRoundingCode | The rounding code which indicates how to round off the increase amount. |
| LeaseIncrementHeaderIncreaseCalcMethodCode | Defines whether to use index based, fixed rate based, or a greater or lower value of both when calculating the increase percent. |
| LeaseIncrementHeaderIncrementHeaderId | The unique payment increase agreement identifier. |
| LeaseIncrementHeaderIncrementIndexHeaderId | The payment increase index identifier referenced from FLA_INCREMENT_INDEX_HDRS_ALL table. |
| LeaseIncrementHeaderIncrementTemplateId | This is referenced from FLA_INCREMENT_TEMPLATES_ALL. |
| LeaseIncrementHeaderIndexFinderMonths | Specifies the duration in months over which the index check can extend. |
| LeaseIncrementHeaderLastUpdateDate | Indicates the date and time of the last update of the row. |
| LeaseIncrementHeaderLastUpdateLogin | Indicates the session login associated to the user who last updated the row. |
| LeaseIncrementHeaderLastUpdatedBy | Indicates the user who last updated the row. |
| LeaseIncrementHeaderLeaseDetailId | The lease detail's unique identifier. It's referenced from the FLA_LEASE_DETAILS table. |
| LeaseIncrementHeaderLeaseId | This is the lease identifier. It references the primary key of the FLA_LEASES_ALL table. |
| LeaseIncrementHeaderMaximumIncreasePercent | The maximum increase percent as entered by the user. |
| LeaseIncrementHeaderMinimumIncreasePercent | The minimum increase percent as entered by the user. |
| LeaseIncrementHeaderObjectVersionNumber | 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. |
| LeaseIncrementHeaderParentRecordId | The parent record's unique identifier. This identifies the parent record for this record. |
| LeaseIncrementHeaderPaymentCurrencyCode | The payment currency code of the payments which can be added to this payment increase agreement. |
| LeaseIncrementHeaderPaymentPurposeCode | The payment purpose values which are populated from the ORA_FLA_PAYMENT_PURPOSE lookup. |
| LeaseIncrementHeaderResponsibleUserName | The name of the responsible user. |
| LeaseIncrementHeaderScheduleTypeCode | Indicates the type of payment increase agreement, valid values are PAYMENT and BILLING. |
| LeaseIncrementHeaderSchedulesImpactFlag | The flag which indicates schedules are impacted and need to be regenerated. |
| LeaseIncrementHeaderShipToSiteUseId | The ship-to customer site use identifier. |
| LeaseIncrementHeaderSystemOriginReference1 | This is the source system first reference number from which the lease is being imported. |
| LeaseIncrementHeaderSystemOriginReference2 | This is the source system second reference number from which the lease is being imported. |
| LeaseIncrementHeaderUnusedIncreaseTreatmentCode | Indicates the way the unused increase should be treated. |
| LeaseIncrementHeaderVendorId | The supplier identifier. It's used to send the information to Payables during the payment process. |
| LeaseIncrementHeaderVersionNum | The version number of the lease as captured in the FLA_LEASE_DETAILS table. |