AP_PAYMENT_TEMPLATES
The AP_PAYMENT_TEMPLATES table contains the user defined Payment Process Request Templates. The Templates can be used to default the Invoice Selection Critera in AP_INV_SELECTION_CRITERIA_ALL. This table corresponds to the Create Payment Request Template page.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_PAYMENT_TEMPLATES_PK |
TEMPLATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | 18 | Yes | System generated primary key for payment template. | |
| TEMPLATE_NAME | VARCHAR2 | 175 | Yes | Payment Process Request Template Name | |
| TEMPLATE_TYPE | VARCHAR2 | 30 | Payment Process Request Template Type. Values, from the lookup PAYMENT_TEMPLATE_TYPE | ||
| DESCRIPTION | VARCHAR2 | 240 | Payment Process Request Template Description | ||
| INACTIVE_DATE | DATE | End Date for the Payment Process Request Template | |||
| ADDL_PAY_FROM_DAYS | NUMBER | Number of pay from days defined in the payment template. The value can be either zero or a positive number. | |||
| ADDL_PAY_THRU_DAYS | NUMBER | End date in a date range that indicates the date until when the invoices are selected. | |||
| HI_PAYMENT_PRIORITY | NUMBER | 2 | Highest payment priority of the documents to select | ||
| LOW_PAYMENT_PRIORITY | NUMBER | 2 | Lowest payment priority of the documents to select | ||
| PAY_ONLY_WHEN_DUE_FLAG | VARCHAR2 | 1 | Flag that indicates if documents will be selected by their due date only (Y or N) | ||
| ZERO_INV_ALLOWED_FLAG | VARCHAR2 | 1 | Flag indicating whether scheduled payments with zero amount remaining will be selected during a pay run | ||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | 30 | Supplier Type. Based on PO Lookup Type VENDOR TYPES | ||
| VENDOR_ID | NUMBER | 18 | Unique supplier identifier from the supplier tables. | ||
| PARTY_ID | NUMBER | 18 | Party identifier of the payment template. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates the payment methods, such as check, cash, or credit. | ||
| INV_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Type of conversion rate between the payment and your ledger currency. | ||
| PAY_GROUP_OPTION | VARCHAR2 | 10 | Pay Group Options, All and Specify | ||
| CURRENCY_GROUP_OPTION | VARCHAR2 | 10 | Currency Options, All and Specify | ||
| LE_GROUP_OPTION | VARCHAR2 | 10 | Legal Entity Options, All and Specify | ||
| OU_GROUP_OPTION | VARCHAR2 | 10 | Operating Unit Options, All and Specify | ||
| PAYMENT_DATE_OPTION | VARCHAR2 | 15 | Payment Date Options, Same as the Request Date, Extra Days | ||
| ADDL_PAYMENT_DAYS | NUMBER | Extra payment days in the payment template. | |||
| BANK_ACCOUNT_ID | NUMBER | 18 | The Internal bank account identifier | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER | ||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Overrides the invoice value for Oracle Payments' bank charges feature. | ||
| FIRST_VOUCHER_NUMBER | NUMBER | 18 | First available voucher number in document sequence for payment batch document category | ||
| TRANSFER_PRIORITY | VARCHAR2 | 25 | Transfer priority defined in payment template. This can be express, normal, and any. | ||
| PAYMENT_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for a foreign currency payment | ||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Payment process profile identifier | ||
| ZERO_AMOUNTS_ALLOWED | VARCHAR2 | 1 | Flag indicating whether zero payments allowed in run. Helps in Maximizing credits | ||
| PAYABLES_REVIEW_SETTINGS | VARCHAR2 | 1 | Stop Process for Review After Invoice Selection | ||
| CALC_AWT_INT_FLAG | VARCHAR2 | 1 | Flag to indicate Calculate Payment Withholding and Interest During Scheduled Payment Selection | ||
| PAYMENTS_REVIEW_SETTINGS | VARCHAR2 | 1 | If this check box is selected, the Build Payments program runs to group the invoices into payments and the pay run pauses after payments have been built to allow you to review the proposed payments. | ||
| CREATE_INSTRS_FLAG | VARCHAR2 | 1 | Payment Instruction Creation Program. This setting requires the user to select a payment process profile. This setting will also ensure that payments from this payment process request are not combined with payments from other payment process requests when the system creates payment instructions | ||
| DOCUMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Indicates the validation failure handling option for payable documents. Possible values are: Reject All Documents for Payee, Reject All Documents in Request, Stop Process for Review | ||
| PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Document used to pay an invoice. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PAYMENT_DOCUMENT_ID | NUMBER | 18 | A set of documents, such as check stock, on which checks and promissory notes can be printed or written. | ||
| 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. | |
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| X_CURR_RATE_TYPE | VARCHAR2 | 30 | The conversion rate type used to convert the invoice currency to payment currency. | ||
| FIRST_APPROVER_ID | NUMBER | 18 | First approver identifier for payment process requests that the payments approval workflow uses to generate the list of approvers. | ||
| SOURCE_GROUP_OPTION | VARCHAR2 | 10 | Options on how to select invoices for payment with either all or specific values. | ||
| ACCELERATED_INVOICES_CODE | VARCHAR2 | 30 | Dynamic discount invoice code. Values are from lookup ACCELERATED_INVOICES. Possible values are INCLUDE, EXCLUDE and EXCLUSIVE. | ||
| TRANSACTION_CALENDAR_ID | NUMBER | 18 | General Ledger transaction calendar identifier. | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. | ||
| PMT_TO_BANK_RATE_TYPE | VARCHAR2 | 30 | Type of exchange rate used to convert payment to disbursement bank account currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_PAYMENT_TEMPLATES | hz_parties | PARTY_ID |
| AP_PAYMENT_TEMPLATES | ce_payment_documents | PAYMENT_DOCUMENT_ID |
| AP_PAYMENT_TEMPLATES | poz_suppliers | VENDOR_ID |
| AP_PAYMENT_TEMPLATES | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| AP_PAYMENT_TEMPLATES | gl_daily_conversion_types | INV_EXCHANGE_RATE_TYPE |
| AP_PAYMENT_TEMPLATES | ce_bank_accounts | BANK_ACCOUNT_ID |
| ap_currency_group | ap_payment_templates | TEMPLATE_ID |
| ap_pay_group | ap_payment_templates | TEMPLATE_ID |
| ap_inv_selection_criteria_all | ap_payment_templates | TEMPLATE_ID |
| ap_ou_group | ap_payment_templates | TEMPLATE_ID |
| ap_le_group | ap_payment_templates | TEMPLATE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_PAYMENT_TEMPLATES_U1 | Unique | Default | TEMPLATE_ID |