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 |