Payment Templates
These are the payment template setups.
Data Store Key : FscmTopModelAM.FinExtractAM.FlaBiccExtractAM.PaymentTemplatesExtractPVO
Primary Keys : PaymentTemplatePaymentTemplateId
Initial Extract Date : PaymentTemplateCreationDate
Incremental Extract Date : PaymentTemplateLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| PaymentTemplateActiveFlag | Indicates whether the payment template is used or not. |
| PaymentTemplateAmortizeExemptPaymentFlag | Indicates whether the exempt payment should be amortized over the life of the payment. |
| PaymentTemplateApplyUpfrontTaxFlag | Indicates whether upfront tax is applicable or not. |
| PaymentTemplateArPaymentTermId | This is the payment template identifier sent to Oracle Receivables for the calculation of the due date. |
| PaymentTemplateAttributeCategory | The structure definition of the user descriptive flexfield. |
| PaymentTemplateAttributeChar1 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar10 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar11 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar12 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar13 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar14 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar15 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar2 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar3 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar4 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar5 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar6 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar7 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar8 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeChar9 | A segment of the user descriptive flexfield. |
| PaymentTemplateAttributeDate1 | A date segment of the user descriptive flexfield. |
| PaymentTemplateAttributeDate2 | A date segment of the user descriptive flexfield. |
| PaymentTemplateAttributeDate3 | A date segment of the user descriptive flexfield. |
| PaymentTemplateAttributeDate4 | A date segment of the user descriptive flexfield. |
| PaymentTemplateAttributeDate5 | A date segment of the user descriptive flexfield. |
| PaymentTemplateAttributeNumber1 | A number segment of the user descriptive flexfield. |
| PaymentTemplateAttributeNumber2 | A number segment of the user descriptive flexfield. |
| PaymentTemplateAttributeNumber3 | A number segment of the user descriptive flexfield. |
| PaymentTemplateAttributeNumber4 | A number segment of the user descriptive flexfield. |
| PaymentTemplateAttributeNumber5 | A number segment of the user descriptive flexfield. |
| PaymentTemplateBillToCustomerId | The bill-to customer in the payment template. |
| PaymentTemplateBillToSiteUseId | The bill-to site in the payment template. |
| PaymentTemplateCreatedBy | The user who created the row. |
| PaymentTemplateCreationDate | The row's creation date and time. |
| PaymentTemplateCustomerTrxTypeId | The transaction type identifier to be sent to Receivables. |
| PaymentTemplateDescription | The payment template description. |
| PaymentTemplateDistributionSetId | The accounting distribution set identifier that's passed to Payables. |
| PaymentTemplateDocumentSubType | The classification used by a tax authority to categorize a document associated with a transaction. |
| PaymentTemplateFirstPtyRegId | Displays the company's tax registration number. |
| PaymentTemplateGenerateInvoiceFlag | The flag indicating whether the payment should be interfaced with Payables or Receivables during invoice creation. |
| PaymentTemplateIntercompanyFlag | Indicates whether the payment is related to an intercompany transaction. |
| PaymentTemplateLastUpdateDate | The row's last update date and time. |
| PaymentTemplateLastUpdateLogin | The session's login associated to the user who last updated the row. |
| PaymentTemplateLastUpdatedBy | Indicates the user who last updated the row. |
| PaymentTemplateLiabilityFlag | Indicates whether liability balances and accruals should be generated for the payment. |
| PaymentTemplateName | This is the payment template name. |
| PaymentTemplateObjectVersionNumber | This is 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. |
| PaymentTemplateOptionFlag | Indicates whether the payment template is for a payment or an option. |
| PaymentTemplateOptionTypeCode | This is the option type. User choices include Renewal and Early Termination. |
| PaymentTemplateOrgId | The business unit associated to the row. |
| PaymentTemplatePaymentFrequencyCode | Indicates the payment frequency. User choices are daily, monthly, quarterly, and annually. |
| PaymentTemplatePaymentPurposeCode | This is the payment purpose. Values are populated from lookup FND_LOOKUPS where the lookup type is FLA_PAYMENT_PURPOSE. |
| PaymentTemplatePaymentTemplateId | The payment template identifier. This is the primary key of the table. |
| PaymentTemplatePaymentTermId | The payment identifier. It's used to calculate due date for the payment term. |
| PaymentTemplatePaymentTypeCode | This is the payment type assigned to the payment. |
| PaymentTemplatePrimaryIntendedUseCode | The purpose for which a product may be used. Used for tax calculations. |
| PaymentTemplateProductCategory | Identifies the taxable nature of a noninventory-based item for tax determination and tax reporting. |
| PaymentTemplateProductFiscalClassification | Indicates product fiscal classification for tax calculation and reporting purposes |
| PaymentTemplateProductType | Indicates the product type for tax calculation and reporting purposes. User choices are goods and services. |
| PaymentTemplateReportFromInceptionFlag | Indicates whether the generation of streams is from the inception of the lease. |
| PaymentTemplateRevenueMethodCode | Indicates the method for spreading revenue along the life of the underlying asset or the payment. |
| PaymentTemplateRouAssetFlag | Indicates whether right-of-use balances and expense amortization accruals should be generated for the payment. |
| PaymentTemplateScheduleTypeCode | Indicates whether the payment is an expense payment or a revenue payment. |
| PaymentTemplateShipToSiteUseId | The ship-to customer site identifier. |
| PaymentTemplateTaxClassificationCode | This is the tax classification code for the payment. |
| PaymentTemplateTaxDeterminantsSourceCode | Indicates the source of the tax determinants. User choices are setup and payment. |
| PaymentTemplateTaxIncludedFlag | Indicates whether tax is included on the payments created for leases in the business unit. |
| PaymentTemplateThirdPtyRegId | Indicates the bill-to customer tax registration number. |
| PaymentTemplateTrxBusinessCategory | Indicates the transactions category that may be used for tax calculation and reporting purposes. |
| PaymentTemplateUserDefinedFiscalClass | Indicates the fiscal classification for tax calculation and reporting purposes. |
| PaymentTemplateVendorId | This is the supplier identifier. |
| PaymentTemplateVendorSiteId | This is the supplier site identifier. |
| PaymentTemplateWithholdingTaxGroupId | This is the withholding tax group identifier. |