FLA_LEASE_PAYMENT_HDRS_HIST
FLA_LEASE_PAYMENT_HDRS_HIST contains the history of FLA_LEASE_PAYMENT_HEADERS.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
FLA_LEASE_PAY_HDRS_HIST_PK |
PAYMENT_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PAYMENT_HEADER_ID | NUMBER | 18 | Yes | Payment header identifier. It is the primary key of the table. | |
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. | |
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. It is referenced from FLA_LEASE_DETAILS_HIST table. | |
LEASE_ID | NUMBER | 18 | Yes | Lease identifier from FLA_LEASES_ALL table. | |
ASSET_NUMBER | VARCHAR2 | 30 | Lease asset identifier from the FLA_LEASE_ASSETS_HIST 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. | ||
LIABILITY_FLAG | VARCHAR2 | 1 | Indicates if liability schedule for respective payment term should be generated or not. | ||
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. | |||
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. | ||
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. | ||
FINAL_PAYMENT_HEADER_ID | NUMBER | 18 | Final payment header record identifier. This identifies the final record from the main table 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. | ||
VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. It is used to send the information to Payables during the payment process. | ||
DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier. It is passed into Payables. | ||
PAYMENT_TEMPLATE_ID | NUMBER | 18 | Payment template identifier. References the template from which the payment term is copied. | ||
PO_HEADER_ID | NUMBER | 18 | Purchase order unique identifier. It references the PO_HEADER_ID column from the PO_HEADERS_ALL table. | ||
INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany flag with possible values as Y or N. Mainly used for reporting purposes | ||
PAYMENT_PURPOSE_CODE | VARCHAR2 | 30 | Payment purpose. Values are populated from lookup FLA_PAYMENT_PURPOSE. | ||
PAYMENT_START_DATE | DATE | Date from which the first payment starts. | |||
PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier for calculation of due date. | ||
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 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. | ||
TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Indicates whether tax is included or not. | ||
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. | ||
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 will be set to Y 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. | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FLA_LEASE_PAY_HDRS_HIST_U1 | Unique | FUSION_TS_TX_IDX | PAYMENT_HEADER_ID |
FLA_LEASE_PAY_HDRS_HIST_U2 | Unique | FUSION_TS_TX_IDX | LEASE_DETAIL_ID, PAYMENT_NUMBER |