FLA_PAYMENT_HEADERS_INT
FLA_PAYMENT_HEADERS_INT contains the payment headers information like payment type, payment purpose, frequency, vendor and asset etc.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
FLA_PAYMENT_HEADERS_INT_PK |
LOAD_REQUEST_ID, INTERFACE_PAYMENT_HEADER_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_PAYMENT_HEADER_ID | NUMBER | 18 | Yes | Interface Payment header identifier. This column consistutes primary key along with LOAD_REQUEST_ID column of the table. | |
LOAD_REQUEST_ID | NUMBER | 18 | Yes | Oracle Enterprise Scheduler: request identifier of the interface load job that created the row. | |
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. | |
INTERFACE_LEASE_ID | NUMBER | 18 | Yes | Interface Lease identifier from FLA_LEASES_INT table. | |
INTERFACE_ASSET_ID | NUMBER | 18 | Interface Lease asset identifier from the FLA_ASSETS_INT 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 | 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_FREQUENCY_CODE | VARCHAR2 | 30 | Payment frequency code. Possible values are DAILY, MONTHLY, QUARTERLY, or ANNUALLY. | ||
PAYMENT_STATUS_CODE | VARCHAR2 | 30 | 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_NUMBER | VARCHAR2 | 30 | Unique number to identify a supplier. | ||
VENDOR_NAME | VARCHAR2 | 240 | Supplier name. Name of the supplier. | ||
VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. It is used to send the information to Payables during the payment process. | ||
VENDOR_SITE_CODE | VARCHAR2 | 240 | Physical location of the supplier. | ||
DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier. It is passed into Payables. | ||
DISTRIBUTION_SET_NAME | VARCHAR2 | 50 | Distribution set name as defined in payables. | ||
PAYMENT_TEMPLATE_ID | NUMBER | 18 | Payment template identifier. References the template from which the payment term is copied. | ||
PAYMENT_TEMPLATE_NAME | VARCHAR2 | 300 | Payment template name. 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. | ||
PO_NUMBER | VARCHAR2 | 30 | Document number used to request a seller supply a product or service for payment. | ||
REF_PURCHASE_ORDER_NUMBER | VARCHAR2 | 30 | Purchase order number for reference purpose. | ||
INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany flag with possible values as Y or N. Mainly used for reporting purposes, for future use. | ||
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 payment starts. This will be validated against the first payment line start date. | |||
PAYMENT_END_DATE | DATE | Date on which the payment ends. This will be validated against the last payment line end date. | |||
PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier for calculation of due date. | ||
PAYMENT_TERM_NAME | VARCHAR2 | 50 | Name of payment term for an invoice. | ||
PARENT_INTERFACE_PAY_HDR_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. | ||
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. | ||
WITHHOLDING_TAX_GROUP_NAME | VARCHAR2 | 50 | Used to apply multiple withholding taxes to an invoice line. | ||
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. | ||
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_DISC_RATE_IDX_NAME | VARCHAR2 | 300 | Discount rate index name 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_DISC_RATE_IDX_NAME | VARCHAR2 | 300 | Discount rate index name that is used for the secondary regime. | ||
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 | ||
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. | |||
MIGRATION_CONVERSION_RATE | NUMBER | Migration Currency conversion rate used to derive the payment amount when the payment currency is different from functional currency. | |||
PO_LINE_ID | NUMBER | 18 | Purchase order line identifier referenced from PO_LINES_ALL. | ||
PO_LINE_NUM | NUMBER | Purchase order line number referenced from PO_LINES_ALL. | |||
INTERFACE_AGREEMENT_ID | NUMBER | 18 | Interface payment increase agreement identifier. | ||
ACTUAL_AMOUNT | NUMBER | Payment amount in the payment currency. | |||
NO_OF_PAYMENTS | NUMBER | 9 | Number of payments to happen based on the effective dates and frequency. | ||
AMEND_ACTION_TYPE_CODE | VARCHAR2 | 30 | Amend action type which identifies which action is being performed. Values could be INSERT and UPDATE. | ||
ASSET_NUMBER | VARCHAR2 | 30 | Asset number of asset to which the payment is associated. | ||
AGREEMENT_NUMBER | VARCHAR2 | 100 | Payment increase agreement number. | ||
PAYMENT_NUMBER | VARCHAR2 | 30 | Payment number of payment which is being updated. | ||
TRUNCATE_PAYMENT_LINES_FLAG | VARCHAR2 | 1 | Flag to indicate if the payment lines needs to be truncated or not. | ||
PAYMENT_PREVIOUS_END_DATE | DATE | Previous end date of the payment. Oracle internal use only. | |||
PAYMENT_SPLIT_START_DATE | DATE | Start date of the payment line split. Oracle internal use only. | |||
ADJUSTED_CONTRACTION_AMOUNT | NUMBER | Payment contraction line amount being sent by user through FBDI. | |||
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_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | Bill-to customer account number of the transaction. | ||
BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill to customer site use identifier. | ||
BILL_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Bill-to customer address site number. Site number represents a location in the system. | ||
SHIP_TO_SITE_USE_ID | NUMBER | 18 | Ship to customer site use identifier. | ||
SHIP_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Ship-to customer account address site number. Site number represents a location in the system. | ||
CUSTOMER_TRX_TYPE_ID | NUMBER | 18 | Transaction type identifier to be sent to Receivables. | ||
CUSTOMER_TRX_TYPE_NAME | VARCHAR2 | 20 | Transaction type name used to deriving the transaction type identified for Receivables. | ||
AR_PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier sent to Receivables for calculation of due date. | ||
AR_PAYMENT_TERM_NAME | VARCHAR2 | 15 | Payment term name used to derive the payment term identifier of Receivables. | ||
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 | ||
FIRST_PTY_REG_NUM | VARCHAR2 | 60 | First party tax registration number of the transaction. | ||
THIRD_PTY_REG_ID | NUMBER | 18 | Bill-to Customer Tax Registration Number | ||
THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Third party tax registration number of the transaction. | ||
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 | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created 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_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_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_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_PAYMENT_HEADERS_INT_N1 | Non Unique | FUSION_TS_INTERFACE | INTERFACE_LEASE_ID, LOAD_REQUEST_ID |
FLA_PAYMENT_HEADERS_INT_U1 | Unique | FUSION_TS_INTERFACE | LOAD_REQUEST_ID, INTERFACE_PAYMENT_HEADER_ID |