This table requires activation of Lease Accounting functional area. This fact table contains details of Lease Payment Item Details like assets , payment header and purchase Order details
Module:
PAYMENT_ITEM_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PAYMENT_ITEM_ID | NUMBER | 38 | 0 | True | PAYMENT_ITEM_ID. It is the primary key of the table. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| PAYMENT_NUMBER | VARCHAR2 | 32 | Payment number. Payment Item is part of this Payment Header. | ||||
| PAYMENT_LINE_NUM | NUMBER | Payment line number. Payment Item is part of this Payment Line. | |||||
| LEASE_ID | NUMBER | 38 | 0 | Lease identifier. | DW_LEASE_CONTRACT_D | LEASE_ID | |
| LEASE_DETAIL_ID | NUMBER | 38 | 0 | Lease detail identifier. | DW_LEASE_CONTRACT_D | LEASE_DETAIL_ID | |
| PAYMENT_HEADER_ID | NUMBER | 38 | 0 | Payment header identifier. | DW_LEASE_PAYMENT_HEADER_CF | PAYMENT_HEADER_ID | |
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEDGER_ID | NUMBER | 38 | 0 | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier for the lease contract. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| LEASE_ASSET_ID | NUMBER | 38 | 0 | Asset identifier to uniquely identify an asset in this table. | DW_LEASE_ASSET_D | LEASE_ASSET_ID | |
| ASSET_LOCATION_ID | NUMBER | 38 | 0 | Site information at which the asset is being installed | DW_WORKER_LOCATION_D | LOCATION_ID | |
| INVENTORY_ORG_ID | NUMBER | 38 | 0 | Inventory item operating unit identifier. | DW_INVENTORY_ITEM_D | ORGANIZATION_ID | |
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory item identifier. It is associated with the item being chosen as asset from the inventory system. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| EMPLOYEE_ID | NUMBER | 38 | 0 | Employee with whom the asset is tagged with. | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| PROPERTY_ID | NUMBER | 38 | 0 | Attribute indicating the property identifier of the property. | DW_LEASE_PROPERTIES_D | PROPERTY_ID | |
| SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier. It is used to send the information to Payables during the payment process. | DW_PARTY_D | SUPPLIER_ID | |
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site identifier. It is used to send the information to Payables during the payment process. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| PAYMENT_TERM_ID | NUMBER | 38 | 0 | Payment term identifier for calculation of due date. | DW_AP_TERMS_D_TL | PAYMENT_TERMS_ID | |
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| PERIOD_NAME | VARCHAR2 | 32 | Period in which payment item falls in. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| ESTIMATED_AMOUNT | NUMBER | Estimated payment item amount in the payment currency. | |||||
| ACTUAL_AMOUNT | NUMBER | Payment item amount in the payment currency. | |||||
| ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis. | |||||
| CURRENCY_CODE | VARCHAR2 | 32 | Payment item currency code. This is based on the Payment currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Currency code associated to the ledger | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| DUE_DATE | DATE | Due date of the payment item as per the schedule in Payment Lines. | |||||
| START_DATE | DATE | Beginning date of the payment item. | |||||
| END_DATE | DATE | Ending date of the payment item. This is based on the Payment Line. | |||||
| APPROVAL_DATE | DATE | Date on which the approval for the payment item was done. | |||||
| PAYMENT_START_DATE | DATE | Date from which the first payment starts. | |||||
| PAYMENT_END_DATE | DATE | Date on which the payment ends. | |||||
| TERMINATION_DATE | DATE | Date when the payment is terminated. | |||||
| VERSION_NUM | NUMBER | 38 | 0 | Version number of the lease. | |||
| ASSET_NUMBER | VARCHAR2 | 32 | Asset number which is associated to the payment. | ||||
| APPROVED_BY | VARCHAR2 | 128 | User ID who has done the approval of the payment item. | ||||
| PRIMARY_INTENDED_USE | VARCHAR2 | 32 | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. | ||||
| CHARGE_ACCOUNT_CCID | NUMBER | 38 | 0 | Account identifier. Code Combination of the primary ledger charge account stored on the payment. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| LIABILITY_ACCOUNT_CCID | NUMBER | 38 | 0 | Account identifier. Code Combination of the primary ledger liability account stored on the payment. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| APPROVAL_STATUS_CODE | VARCHAR2 | 32 | Indicates if the payment item is approved for Payables invoice creation. | DW_FLA_PAY_ITEM_APPR_STATUS_LKP_TL | PAY_ITEM_APPR_STATUS_CODE | ||
| PAYMENT_FREQUENCY_CODE | VARCHAR2 | 32 | Payment frequency code. | DW_FLA_PAYMENT_FREQUENCY_LKP_TL | PAYMENT_FREQUENCY_CODE | ||
| PAYMENT_STATUS_CODE | VARCHAR2 | 32 | Status of payment. | DW_FLA_PAYMENT_STATUS_LKP_TL | PAYMENT_STATUS_CODE | ||
| PAYMENT_PURPOSE_CODE | VARCHAR2 | 32 | Payment purpose. | DW_FLA_PAYMENT_PURPOSE_LKP_TL | PAYMENT_PURPOSE_CODE | ||
| OPTION_TYPE_CODE | VARCHAR2 | 32 | Option type code. | DW_FLA_LEASE_OPTION_TYPE_LKP_TL | LEASE_OPTION_TYPE_CODE | ||
| OPTION_STATUS_CODE | VARCHAR2 | 32 | Option status code. | DW_FLA_OPTION_STATUS_LKP_TL | LEASE_OPTION_STATUS_CODE | ||
| REVENUE_METHOD_CODE | VARCHAR2 | 32 | Indicates the method for spread of generated revenue. | DW_FLA_REVENUE_METHOD_CODE_LKP_TL | REVENUE_METHOD_CODE | ||
| PAYMENT_TYPE_CODE | VARCHAR2 | 32 | Payment type. | DW_FLA_PAYMENT_TYPE_LKP_TL | PAYMENT_TYPE_CODE | ||
| SCHEDULE_TYPE_CODE | VARCHAR2 | 32 | Indicates the type of schedule. | DW_FLA_SCHEDULE_METHOD_CODE_LKP_TL | SCHEDULE_METHOD_CODE | ||
| INVOICE_NUM | VARCHAR2 | 64 | Stores the invoice number generated and sent to Payables for the payment item. | ||||
| INVOICE_LINE_NUMBER | NUMBER | 38 | 0 | Stores the invoice line number generated and sent to Payables for the payment item. | |||
| REF_PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 | Purchase order number for reference purpose. | ||||
| PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 | Purchase order number | ||||
| PURCHASE_ORDER_LINE_NUMBER | NUMBER | Purchase Order Line number | |||||
| PAYMENT_TEMPLATE_NAME | VARCHAR2 | 512 | Payment term name. It describes the payment term name. | ||||
| ROU_ASSET_FLAG | VARCHAR2 | 16 | Indicates whether to generate right of use schedule for respective payment term or not. | DW_Y_N_D_TL | CODE | ||
| LIABILITY_FLAG | VARCHAR2 | 16 | Indicates if liability schedule for respective payment term should be generated or not. | DW_Y_N_D_TL | CODE | ||
| ARREARS_FLAG | VARCHAR2 | 16 | Indicates if the payment is in arrear or not. | DW_Y_N_D_TL | CODE | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 16 | Intercompany flag. | DW_Y_N_D_TL | CODE | ||
| ACCOUNTED_FLAG | VARCHAR2 | 16 | Indicates if the payment item is transferred for accounting. | DW_Y_N_D_TL | CODE | ||
| ADJUSTMENT_FLAG | VARCHAR2 | 16 | Indicates if the payment item is created because of an adjustment. | DW_Y_N_D_TL | CODE | ||
| REVERSAL_FLAG | VARCHAR2 | 16 | Indicates if the payment item is created because of a reversal of generated payment items. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_FOR_STUB_FLAG | VARCHAR2 | 16 | Indicates whether the payment item was generated for a stub payment line. | DW_Y_N_D_TL | CODE | ||
| OPTION_FLAG | VARCHAR2 | 16 | Option flag which indicates if the payment items are generated for an option or not. | DW_Y_N_D_TL | CODE | ||
| AMORTIZE_EXEMPT_PAYMENT_FLAG | VARCHAR2 | 16 | Flag to indicate if the exempt payment should be amortized over the term of the payment. | DW_Y_N_D_TL | CODE | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 32 | Tax classification code for payment term. | ||||
| TAX_INCLUDED_FLAG | VARCHAR2 | 16 | Indicates whether tax is included or not. | DW_Y_N_D_TL | CODE | ||
| PRODUCT_CATEGORY | VARCHAR2 | 256 | Identifies the taxable nature of a noninventory based item for tax determination or tax reporting. | ||||
| PRODUCT_FISCAL_CLASSIFICATION | VARCHAR2 | 256 | Tax Driver: Product fiscal classification | ||||
| PRODUCT_TYPE | VARCHAR2 | 256 | Tax Driver: Type of product. Possible values are Goods and Services. | ||||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 256 | Tax Driver: Transactions category assigned by user. | ||||
| USER_DEFINED_FISCAL_CLASS | VARCHAR2 | 256 | Tax Driver: Fiscal Classification. | ||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| PAYMENT_ITEM_INTERCOMPANY_FLAG | VARCHAR2 | 16 | Intercompany flag. | DW_Y_N_D_TL | CODE | ||
| PAYMENT_ITEM_PRIMARY_INTENDED_USE | VARCHAR2 | 32 | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. |
Copyright © 2019, 2026, Oracle and/or its affiliates.