AP_PAYMENT_HIST_DISTS
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.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_PAYMENT_HIST_DISTS_PK |
PAYMENT_HIST_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_HIST_DIST_ID | NUMBER | 18 | Yes | Payment History Distribution Identifier | |
| GAIN_LOSS_INDICATOR | VARCHAR2 | 1 | Indicator of exchange gain or loss incurred due to exchange rate difference. | ||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Yes | Identifier of the accounting event. | |
| PAY_DIST_LOOKUP_CODE | VARCHAR2 | 30 | Yes | Name of distribution type used for the payment distribution. | |
| INVOICE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifier of the related invoice distribution. | |
| AMOUNT | NUMBER | Yes | Amount of distribution in the payment currency | ||
| PAYMENT_HISTORY_ID | NUMBER | 18 | Yes | Identifier of the history of payment event. | |
| INVOICE_PAYMENT_ID | NUMBER | 18 | Yes | Identifier of payment of the invoice. | |
| 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 | 18 | 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 | 18 | Accounting Event ID of payment distribution being reversed | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Standard Who Column - Identifies the Oracle Application that spawned the concurrent program | ||
| PROGRAM_ID | NUMBER | 18 | Standard Who Column - Identifies the concurrent program | ||
| PROGRAM_LOGIN_ID | NUMBER | 18 | Standard Who Column - Identifies the Oracle Applications Concurrent Program Login ID | ||
| PROGRAM_UPDATE_DATE | DATE | Who column: indicates the date and time of the creation of the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| AWT_RELATED_ID | NUMBER | 18 | Distribution identifier of AWT related distribution | ||
| RELEASE_INV_DIST_DERIVED_FROM | NUMBER | 18 | 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 | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| BANK_BASE_AMOUNT | NUMBER | Cleared payment amount in ledger currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_PAYMENT_HIST_DISTS | ap_invoice_distributions_all | AWT_RELATED_ID |
| AP_PAYMENT_HIST_DISTS | ap_invoice_payments_all | INVOICE_PAYMENT_ID |
| AP_PAYMENT_HIST_DISTS | ap_invoice_distributions_all | INVOICE_DISTRIBUTION_ID |
| AP_PAYMENT_HIST_DISTS | ap_payment_history_all | PAYMENT_HISTORY_ID |
| AP_PAYMENT_HIST_DISTS | ap_payment_hist_dists | REVERSED_PAY_HIST_DIST_ID |
| ap_payment_hist_dists | ap_payment_hist_dists | REVERSED_PAY_HIST_DIST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_PAYMENT_HIST_DISTS_N1 | Non Unique | Default | PAYMENT_HISTORY_ID, INVOICE_PAYMENT_ID |
| AP_PAYMENT_HIST_DISTS_N2 | Non Unique | Default | INVOICE_DISTRIBUTION_ID |
| AP_PAYMENT_HIST_DISTS_N3 | Non Unique | Default | ACCOUNTING_EVENT_ID |
| AP_PAYMENT_HIST_DISTS_N4 | Non Unique | Default | PA_ADDITION_FLAG |
| AP_PAYMENT_HIST_DISTS_N5 | Non Unique | Default | INVOICE_PAYMENT_ID |
| AP_PAYMENT_HIST_DISTS_N6 | Non Unique | Default | REVERSED_PAY_HIST_DIST_ID |
| AP_PAYMENT_HIST_DISTS_U1 | Unique | Default | PAYMENT_HIST_DIST_ID |