[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_PAYMENT_TEMPLATES |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_PAYMENT_TEMPLATES
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_PAYMENT_TEMPLATES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TEMPLATE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PAYMENT_DOCUMENT_ID | NUMBER | (15) | Payment Document Identifier | |
| TEMPLATE_ID | NUMBER | (15) | Yes | System generated primary key |
| 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 | ||
| ADDL_PAY_THRU_DAYS | NUMBER | Additional Pay Through Days | ||
| 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 | (15) | Supplier Identifier | |
| PARTY_ID | NUMBER | (15) | Party Identifier | |
| PAYMENT_METHOD_CODE | VARCHAR2 | (30) | Payment method code | |
| INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Invoice Exchange Rate Type. Values, from the lookup INVOICE_EXCHANGE_RATE_TYPE | |
| 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 | ||
| BANK_ACCOUNT_ID | NUMBER | (15) | 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) | The priority with which the financial institution or payment system should settle payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY | |
| FIRST_VOUCHER_NUMBER | NUMBER | (15) | First available voucher number in document sequence for payment batch document category | |
| TRANSFER_PRIORITY | VARCHAR2 | (25) | Transfer priority | |
| PAYMENT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for a foreign currency payment | |
| PAYMENT_PROFILE_ID | NUMBER | (15) | 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) | Stop Process for Review After Creation of Proposed Payments.Defaulted from IBY Payer Setup. | |
| 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) | Specifies what is rejected if a document payable fails validation. Values, from the IBY_DOCUMENT_REJECTION_LEVELS lookup, include REQUEST, PAYEE, and DOCUMENT. | |
| PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | (30) | Specifies how much of a payment process request is rejected if a payment fails validation. Values, from the IBY_PAYMENT_REJECTION_LEVELS lookup, include REQUEST, PAYMENT, and NONE. | |
| RESUBMIT_FLAG | VARCHAR2 | (1) | No longer Used | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_DOCUMENT_ID
, TEMPLATE_ID
, TEMPLATE_NAME
, TEMPLATE_TYPE
, DESCRIPTION
, INACTIVE_DATE
, ADDL_PAY_FROM_DAYS
, ADDL_PAY_THRU_DAYS
, HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY
, PAY_ONLY_WHEN_DUE_FLAG
, ZERO_INV_ALLOWED_FLAG
, VENDOR_TYPE_LOOKUP_CODE
, VENDOR_ID
, PARTY_ID
, PAYMENT_METHOD_CODE
, INV_EXCHANGE_RATE_TYPE
, PAY_GROUP_OPTION
, CURRENCY_GROUP_OPTION
, LE_GROUP_OPTION
, OU_GROUP_OPTION
, PAYMENT_DATE_OPTION
, ADDL_PAYMENT_DAYS
, BANK_ACCOUNT_ID
, BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY
, FIRST_VOUCHER_NUMBER
, TRANSFER_PRIORITY
, PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_PROFILE_ID
, ZERO_AMOUNTS_ALLOWED
, PAYABLES_REVIEW_SETTINGS
, CALC_AWT_INT_FLAG
, PAYMENTS_REVIEW_SETTINGS
, CREATE_INSTRS_FLAG
, DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE
, RESUBMIT_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AP.AP_PAYMENT_TEMPLATES;
AP.AP_PAYMENT_TEMPLATES does not reference any database object
AP.AP_PAYMENT_TEMPLATES is referenced by following:
APPS
AP_PAYMENT_TEMPLATES
|
|
|
|