VIEW: AP.AP_RECURRING_PAYMENTS_ALL#

Source

View Text - Preformatted

select RECURRING_PAYMENT_ID RECURRING_PAYMENT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VENDOR_ID VENDOR_ID, RECURRING_PAY_NUM RECURRING_PAY_NUM, VENDOR_SITE_ID VENDOR_SITE_ID, REC_PAY_PERIOD_TYPE REC_PAY_PERIOD_TYPE, NUM_OF_PERIODS NUM_OF_PERIODS, FIRST_PERIOD FIRST_PERIOD, FIRST_PERIOD_NUM FIRST_PERIOD_NUM, AUTHORIZED_TOTAL AUTHORIZED_TOTAL, CONTROL_AMOUNT CONTROL_AMOUNT, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID, TERMS_ID TERMS_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE, REM_PERIODS REM_PERIODS, ACCOUNTING_DATE ACCOUNTING_DATE, RELEASED_AMOUNT RELEASED_AMOUNT, BATCH_ID BATCH_ID, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, INVOICE_BASE_RATE INVOICE_BASE_RATE, PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE, TAX_AMOUNT TAX_AMOUNT, PAYMENT_INVOICE_CROSS_RATE PAYMENT_INVOICE_CROSS_RATE, EXCHANGE_RATE EXCHANGE_RATE, NEXT_PERIOD NEXT_PERIOD, NEXT_PAYMENT NEXT_PAYMENT, INCREMENT_PERCENT INCREMENT_PERCENT, NUM_OF_PERIODS_REM NUM_OF_PERIODS_REM, SPECIAL_PAYMENT_AMOUNT1 SPECIAL_PAYMENT_AMOUNT1, SPECIAL_PERIOD_NAME1 SPECIAL_PERIOD_NAME1, SPECIAL_PAYMENT_AMOUNT2 SPECIAL_PAYMENT_AMOUNT2, SPECIAL_PERIOD_NAME2 SPECIAL_PERIOD_NAME2, DESCRIPTION DESCRIPTION, PAID_FLAG1 PAID_FLAG1, PAID_FLAG2 PAID_FLAG2, HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE, HOLD_REASON HOLD_REASON, APPROVED_BY APPROVED_BY, EXPIRY_DATE EXPIRY_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE, EXCHANGE_DATE EXCHANGE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TAX_NAME TAX_NAME, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, AWT_GROUP_ID AWT_GROUP_ID, ORG_ID ORG_ID, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, FIRST_AMOUNT FIRST_AMOUNT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, TAXATION_COUNTRY TAXATION_COUNTRY, TAX_CONTROL_AMOUNT TAX_CONTROL_AMOUNT, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, REQUESTER_ID REQUESTER_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, MANUFACTURER MANUFACTURER, MODEL_NUMBER MODEL_NUMBER, PO_RELEASE_ID PO_RELEASE_ID, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID, RELATIONSHIP_ID RELATIONSHIP_ID, PRODUCT_TYPE PRODUCT_TYPE, PRODUCT_CATEGORY PRODUCT_CATEGORY from "AP"."AP_RECURRING_PAYMENTS_ALL"

View Text - HTML Formatted

SELECT RECURRING_PAYMENT_ID RECURRING_PAYMENT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VENDOR_ID VENDOR_ID
, RECURRING_PAY_NUM RECURRING_PAY_NUM
, VENDOR_SITE_ID VENDOR_SITE_ID
, REC_PAY_PERIOD_TYPE REC_PAY_PERIOD_TYPE
, NUM_OF_PERIODS NUM_OF_PERIODS
, FIRST_PERIOD FIRST_PERIOD
, FIRST_PERIOD_NUM FIRST_PERIOD_NUM
, AUTHORIZED_TOTAL AUTHORIZED_TOTAL
, CONTROL_AMOUNT CONTROL_AMOUNT
, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, TERMS_ID TERMS_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT
, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, REM_PERIODS REM_PERIODS
, ACCOUNTING_DATE ACCOUNTING_DATE
, RELEASED_AMOUNT RELEASED_AMOUNT
, BATCH_ID BATCH_ID
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, INVOICE_BASE_RATE INVOICE_BASE_RATE
, PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, TAX_AMOUNT TAX_AMOUNT
, PAYMENT_INVOICE_CROSS_RATE PAYMENT_INVOICE_CROSS_RATE
, EXCHANGE_RATE EXCHANGE_RATE
, NEXT_PERIOD NEXT_PERIOD
, NEXT_PAYMENT NEXT_PAYMENT
, INCREMENT_PERCENT INCREMENT_PERCENT
, NUM_OF_PERIODS_REM NUM_OF_PERIODS_REM
, SPECIAL_PAYMENT_AMOUNT1 SPECIAL_PAYMENT_AMOUNT1
, SPECIAL_PERIOD_NAME1 SPECIAL_PERIOD_NAME1
, SPECIAL_PAYMENT_AMOUNT2 SPECIAL_PAYMENT_AMOUNT2
, SPECIAL_PERIOD_NAME2 SPECIAL_PERIOD_NAME2
, DESCRIPTION DESCRIPTION
, PAID_FLAG1 PAID_FLAG1
, PAID_FLAG2 PAID_FLAG2
, HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, HOLD_REASON HOLD_REASON
, APPROVED_BY APPROVED_BY
, EXPIRY_DATE EXPIRY_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE
, EXCHANGE_DATE EXCHANGE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAX_NAME TAX_NAME
, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, AWT_GROUP_ID AWT_GROUP_ID
, ORG_ID ORG_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, FIRST_AMOUNT FIRST_AMOUNT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, TAXATION_COUNTRY TAXATION_COUNTRY
, TAX_CONTROL_AMOUNT TAX_CONTROL_AMOUNT
, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, REQUESTER_ID REQUESTER_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, MANUFACTURER MANUFACTURER
, MODEL_NUMBER MODEL_NUMBER
, PO_RELEASE_ID PO_RELEASE_ID
, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
, PRODUCT_TYPE PRODUCT_TYPE
, PRODUCT_CATEGORY PRODUCT_CATEGORY
FROM "AP"."AP_RECURRING_PAYMENTS_ALL"