[Home] [Help] [Dependency Information]
Object Name: | AP_PAYMENT_HIST_DISTS# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_HIST_DIST_ID | NUMBER | (15) | Yes | |
ACCOUNTING_EVENT_ID | NUMBER | (15) | Yes | |
PAY_DIST_LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | |
AMOUNT | NUMBER | Yes | ||
PAYMENT_HISTORY_ID | NUMBER | (15) | Yes | |
INVOICE_PAYMENT_ID | NUMBER | (15) | Yes | |
BANK_CURR_AMOUNT | NUMBER | |||
CLEARED_BASE_AMOUNT | NUMBER | |||
HISTORICAL_FLAG | VARCHAR2 | (1) | ||
INVOICE_DIST_AMOUNT | NUMBER | |||
INVOICE_DIST_BASE_AMOUNT | NUMBER | |||
INVOICE_ADJUSTMENT_EVENT_ID | NUMBER | (15) | ||
MATURED_BASE_AMOUNT | NUMBER | |||
PAID_BASE_AMOUNT | NUMBER | |||
ROUNDING_AMT | NUMBER | |||
REVERSAL_FLAG | VARCHAR2 | (1) | ||
REVERSED_PAY_HIST_DIST_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_LOGIN_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
AWT_RELATED_ID | NUMBER | (15) | ||
RELEASE_INV_DIST_DERIVED_FROM | NUMBER | (15) | ||
PA_ADDITION_FLAG | VARCHAR2 | (1) | ||
AMOUNT_VARIANCE | NUMBER | |||
INVOICE_BASE_AMT_VARIANCE | NUMBER | |||
QUANTITY_VARIANCE | NUMBER | |||
INVOICE_BASE_QTY_VARIANCE | NUMBER | |||
GAIN_LOSS_INDICATOR | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_HIST_DIST_ID
, ACCOUNTING_EVENT_ID
, PAY_DIST_LOOKUP_CODE
, INVOICE_DISTRIBUTION_ID
, AMOUNT
, PAYMENT_HISTORY_ID
, INVOICE_PAYMENT_ID
, BANK_CURR_AMOUNT
, CLEARED_BASE_AMOUNT
, HISTORICAL_FLAG
, INVOICE_DIST_AMOUNT
, INVOICE_DIST_BASE_AMOUNT
, INVOICE_ADJUSTMENT_EVENT_ID
, MATURED_BASE_AMOUNT
, PAID_BASE_AMOUNT
, ROUNDING_AMT
, REVERSAL_FLAG
, REVERSED_PAY_HIST_DIST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, AWT_RELATED_ID
, RELEASE_INV_DIST_DERIVED_FROM
, PA_ADDITION_FLAG
, AMOUNT_VARIANCE
, INVOICE_BASE_AMT_VARIANCE
, QUANTITY_VARIANCE
, INVOICE_BASE_QTY_VARIANCE
, GAIN_LOSS_INDICATOR
FROM AP.AP_PAYMENT_HIST_DISTS#;
|
|
|