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 |