1. Tables and Views for Financials
  2. FLA_LEASE_PAYMENT_HEADERS

FLA_LEASE_PAYMENT_HEADERS

FLA_LEASE_PAYMENT_HEADERS contains the payment details such as payment frequency, supplier information, tax inclusion, and enabling of ROU, and so on.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FLA_LEASE_PAYMENT_HEADERS_PK

PAYMENT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PAYMENT_HEADER_ID NUMBER 18 Yes Payment header identifier. It is the primary key of the table. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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. Active
PAYMENT_NUMBER VARCHAR2 30 Yes Payment number which is either automatically generated or entered by the user.
LEASE_DETAIL_ID NUMBER 18 Yes Lease details identifier which is referenced. Active
LEASE_ID NUMBER 18 Yes Lease identifier from FLA_LEASES_ALL table. Active
ASSET_NUMBER VARCHAR2 30 Lease asset identifier from the FLA_LEASE_ASSETS table. It is valid only if asset is associated to the payment term.
ROU_ASSET_FLAG VARCHAR2 1 Indicates whether to generate right of use schedule for respective payment term or not. Active
LIABILITY_FLAG VARCHAR2 1 Indicates if liability schedule for respective payment term should be generated or not. Active
ARREARS_FLAG VARCHAR2 1 Yes Indicates if the payment is in arrear or not.
CONVERSION_RATE NUMBER Currency conversion rate used to derive the payment amount when the payment currency is different from functional currency. Active
CONVERSION_TYPE_CODE VARCHAR2 30 Currency conversion type when the currency is different from the functional currency.
CURRENCY_CODE VARCHAR2 15 Payment currency code. This is entered by the user. Active
PAYMENT_ITEMS_IMPACT_FLAG VARCHAR2 1 Payment items impact flag specifies if there is any payment items impacted because of changes to payment.
REF_PURCHASE_ORDER_NUMBER VARCHAR2 30 Purchase order number for reference purpose.
PARENT_RECORD_ID NUMBER 18 Parent record identifier. This identifies the parent record for this record.
CHANGE_TYPE_CODE VARCHAR2 30 Yes Indicates the type of change to the record, whether INSERT or UPDATE or DELETE.
CHANGED_IN_VERSION_NUM NUMBER 9 Yes Version number in which there was a change, either an Addition or Update or Delete.
PAYMENT_FREQUENCY_CODE VARCHAR2 30 Yes Payment frequency code. Possible values are DAILY, MONTHLY, QUARTERLY, or ANNUALLY.
PAYMENT_STATUS_CODE VARCHAR2 30 Yes Status of payment. Possible values are Cancelled and Active.
OPTION_FLAG VARCHAR2 1 Yes Indicates if this is a payment or an option.
VENDOR_ID NUMBER 18 Supplier identifier. It is referenced from POZ_VENDORS table. Active
VENDOR_SITE_ID NUMBER 18 Supplier site identifier. It is used to send the information to Payables during the payment process. Active
DISTRIBUTION_SET_ID NUMBER 18 Distribution set identifier. It is passed into Payables. Active
PAYMENT_TEMPLATE_ID NUMBER 18 Payment template identifier. References the template from which the payment term is copied. Active
PO_HEADER_ID NUMBER 18 Purchase order unique identifier. It references the PO_HEADER_ID column from the PO_HEADERS_ALL table. Active
INTERCOMPANY_FLAG VARCHAR2 1 Intercompany flag with possible values as Y or N. Mainly used for reporting purposes Active
PAYMENT_PURPOSE_CODE VARCHAR2 30 Payment purpose. Values are populated from lookup FND_LOOKUPS where lookup_type = FLA_PAYMENT_PURPOSE.
PAYMENT_START_DATE DATE Date from which the first payment starts. Active
PAYMENT_TERM_ID NUMBER 18 Payment term identifier for calculation of due date. Active
PARENT_PAYMENT_ID NUMBER 18 Payment header identifier for the parent Payment or option
PAYMENT_TYPE_CODE VARCHAR2 30 Payment type. Values are populated from lookup FND_LOOKUPS where lookup_type = FLA_PAYMENT_TYPE.
PRIMARY_INTENDED_USE VARCHAR2 30 Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level.
TAX_CLASSIFICATION_CODE VARCHAR2 30 Tax classification code for payment term. Active
TAX_INCLUDED_FLAG VARCHAR2 1 Indicates whether tax is included or not. Active
PRODUCT_CATEGORY VARCHAR2 240 Identifies the taxable nature of a noninventory based item for tax determination or tax reporting.
PRODUCT_FISCAL_CLASSIFICATION VARCHAR2 240 Tax Driver: Product fiscal classification
PRODUCT_TYPE VARCHAR2 240 Tax Driver: Type of product. Possible values are Goods and Services. This value defaults from Inventory Item attributes or is entered by the user.
REPORT_FROM_INCEPTION_FLAG VARCHAR2 1 Indicates whether the schedules are generated from the inception of the lease or not. Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Tax Driver: Transactions category assigned by user.
USER_DEFINED_FISCAL_CLASS VARCHAR2 240 Tax Driver: Fiscal Classification.
WITHHOLDING_TAX_GROUP_ID NUMBER 18 Withholding tax group identifier.
OPTION_TYPE_CODE VARCHAR2 30 Option type code. Possible values are Renewal, Residual, and Purchase.
OPTION_STATUS_CODE VARCHAR2 30 Option status code. Possible values are Exercised, Closed, Expired, and Terminated.
DATA_SOURCE_CODE VARCHAR2 30 Feeder system from which lease data was created.
SYSTEM_ORIGIN_REFERENCE_1 VARCHAR2 30 System reference column to maintain the key of source system from which lease is being imported
SYSTEM_ORIGIN_REFERENCE_2 VARCHAR2 30 System reference column to maintain the key of source system from which lease is being imported
SCHEDULES_IMPACT_FLAG VARCHAR2 1 Flag which indicates if the schedules are impacted and need to be regenerated.
PRIM_REGIME_ADDER_RATE NUMBER Adder rate which is used for the primary regime.
PRIM_REGIME_DISC_RATE_INDEX_ID NUMBER 18 Discount rate index that is used for the primary regime.
PRIM_REGIME_INTEREST_RATE NUMBER Discount rate index value that is used for the primary regime.
SECD_REGIME_ADDER_RATE NUMBER Adder rate which is used for the secondary regime.
SECD_REGIME_DISC_RATE_INDEX_ID NUMBER 18 Discount rate index that is used for the secondary regime.
SECD_REGIME_INTEREST_RATE NUMBER Discount rate index value that is used for the Secondary regime.
MIGRATED_FLAG VARCHAR2 1 Indicates if the payment is migrated or imported from an external system.
MIGRATION_CONVERSION_RATE NUMBER Migration Currency conversion rate used to derive the payment amount when the payment currency is different from functional currency.
MIGRATION_DATE DATE Indicates the date when the payment was migrated in.
FINANCE_ROU_BALANCE_AMOUNT NUMBER Contains finance ROU balance for migrated leases.
OPERATING_ROU_BALANCE_AMOUNT NUMBER Contains operating ROU balance for migrated leases.
FUNC_FIN_ROU_BALANCE_AMOUNT NUMBER Contains finance ROU balance for migrated leases in functional currency.
FUNC_OPER_ROU_BALANCE_AMOUNT NUMBER Contains operating ROU balance for migrated leases in functional currency.
PO_LINE_ID NUMBER 18 Purchase order line identifier referenced from PO_LINES_ALL.
TERMINATION_DATE DATE Date when the payment is terminated.
TERMINATION_ADJUSTMENT_AMOUNT NUMBER Estimated termination adjustment amount as calculated by system.
CLOSED_FLAG VARCHAR2 1 Closed flag indicates if the payment or option is closed.
OPTION_EXECUTION_DATE DATE Date when the option was exercised or cancelled.
PERCENTAGE_OF_REDUCTION NUMBER Reduction in ROU or Liability at the payment or option level.
INCREASE_IMPACT_FLAG VARCHAR2 1 Indicates if the payment is impacted by payment increase agreement.
CONTINGENT_ONLY_IMPACT_FLAG VARCHAR2 1 Indicates contingent amount is impacted.
ADJUSTED_CONTRACTION_AMOUNT NUMBER Payment contraction line amount being sent by user through FBDI.
PAYMENT_END_DATE DATE Date on which the payment ends.
IMPAIRMENT_IMPACT_FLAG VARCHAR2 1 Indicates if the payment is impacted because of impairment.
REVENUE_METHOD_CODE VARCHAR2 30 Indicates the method for spread of generated revenue, valid values are lease revenue and non lease revenue.
SCHEDULE_TYPE_CODE VARCHAR2 30 Yes Indicates the type of schedule, valid values are PAYMENT and BILLING.
BILL_TO_CUSTOMER_ID NUMBER 18 Bill to customer identifier for the billing.
BILL_TO_SITE_USE_ID NUMBER 18 Bill to customer site use identifier.
SHIP_TO_SITE_USE_ID NUMBER 18 Ship to customer site use identifier.
CUSTOMER_TRX_TYPE_ID NUMBER 18 Transaction type identifier to be sent to Receivables.
AR_PAYMENT_TERM_ID NUMBER 18 Payment term identifier sent to Receivables for calculation of due date.
DOCUMENT_SUB_TYPE VARCHAR2 240 Classification used by a tax authority to categorize a document associated with a transaction for a tax.
FIRST_PTY_REG_ID NUMBER 18 Deploying company's Tax Registration number
THIRD_PTY_REG_ID NUMBER 18 Bill-to Customer Tax Registration Number
AMORTIZE_EXEMPT_PAYMENT_FLAG VARCHAR2 1 Yes Flag to indicate if the exempt payment should be amortized over the term of the payment.
GENERATE_INVOICE_FLAG VARCHAR2 1 Yes Flag to indicate if the payment should be interfaced with Payables or Receivables during invoice creation.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
FLA_LEASE_PAYMENT_HEADERS fla_lease_details LEASE_DETAIL_ID

Indexes

Index Uniqueness Tablespace Columns Status
FLA_LEASE_PAYMENT_HEADERS_U1 Unique FUSION_TS_TX_IDX PAYMENT_HEADER_ID Active
FLA_LEASE_PAYMENT_HEADERS_U2 Unique FUSION_TS_TX_IDX LEASE_DETAIL_ID, PAYMENT_NUMBER Active