CE_PGM_THIRD_PTY_CANDIDATES_
This table is the audit table for CE_PGM_THIRD_PTY_CANDIDATES. CE_PGM_THIRD_PTY_CANDIDATES contains information related to third parties that are candidates for financing programs.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CE_PGM_TP_CANDIDATES_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, PGM_THIRD_PTY_CANDIDATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PGM_THIRD_PTY_CANDIDATE_ID | NUMBER | 18 | Yes | Identifier for a financing program candidate. | |
| FINANCING_PROGRAM_ID | NUMBER | 18 | Identifier of the financing program. | ||
| PARTY_ID | NUMBER | 18 | Party identifier of the financing program candidate. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Indicates the record is active and in use. Possible values are Y or N. | ||
| CANDIDATE_STATUS_CODE | VARCHAR2 | 30 | Current candidate status of a third party being added in a financing program. Valid values are from the lookup ORA_CE_CANDIDATE_STATUS_CODE. | ||
| FINANCING_OPTION_TYPE_CODE | VARCHAR2 | 30 | Financing option type of the program. Valid values are from the lookup ORA_CE_FINANCING_TYPES. | ||
| SOURCE_CAMPAIGN_TYPE_CODE | VARCHAR2 | 30 | Type of campaign used as the source to identify a financing program candidate. Valid values are from the lookup ORA_CE_SOURCE_CAMPAIGN_TYPE. | ||
| EFFECTIVE_FROM_DATE | DATE | Indicates the date from which the financing program is effective for the financing program candidate. | |||
| EFFECTIVE_TO_DATE | DATE | Indicates the date till which the financing program is effective for the financing program candidate. | |||
| FINANCING_PROGRAM_CAMPAIGN_ID | NUMBER | 18 | Financing program campaign identifier. | ||
| INITIATOR_TYPE_CODE | VARCHAR2 | 30 | Initiator type for the financing program candidate. Valid values are from the lookup ORA_CE_INITIATOR_TYPE_CODE. | ||
| INCLUDE_OPEN_INVOICES_FLAG | VARCHAR2 | 1 | Indicates whether unpaid invoices created before the offer are included. Valid values are Y or N. | ||
| SOURCE_TYPE_CODE | VARCHAR2 | 30 | Code indicating the financing program candidate creation source. Valid values are from the lookup ORA_CE_SOURCE_TYPE_CODE. | ||
| PARTY_SITE_ID | NUMBER | 18 | Party site identifier of the financing program candidate. | ||
| THIRD_PARTY_ACCOUNT_OR_SITE_ID | NUMBER | 18 | Third-party account or site identifier of the financing program candidate. | ||
| ASSIGNMENT_ID | NUMBER | 18 | Unique supplier site assignment identifier. | ||
| BILL_TO_BU_ID | NUMBER | 18 | Bill-to business unit assigned to the supplier site. | ||
| COMMENTS | VARCHAR2 | 2000 | Manually-entered comments for an financing program candidate. | ||
| DISCOUNT_RATE_UNIT_CODE | VARCHAR2 | 30 | Discount rate unit code. Valid values are from the lookup ORA_AP_DISCOUNT_TYPE. | ||
| DISCOUNT_RATE | NUMBER | Active discount percent rate for the financing program candidate. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code used on the financing program candidate when financing program candidate record is introduced. | ||
| MIN_DAYS_BETWEEN_OFFERS | NUMBER | 4 | Minimum number of days required between successive discount offers made to the financing program candidates. | ||
| THIRD_PARTY_CONTACT_PARTY_ID | NUMBER | 18 | Party identifier of the third-party contact user. | ||
| EMAIL_ADDRESS | VARCHAR2 | 320 | Third-party contact email address. | ||
| PRIOR_OFFER_STATUS_CODE | VARCHAR2 | 30 | Previous offer status code. Valid values are from the lookup ORA_CE_OFFER_STATUS_CODE. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Identifier of the preferred payment instrument associated with the financing program candidate. This value is derived from the most recently sent offer and is used to determine the next recommended payment instrument for the candidate. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Preferred payment method associated with the financing program candidate. This value is derived from the payment method in the most recently sent offer and is used to determine the next recommended payment method for the candidate. | ||
| OVERRIDE_PAYMENT_TERM_ID | NUMBER | 18 | Identifier of the preferred payment terms associated with the financing program candidate. This value is derived from the payment terms in the most recently sent offer and is used to determine the next recommended payment terms for the candidate. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_PGM_TP_CANDIDATES_N1_ | Non Unique | Default | PGM_THIRD_PTY_CANDIDATE_ID |
| CE_PGM_TP_CANDIDATES_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PGM_THIRD_PTY_CANDIDATE_ID |