AP_INVOICE_RELATIONSHIPS
AP_INVOICE_RELATIONSHIPS relates records in AP_INVOICES_ALL with one another to match Interest invoices with corresponding overdue invoices. If you use automatic interest calculation, Payables creates Interest invoices to pay interest on overdue invoices. This interest is calculated in accordance with the U.S. Prompt Payment Act.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_RELATIONSHIPS_PK |
RELATED_INVOICE_ID, ORIGINAL_INVOICE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RELATED_INVOICE_ID | NUMBER | 18 | Yes | Interest invoice identifier. | |
| ORIGINAL_INVOICE_ID | NUMBER | 18 | Yes | Unique identifier for the original invoice. | |
| ORIGINAL_PAYMENT_NUM | NUMBER | 18 | Yes | Payment number of original invoice | |
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CHECKRUN_NAME | VARCHAR2 | 255 | Name of the payment batch. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_INVOICE_RELATIONSHIPS | ap_invoices_all | RELATED_INVOICE_ID |
| AP_INVOICE_RELATIONSHIPS | ap_invoices_all | ORIGINAL_INVOICE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| AP_INVOICE_RELATIONSHIPS_N1 | Non Unique | Default | RELATED_INVOICE_ID | Obsolete |
| AP_INVOICE_RELATIONSHIPS_U1 | Unique | Default | ORIGINAL_INVOICE_ID, ORIGINAL_PAYMENT_NUM, RELATED_INVOICE_ID, CHECKRUN_NAME | |
| AP_INVOICE_RELATIONSHIPS_U2 | Unique | Default | RELATED_INVOICE_ID, ORIGINAL_INVOICE_ID |