[Home] [Help] [Dependency Information]
Object Name: | AP_PAYMENT_HISTORY_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_HISTORY_ID | NUMBER | (15) | Yes | |
CHECK_ID | NUMBER | (15) | Yes | |
ACCOUNTING_DATE | DATE | Yes | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | |
POSTED_FLAG | VARCHAR2 | (1) | Yes | |
MATCHED_FLAG | VARCHAR2 | (1) | ||
ACCOUNTING_EVENT_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
REV_PMT_HIST_ID | NUMBER | (15) | ||
TRX_BANK_AMOUNT | NUMBER | |||
ERRORS_BANK_AMOUNT | NUMBER | |||
CHARGES_BANK_AMOUNT | NUMBER | |||
TRX_PMT_AMOUNT | NUMBER | Yes | ||
ERRORS_PMT_AMOUNT | NUMBER | |||
CHARGES_PMT_AMOUNT | NUMBER | |||
TRX_BASE_AMOUNT | NUMBER | |||
ERRORS_BASE_AMOUNT | NUMBER | |||
CHARGES_BASE_AMOUNT | NUMBER | |||
BANK_CURRENCY_CODE | VARCHAR2 | (15) | ||
BANK_TO_BASE_XRATE_TYPE | VARCHAR2 | (30) | ||
BANK_TO_BASE_XRATE_DATE | DATE | |||
BANK_TO_BASE_XRATE | NUMBER | |||
PMT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
PMT_TO_BASE_XRATE_TYPE | VARCHAR2 | (30) | ||
PMT_TO_BASE_XRATE_DATE | DATE | |||
PMT_TO_BASE_XRATE | NUMBER | |||
MRC_PMT_TO_BASE_XRATE_TYPE | VARCHAR2 | (2000) | ||
MRC_PMT_TO_BASE_XRATE_DATE | VARCHAR2 | (2000) | ||
MRC_PMT_TO_BASE_XRATE | VARCHAR2 | (2000) | ||
MRC_BANK_TO_BASE_XRATE_TYPE | VARCHAR2 | (2000) | ||
MRC_BANK_TO_BASE_XRATE_DATE | VARCHAR2 | (2000) | ||
MRC_BANK_TO_BASE_XRATE | VARCHAR2 | (2000) | ||
MRC_TRX_BASE_AMOUNT | VARCHAR2 | (2000) | ||
MRC_ERRORS_BASE_AMOUNT | VARCHAR2 | (2000) | ||
MRC_CHARGES_BASE_AMOUNT | VARCHAR2 | (2000) | ||
RELATED_EVENT_ID | NUMBER | (15) | ||
HISTORICAL_FLAG | VARCHAR2 | (1) | ||
INVOICE_ADJUSTMENT_EVENT_ID | NUMBER | (15) | ||
GAIN_LOSS_INDICATOR | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_HISTORY_ID
, CHECK_ID
, ACCOUNTING_DATE
, TRANSACTION_TYPE
, POSTED_FLAG
, MATCHED_FLAG
, ACCOUNTING_EVENT_ID
, ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, REV_PMT_HIST_ID
, TRX_BANK_AMOUNT
, ERRORS_BANK_AMOUNT
, CHARGES_BANK_AMOUNT
, TRX_PMT_AMOUNT
, ERRORS_PMT_AMOUNT
, CHARGES_PMT_AMOUNT
, TRX_BASE_AMOUNT
, ERRORS_BASE_AMOUNT
, CHARGES_BASE_AMOUNT
, BANK_CURRENCY_CODE
, BANK_TO_BASE_XRATE_TYPE
, BANK_TO_BASE_XRATE_DATE
, BANK_TO_BASE_XRATE
, PMT_CURRENCY_CODE
, PMT_TO_BASE_XRATE_TYPE
, PMT_TO_BASE_XRATE_DATE
, PMT_TO_BASE_XRATE
, MRC_PMT_TO_BASE_XRATE_TYPE
, MRC_PMT_TO_BASE_XRATE_DATE
, MRC_PMT_TO_BASE_XRATE
, MRC_BANK_TO_BASE_XRATE_TYPE
, MRC_BANK_TO_BASE_XRATE_DATE
, MRC_BANK_TO_BASE_XRATE
, MRC_TRX_BASE_AMOUNT
, MRC_ERRORS_BASE_AMOUNT
, MRC_CHARGES_BASE_AMOUNT
, RELATED_EVENT_ID
, HISTORICAL_FLAG
, INVOICE_ADJUSTMENT_EVENT_ID
, GAIN_LOSS_INDICATOR
FROM AP.AP_PAYMENT_HISTORY_ALL#;
|
|
|