[Home] [Help]
View: APBV_AP_PAYMENTS
View Text
SELECT CH.CHECK_ID
, CH.AMOUNT
, CH.CHECK_DATE
, CH.CHECK_NUMBER
, CH.PAYMENT_TYPE_FLAG
, CH.STATUS_LOOKUP_CODE
, CH.DOC_SEQUENCE_ID
, CH.CLEARED_AMOUNT
, CH.CLEARED_DATE
, CH.RELEASED_AT
, CH.RELEASED_BY
, CH.STOPPED_AT
, CH.STOPPED_BY
, CH.VOID_DATE
, CH.FUTURE_PAY_DUE_DATE
, CH.USSGL_TRANSACTION_CODE
, CH.CLEARED_BASE_AMOUNT
, CH.CLEARED_EXCHANGE_RATE
, CH.CLEARED_EXCHANGE_DATE
, CH.CLEARED_EXCHANGE_RATE_TYPE
, CH.EXCHANGE_RATE
, CH.EXCHANGE_DATE
, CH.EXCHANGE_RATE_TYPE
, CH.BASE_AMOUNT
, CH.CLEARED_ERROR_AMOUNT
, CH.CLEARED_CHARGES_AMOUNT
, CH.CLEARED_ERROR_BASE_AMOUNT
, CH.CLEARED_CHARGES_BASE_AMOUNT
, CH.TRANSFER_PRIORITY
, CH.STAMP_DUTY_AMT
, CH.STAMP_DUTY_BASE_AMT
, CH.CREATION_DATE
, CH.CREATED_BY
, CH.LAST_UPDATE_DATE
, CH.LAST_UPDATED_BY
FROM AP_CHECKS CH WITH READ ONLY
Columns
| Name |
| PAYMENT_DOCUMENT_ID |
| AMOUNT |
| PAYMENT_DOCUMENT_DATE |
| PAYMENT_DOCUMENT_NUMBER |
| PAYMENT_TYPE |
| PAYMENT_STATUS |
| PAYMENT_SEQUENCE_NUMBER |
| CLEARED_AMOUNT |
| CLEARED_DATE |
| STOP_PAYMENT_RELEASED_DATE |
| STOP_PAYMENT_RELEASED_USER_ID |
| STOP_PAYMENT_RECORDED_DATE |
| STOP_PAYMENT_RECORDED_USER_ID |
| VOID_DATE |
| FUTURE_PAY_DUE_DATE |
| USSGL_TRANSACTION_CODE |
| CLEARED_FUNCTIONAL_AMOUNT |
| CLEARED_CURRENCY_EXCH_RATE |
| CLEARED_CURRENCY_EXCH_DATE |
| CLEARED_CRNCY_EXCH_RATE_TYPE |
| CURRENCY_EXCHANGE_RATE |
| CURRENCY_EXCHANGE_DATE |
| CURRENCY_EXCHANGE_RATE_TYPE |
| FUNCTIONAL_AMOUNT |
| CLEARED_ERROR_AMOUNT |
| CLEARED_CHARGES_AMOUNT |
| CLEARED_ERROR_FUNCTIONAL_AMT |
| CLEARED_CHARGES_FUNCTIONAL_AMT |
| TRANSFER_PRIORITY |
| STAMP_DUTY_AMOUNT |
| STAMP_DUTY_FUNCTIONAL_AMOUNT |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
APPS.APBV_AP_PAYMENTS