eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_PAYMENT_HIST_DISTS

Object Details

Object Name:	AP_PAYMENT_HIST_DISTS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_PAYMENT_HIST_DISTS
Subobject Name:
Status:	VALID

The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process.
Payment distributions are associated with payment accounting events referenced in each row in the APH table.
One payment accounting event referenced in APH can have multiple payment distributions associated with it. This new table is introduced as the child of the APH table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_PAYMENT_HIST_DISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_HIST_DIST_ID
AP_PAYMENT_HIST_DISTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_HISTORY_ID
AP_PAYMENT_HIST_DISTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
AP_PAYMENT_HIST_DISTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
AP_PAYMENT_HIST_DISTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_ADDITION_FLAG
AP_PAYMENT_HIST_DISTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_PAYMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_HIST_DIST_ID	NUMBER	(15)	Yes	Payment History Distribution Identifier
ACCOUNTING_EVENT_ID	NUMBER	(15)	Yes	Accounting Event Identifier
PAY_DIST_LOOKUP_CODE	VARCHAR2	(30)	Yes	Name of distribution type.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Related invoice distribution
AMOUNT	NUMBER		Yes	Amount of distribution in the payment currency
PAYMENT_HISTORY_ID	NUMBER	(15)	Yes	Payment history identifier
INVOICE_PAYMENT_ID	NUMBER	(15)	Yes	Invoice Payment identifier
BANK_CURR_AMOUNT	NUMBER			Amount of distribution in bank account currency
CLEARED_BASE_AMOUNT	NUMBER			Payment cleared amount in functional currency
HISTORICAL_FLAG	VARCHAR2	(1)		Flag to indicate whether the payment distribution is a result of upgraded data
INVOICE_DIST_AMOUNT	NUMBER			Amount paid of related invoice distribution in entered invoice currency
INVOICE_DIST_BASE_AMOUNT	NUMBER			Amount of related invoice distribution in the functional currency using the invoice exchange rate
INVOICE_ADJUSTMENT_EVENT_ID	NUMBER	(15)		Related adjusted invoice that resulted in a cascade event
MATURED_BASE_AMOUNT	NUMBER			Payment matured amount of future dated payment in functional currency
PAID_BASE_AMOUNT	NUMBER			Payment amount in functional currency using payment exchange rate
ROUNDING_AMT	NUMBER			Rounding amount resulting from proration using the payment exchange rate
REVERSAL_FLAG	VARCHAR2	(1)		Flag that indicates if distribution is reversing another distribution
REVERSED_PAY_HIST_DIST_ID	NUMBER	(15)		Accounting Event ID of payment distribution being reversed
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column - Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER	(15)		Standard Who Column - Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER	(15)		Standard Who Column - Identifies the Oracle Applications Concurrent Program Login ID
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column - Identifies the concurrent request instance that spawned the concurrent program
AWT_RELATED_ID	NUMBER	(15)		Distribution identifier of AWT related distribution
RELEASE_INV_DIST_DERIVED_FROM	NUMBER	(15)		Retainage release invoice distribution identifier used for subledger accounting business flows
PA_ADDITION_FLAG	VARCHAR2	(1)		Flag that indicates if project related invoice distributions have been transferred into Oracle Projects in cash basis accounting
AMOUNT_VARIANCE	NUMBER			Amount variance in entered currency for invoice distributions matched to service shipment or receipt
INVOICE_BASE_AMT_VARIANCE	NUMBER			distributions matched to service shipment or receipt invoice distributions matched to service shipment or receipt
QUANTITY_VARIANCE	NUMBER			Quantity variance amount for invoice distribution lines matched to purchase order or receipt
INVOICE_BASE_QTY_VARIANCE	NUMBER			Quantity variance amount in functional currency for invoice distribution lines matched to purchase order or receipt
GAIN_LOSS_INDICATOR	VARCHAR2	(1)		Indicates whether the payment related transaction resulted in gain or loss (G or L)

Query Text

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;

Dependencies

[top of page]

AP.AP_PAYMENT_HIST_DISTS does not reference any database object

AP.AP_PAYMENT_HIST_DISTS is referenced by following:

AP: AP_PAYMENT_HIST_DISTS#