FLA_MISCELLANEOUS_PAYMENTS_INT
FLA_MISCELLANEOUS_PAYMENTS_INT contains the data of miscellaneous payments.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FLA_MISC_PAYMENTS_INT_PK |
LOAD_REQUEST_ID, INTERFACE_MISC_PAYMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_MISC_PAYMENT_ID | NUMBER | 18 | Yes | Interface miscellaneous payment identifier. This column constitutes 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. | |
| BU_NAME | VARCHAR2 | 240 | Yes | Business unit to which the miscellaneous payment refers. | |
| LEASE_NUMBER | VARCHAR2 | 30 | Yes | Lease number refers to the lease identifier for which the miscellaneous payment is created. | |
| ASSET_NUMBER | VARCHAR2 | 30 | Asset number refers to the asset identifier for which the miscellaneous payment is created. | ||
| PAYMENT_TEMPLATE_NAME | VARCHAR2 | 300 | Payment template name. References the template from which the payment term and other attributes are copied. | ||
| 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. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Payment currency code. This is entered by the user. | ||
| CONVERSION_RATE | NUMBER | Currency conversion rate used to derive the payment amount when the payment currency is different from functional currency. | |||
| PAYMENT_DUE_DATE | DATE | Due date of the miscellaneous payment. | |||
| PAYMENT_AMOUNT | NUMBER | Payment amount. This is entered by the user. | |||
| BILL_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | Bill-to customer account number of the payment. | ||
| BILL_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Bill-to customer address site number. Site number represents a location in the system. | ||
| SHIP_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Ship-to customer account address site number. Site number represents a location in the system. | ||
| VENDOR_NUMBER | VARCHAR2 | 30 | Unique number to identify a supplier. | ||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Physical location of the supplier. | ||
| ACCOUNT_CODE_COMBINATION_1 | VARCHAR2 | 800 | Account concatenated segments. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. This will capture the Non-compliance Expense Account in case of Expense lease payment and the Receivables Account in case of Revenue lease payment. | ||
| ACCOUNT_CODE_COMBINATION_2 | VARCHAR2 | 800 | Account concatenated segments. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. This will capture the Payables Liability Account in case of Expense lease payment and the Revenue Account in case of Revenue lease payment. | ||
| ACCOUNT_CODE_COMBINATION_3 | VARCHAR2 | 800 | Account concatenated segments. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. Reserved for future use. | ||
| ACCOUNT_CODE_COMBINATION_4 | VARCHAR2 | 800 | Account concatenated segments. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. Reserved for future use. | ||
| SYSTEM_ORIGIN_REFERENCE_1 | VARCHAR2 | 30 | System reference column to maintain the key of source system from which miscellaneous payment is being imported | ||
| SYSTEM_ORIGIN_REFERENCE_2 | VARCHAR2 | 30 | System reference column to maintain the key of source system from which miscellaneous payment is being imported | ||
| IMPORT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Import Job. Main Job Request ID. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status code for the lease if row is processed or rejected | ||
| SCHEDULE_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates the purpose of miscellaneous payment. Possible values are PAYMENT and BILLING. | |
| MISC_PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of miscellaneous payment. Possible values are MANUAL. | ||
| ACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates the action being taken on the miscellaneous payment. Possible values are NEW and UPDATE. | |
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEASE_ID | NUMBER | 18 | Lease identifier for which the payment is created. | ||
| 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. | ||
| 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. | ||
| PAYMENT_TEMPLATE_ID | NUMBER | 18 | Payment template identifier. References the template from which the payment term is copied. | ||
| ASSET_ID | NUMBER | 18 | Asset identifier for which the payment is created. | ||
| ACCOUNT_CCID_1 | NUMBER | 18 | Account code combination identifier. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. This will capture the Non-compliance Expense Account in case of Expense lease payment and the Receivables Account in case of Revenue lease payment. | ||
| ACCOUNT_CCID_2 | NUMBER | 18 | Account code combination identifier. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. This will capture the Payables Liability Account in case of Expense lease payment and the Revenue Account in case of Revenue lease payment. | ||
| ACCOUNT_CCID_3 | NUMBER | 18 | Account code combination identifier. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. Reserved for future use. | ||
| ACCOUNT_CCID_4 | NUMBER | 18 | Account code combination identifier. It identifies the row in the GL Code Combinations table associated with this miscellaneous payment. Reserved for future use. | ||
| VENDOR_NAME | VARCHAR2 | 240 | Unique number to identify a supplier. | ||
| 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. | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | 30 | Currency conversion type when the currency is different from the functional currency. | ||
| MISC_PAYMENT_NUMBER | VARCHAR2 | 30 | Miscellaneous payment identifier. | ||
| PAYMENT_TERM_NAME | VARCHAR2 | 15 | Payment term name used to derive the payment term identifier of Receivables or Payables. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier for calculation of due date. | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany flag with possible values as Y or N. Mainly used for reporting purposes | ||
| 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 Driver: Tax classification code for payment term. | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Tax Driver: Indicates whether tax is included or not. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Tax Driver: 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. | ||
| 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 | Tax Driver: Withholding tax group identifier. | ||
| WITHHOLDING_TAX_GROUP_NAME | VARCHAR2 | 50 | Tax Driver: Used to apply multiple withholding taxes to an invoice line. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Tax Driver: Classification used by a tax authority to categorize a document associated with a transaction for a tax. | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | Tax Driver: Deploying company's Tax Registration number | ||
| FIRST_PTY_REG_NUM | VARCHAR2 | 60 | Tax Driver: First party tax registration number of the transaction. | ||
| THIRD_PTY_REG_ID | NUMBER | 18 | Tax Driver: Bill-to Customer Tax Registration Number | ||
| THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Tax Driver: Third party tax registration number of the transaction. | ||
| 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_MISC_PAYMENTS_INT_U1 | Unique | FUSION_TS_INTERFACE | LOAD_REQUEST_ID, INTERFACE_MISC_PAYMENT_ID |