FLA_PAYMENT_ITEMS
FLA_PAYMENT_ITEMS contains payment items data generated for the lease payments.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FLA_PAYMENT_ITEMS_PK |
PAYMENT_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_ITEM_ID | NUMBER | 18 | Yes | PAYMENT_ITEM_ID. 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. | |
| LEASE_ID | NUMBER | 18 | Yes | Lease identifier. It references the primary key of the FLA_LEASES_ALL table. | |
| LEASE_DETAIL_ID | NUMBER | 18 | Yes | Lease detail identifier. It is referenced from FLA_LEASE_DETAILS table. | |
| PAYMENT_NUMBER | VARCHAR2 | 30 | Yes | Payment number. Payment Item is part of this Payment Header. | |
| PAYMENT_LINE_NUM | NUMBER | 9 | Payment line number. Payment Item is part of this Payment Line. | ||
| VERSION_NUM | NUMBER | 9 | Yes | Version number of the lease as captured in FLA_LEASE_DETAILS. | |
| VENDOR_ID | NUMBER | 18 | Yes | Supplier identifier. It is used to send the information to Payables during the payment process. | |
| VENDOR_SITE_ID | NUMBER | 18 | Yes | Supplier site identifier. It is used to send the information to Payables during the payment process. | |
| CURRENCY_CODE | VARCHAR2 | 30 | Yes | Payment item currency code. This is based on the Payment currency code. | |
| ESTIMATED_AMOUNT | NUMBER | Estimated payment item amount in the payment currency. | |||
| ACTUAL_AMOUNT | NUMBER | Yes | Payment item amount in the payment currency. | ||
| ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis. | |||
| DUE_DATE | DATE | Yes | Due date of the payment item as per the schedule in Payment Lines. | ||
| START_DATE | DATE | Yes | Beginning date of the payment item. | ||
| END_DATE | DATE | Yes | Ending date of the payment item. This is based on the Payment Line. | ||
| PERIOD_NAME | VARCHAR2 | 30 | Period in which payment item falls in. | ||
| ACCOUNTED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the payment item is transferred for accounting. | |
| ADJUSTMENT_FLAG | VARCHAR2 | 1 | Yes | Indicates if the payment item is created because of an adjustment. | |
| ADJUSTMENT_DATE | DATE | Date when the payment item adjustment is made. | |||
| REVERSAL_FLAG | VARCHAR2 | 1 | Yes | Indicates if the payment item is created because of a reversal of generated payment items. | |
| READ_IN_DRAFT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the payment item was considered for generation in the draft lease. | |
| PAYMENT_ITEM_FOR_STUB_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the payment item was generated for a stub payment line. | |
| INVOICE_NUM | VARCHAR2 | 50 | Stores the invoice number generated and sent to Payables for the payment item. | ||
| INVOICE_LINE_NUMBER | NUMBER | 18 | Stores the invoice line number generated and sent to Payables for the payment item. | ||
| ESTIMATED_FUNC_CURR_AMOUNT | NUMBER | Estimated payment item amount in the functional currency. | |||
| ACTUAL_FUNC_CURR_AMOUNT | NUMBER | Actual payment item amount in the functional currency | |||
| FUNC_CURR_CONV_RATE | NUMBER | Rate used to calculate the functional currency amount. | |||
| FUNC_CURR_CONV_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for foreign currency amounts. | ||
| FUNC_CURR_CONV_DATE | DATE | Date exchange rate is effective from. Usually the payment due date. | |||
| APPROVAL_STATUS_CODE | VARCHAR2 | 30 | Indicates if the payment item is approved for Payables invoice creation. | ||
| APPROVAL_DATE | DATE | Date on which the approval for the payment item was done. | |||
| APPROVED_BY | VARCHAR2 | 64 | User ID who has done the approval of the payment item. | ||
| COMMENTS | VARCHAR2 | 2000 | Comments or details provided by the user who has approved or exported the payment item | ||
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Indicates the payment item export status to Oracle Payables. Various statuses can be PENDING, INPROGRESS, HOLD, INTERFACED, ABANDONED. | ||
| INTERFACE_DATE | DATE | Date on which the payment item status was updated | |||
| INVOICE_CREATION_STATUS_CODE | VARCHAR2 | 30 | Status of Payables Invoice, whether the Invoice was generated successfully. For future use. | ||
| PARENT_PAYMENT_ITEM_ID | NUMBER | 18 | This identifies the parent payment item for this payment item. | ||
| EXPORT_GROUP_CODE | VARCHAR2 | 30 | Payables Invoice grouping purpose. For future use. | ||
| OPTION_FLAG | VARCHAR2 | 1 | Option flag which indicates if the payment items are generated for an option or not. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier. It is passed into Payables. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier for calculation of due date. | ||
| 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 streams is 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. | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany flag with possible values as Y or N. Mainly used for reporting purposes | ||
| APPROVAL_BATCH_ID | NUMBER | 18 | Batch identifier of the batch which was picked and processed for invoice & accounting approval. | ||
| INTERFACE_ELIGIBILITY_CODE | VARCHAR2 | 30 | Indicates the payment item export status to Oracle Payables. Various statuses can be YES, NO or HOLD. This would be a user entered option. | ||
| CHARGE_ACCOUNT_CCID | NUMBER | 18 | Account identifier. Code Combination of the primary ledger charge account stored on the payment. Charge account will be sent to Oracle Payables during invoice creation. | ||
| LIABILITY_ACCOUNT_CCID | NUMBER | 18 | Account identifier. Code Combination of the primary ledger liability account stored on the payment. Liability account will be sent to Oracle Payables during invoice creation. | ||
| SUPPLIER_INVOICE_REF_NUMBER | VARCHAR2 | 50 | Supplier number reference for the invoice. | ||
| CONTINGENT_AMOUNT | NUMBER | Contingent amount captured for the payment increase per payment period. | |||
| AGREEMENT_NUMBER | VARCHAR2 | 100 | Payment increase agreement number referenced from the FLA_INCREMENT_HEADERS table. | ||
| ASSESSMENT_DATE | DATE | Date when the payment increase assessment is performed. | |||
| PAYMENT_INCREASE_FLAG | VARCHAR2 | 1 | Indicates if the payment is generated for a payment increase line. | ||
| CUMULATIVE_INCREASE_FLAG | VARCHAR2 | 1 | Indicates if the payment is generated for cumulative increase amount of payment increase line. | ||
| MANUAL_ACTION_CODE | VARCHAR2 | 30 | Indicates the manual action that has happened on the payment item before its approval. Possible values can be Modified or Manually Created. | ||
| PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Payment type. Values are derived from ORA_FLA_PAYMENT_TYPE lookup. | ||
| PAYMENT_PURPOSE_CODE | VARCHAR2 | 30 | Payment purpose. Values are derived from ORA_FLA_PAYMENT_PURPOSE lookup. | ||
| ASSET_NUMBER | VARCHAR2 | 30 | Asset number which is associated to the payment. | ||
| PAYMENT_TEMPLATE_ID | NUMBER | 18 | Payment template identifier. References the payment template from which the payment is created. | ||
| RESPONSIBLE_USER_NAME | VARCHAR2 | 100 | Name of the user responsible for the update to the payment item amount. | ||
| 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_INVOICE_ID | NUMBER | 18 | Invoice identifier of the Receivables invoice. | ||
| AR_INVOICE_LINE_ID | NUMBER | 18 | Invoice line identifier of the Receivables invoice line. | ||
| 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 | ||
| REFERENCE_PAYMENT_ITEM_ID | NUMBER | 18 | Stores the reference payment item identifier for which the credit memo is being generated. | ||
| 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. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | 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 | Status |
|---|---|---|---|---|
| FLA_PAYMENT_ITEMS_N1 | Non Unique | Default | LEASE_DETAIL_ID, LEASE_ID, PAYMENT_NUMBER, DUE_DATE | |
| FLA_PAYMENT_ITEMS_U1 | Unique | FUSION_TS_TX_IDX | PAYMENT_ITEM_ID | |
| FLA_PAYMENT_ITEMS_U2 | Unique | FUSION_TS_TX_IDX | LEASE_ID, VERSION_NUM, PAYMENT_NUMBER, DUE_DATE, PARENT_PAYMENT_ITEM_ID | Obsolete |