CE_PGM_THIRD_PTY_CANDIDATES
This table 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_THIRD_PTY_CANDIDATES_PK |
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 | Yes | Identifier of the financing program. | |
| PARTY_ID | NUMBER | 18 | Yes | Party identifier of the financing program candidate. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates the record is active and in use. Possible values are Y or N. | |
| CANDIDATE_STATUS_CODE | VARCHAR2 | 30 | Yes | 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 | Yes | Financing option type of the program. Valid values are from the lookup ORA_CE_FINANCING_TYPES. | |
| SOURCE_CAMPAIGN_TYPE_CODE | VARCHAR2 | 30 | Yes | 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 | Yes | 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 | 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. | ||
| 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. | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CE_PGM_THIRD_PTY_CANDIDATES | ce_financing_programs_b | FINANCING_PROGRAM_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | hz_parties | PARTY_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | ce_fin_program_campaigns_b | FINANCING_PROGRAM_CAMPAIGN_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | hz_party_sites | PARTY_SITE_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | poz_site_assignments_all_m | ASSIGNMENT_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | ce_payment_instruments | PAYMENT_INSTRUMENT_ID |
| CE_PGM_THIRD_PTY_CANDIDATES | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| CE_PGM_THIRD_PTY_CANDIDATES | ap_terms_b | OVERRIDE_PAYMENT_TERM_ID |
| ce_fin_program_offers | ce_pgm_third_pty_candidates | PGM_THIRD_PTY_CANDIDATE_ID |
| ce_pgm_third_party_cand_hist | ce_pgm_third_pty_candidates | PGM_THIRD_PTY_CANDIDATE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_PGM_THIRD_PTY_CANDIDATES_N1 | Non Unique | Default | PARTY_ID, PARTY_SITE_ID, FINANCING_PROGRAM_ID |
| CE_PGM_THIRD_PTY_CANDIDATES_N2 | Non Unique | Default | FINANCING_PROGRAM_ID, PARTY_ID, FINANCING_PROGRAM_CAMPAIGN_ID |
| CE_PGM_THIRD_PTY_CANDIDATES_U1 | Unique | Default | PGM_THIRD_PTY_CANDIDATE_ID |