FLA_PAYMENT_TEMPLATES_ALL
FLA_PAYMENT_TEMPLATES_ALL contains payment term template information such as supplier information, payment purpose, and payment type, and so on. This defaults the data when this template is used on the lease payments.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FLA_PAYMENT_TEMPLATES_PK |
PAYMENT_TEMPLATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_TEMPLATE_ID | NUMBER | 18 | Yes | Payment template identifier. This is primary key for 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. | |
| NAME | VARCHAR2 | 300 | Yes | Payment term name. It describes the payment term name. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Payment type. Values are populated from lookup FND_LOOKUPS where lookup_type is FLA_PAYMENT_TYPE. | ||
| PAYMENT_PURPOSE_CODE | VARCHAR2 | 30 | Payment purpose. Values are populated from lookup FND_LOOKUPS where lookup_type=FLA_PAYMENT_PURPOSE. | ||
| ROU_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether if we generate right of use stream for respective payment term or not. | ||
| LIABILITY_FLAG | VARCHAR2 | 1 | Indicates whether if we generate liability stream for respective payment term or not. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether the template is in use or not. | ||
| PAYMENT_FREQUENCY_CODE | VARCHAR2 | 30 | Yes | Payment frequency. Possible values are DAILY, MONTHLY, QUARTERLY, or ANNUALLY. | |
| DESCRIPTION | VARCHAR2 | 1000 | Payment term template description. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier. It is used to calculate due date for the payment term. | ||
| VENDOR_ID | NUMBER | 18 | Supplier identifier. It is referenced from POZ_SUPPLIERS table. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. It is used to send the information to Payables during the payment process. | ||
| DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier. It is passed into Payables. | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Indicates whether the tax is included or not. | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Tax classification code for payment term. | ||
| REPORT_FROM_INCEPTION_FLAG | VARCHAR2 | 1 | Indicates whether the streams generation is from the inception of the lease or not. | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 1 | Indicates whether the payment term belongs to cross functional organization or not. | ||
| PRIMARY_INTENDED_USE_CODE | VARCHAR2 | 30 | Tax Driver: The purpose for which a product may be used. The actual use will be stored at the distribution level. | ||
| 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, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by 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 | Withholding tax group identifier | ||
| OPTION_FLAG | VARCHAR2 | 1 | Yes | Indicates if this is a payment or an option. | |
| OPTION_TYPE_CODE | VARCHAR2 | 30 | Option type code will have values like Renewal, Residual, Purchase etc. | ||
| 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_PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier sent to Receivables for calculation of due date. | ||
| 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 | ||
| 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 | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | 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_TEMPLATES_U1 | Unique | FUSION_TS_TX_IDX | PAYMENT_TEMPLATE_ID |
| FLA_PAYMENT_TEMPLATES_U2 | Unique | FUSION_TS_TX_IDX | NAME, ORG_ID |