1. Tables and Views for Sales and Fusion Service
  2. CN_TP_TRANSACTIONS_STAGING_T

CN_TP_TRANSACTIONS_STAGING_T

Staging table for the Base Transactions

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_ID NUMBER 18 Transaction Identifier
STAG_TRANSACTION_ID NUMBER 18 Transaction Identifier in staging table.
TRANSACTION_FLAG VARCHAR2 1 Flag to indicate if the record is a transaction.
CREDIT_FLAG VARCHAR2 1 Flag to indicate if the record is a credit.
PARTICIPANT_ID NUMBER 18 Unique identifier for salesrep of the transaction Active
PARTICIPANT_NAME VARCHAR2 360 Name of the salesrep of the transaction
PARTICIPANT_EMAIL VARCHAR2 320 Email address of the salesrep of the transaction
CREDITED_PARTICIPANT_ID NUMBER 18 Unique identifier for salesrep who will get credit for this transaction Active
CREDITED_PARTICIPANT_NAME VARCHAR2 360 Name of the salesrep who will get credit for this transaction
CREDITED_PARTICIPANT_EMAIL VARCHAR2 320 Email address of the salesrep who will get credit for this transaction
SOURCE_EVENT_DATE DATE Yes Date transaction was processed in the source system Active
CREDIT_DATE DATE Date based on which crediting rule will be determined Active
ROLLUP_DATE DATE Date based on which rollup hierarchy will be determined Active
TRANSACTION_PERIOD_ID NUMBER 18 Unique identifier of the period.
CREDIT_PERIOD_ID NUMBER 18 Unique identifier of the period.
TRANSACTION_AMT_SOURCE_CURR NUMBER Yes Transaction Amount in source currency Active
CREDIT_AMT_SOURCE_CURR NUMBER Credit Amount in source currency Active
SOURCE_CURRENCY_CODE VARCHAR2 15 Currency Code in which the transaction amount is specified Active
TRANSACTION_AMT_FUNC_CURR NUMBER Transaction Amount in Functional Currency
CREDIT_AMT_FUNC_CURR NUMBER Credit Amount in Functional Currency
SOURCE_TO_FUNC_CURR_CNVRT NUMBER Source to Function Currency conversion rate
TRANSACTION_AMT_HOME_CURR NUMBER Transaction amount in home currency
CREDIT_AMT_HOME_CURR NUMBER Credit amount in home currency
HOME_CURRENCY_CODE VARCHAR2 15 Home currency code
SOURCE_TO_HOME_CURR_CNVRT NUMBER Source to home currency conversion rate
TRANSACTION_AMT_CALC_CURR NUMBER Transaction Amount in calculation currency
CREDIT_AMT_CALC_CURR NUMBER Credit Amount in calculation currency
CALC_CURRENCY_CODE VARCHAR2 15 Calculation currency code
SOURCE_TO_CALC_CURR_CNVRT NUMBER Source to calculation currency conversion rate
REVENUE_TYPE VARCHAR2 30 Possible values : Revenue, Non revenue, a custom revenue type Active
DISCOUNT_PERCENTAGE NUMBER Discount Percentage, exposed in UI Active
MARGIN_PERCENTAGE NUMBER Margin Percentage, exposed in UI Active
TRANSACTION_QTY NUMBER Quantity of the unit sold in the transaction Active
TRANSACTION_SUB_TYPE VARCHAR2 30 In V1, possible value is only Base Active
TRANSACTION_TYPE VARCHAR2 30 Yes Transaction Type, identifying the source of the transaction Active
ELIGIBLE_CAT_ID NUMBER 18 Eligible Category, populated during classification Active
ELIGIBLE_CAT_NAME VARCHAR2 160 Eligible category name
OBJECT_STATUS VARCHAR2 30 Status of the transaction Active
CREDIT_OBJECT_STATUS VARCHAR2 30 Object status of imported credits
COLLECTION_STATUS VARCHAR2 30 Collection Status of the transaction Active
CREDIT_COLLECTION_STATUS VARCHAR2 30 Collection Status of the credits.
ADJUSTMENT_STATUS VARCHAR2 30 Adjustment Status Active
ADJUSTMENT_COMMENTS VARCHAR2 1000 Reason for adjustment Active
PROCESS_CODE VARCHAR2 30 Code to identify the phases required for the transaction; Points to a new table, which will contain a separate row for the processing_code, phase and a flag to indicate whether to skip the phase Active
SOURCE_BUSINESS_UNIT_ID NUMBER 18 Unique identifier of organization from which the transaction is imported Active
SOURCE_BUSINESS_UNIT_NAME VARCHAR2 240 Name of the organization from which the transaction is imported
BUSINESS_UNIT_ID NUMBER 18 Incentive Compensation organization identifier to which the transaction has been imported Active
BUSINESS_UNIT_NAME VARCHAR2 240 Incentive Compensation organization name to which the transaction has been imported
CREDIT_BUSINESS_UNIT_ID NUMBER 18 Business unit identifier of imported credits
SOURCE_TRX_NUMBER VARCHAR2 30 Yes User friendly unique identifier of the transaction Active
SOURCE_TRX_ID NUMBER 18 Header ID of the source trx Active
SOURCE_TRX_LINE_ID NUMBER 18 Line ID of the source trx Active
SOURCE_TRX_SALES_LINE_ID NUMBER 18 Sales credit id of the source trx Active
CUSTOMER_ID NUMBER 18 Unique identifier for customer Active
INVENTORY_ITEM_ID NUMBER 18 Unique identifier for item Active
ORDER_NUMBER VARCHAR2 30 Unique identifier for order Active
BOOKED_DATE DATE Date order gets booked Active
INVOICE_NUMBER VARCHAR2 30 Unique identifier for invoice Active
INVOICE_DATE DATE Invoice Date Active
BILL_TO_ADDRESS_ID NUMBER 18 Unique identifier of billing address Active
SHIP_TO_ADDRESS_ID NUMBER 18 Unique identifierr of shipping address Active
BILL_TO_CONTACT_ID NUMBER 18 Unique identifier of billing point of contact Active
SHIP_TO_CONTACT_ID NUMBER 18 Unique identifier of shipping point of contact Active
SALES_CHANNEL VARCHAR2 30 Sales Channel Active
SPLIT_PCT NUMBER Split Percentage Active
UOM_CODE VARCHAR2 10 Unit of Measure Active
REASON_CODE VARCHAR2 30 Reason for adjustment Active
CLSFN_RULE_ID NUMBER 18 Unique identifier for classification rule Active
CLSFN_RULE_NAME VARCHAR2 160 Name for classification rule
CREDIT_RULE_ID NUMBER 18 Unique identifier for credit rule
CREDIT_RULE_NAME VARCHAR2 160 Name of the credit rule
ROLE_ID NUMBER 18 Uniquely identifying the role of the salesrep in the group Active
ROLE_NAME VARCHAR2 60 Name of the role of the salesrep in the group
TERR_ID NUMBER 18 Unique identifier of territory Active
TERR_NAME VARCHAR2 1000 Territory Name Active
COUNTRY VARCHAR2 360 Name of the country
STATE VARCHAR2 360 Name of the state
CITY VARCHAR2 360 Name of the City
PROVINCE VARCHAR2 360 Name of the province
POSTAL_CODE VARCHAR2 360 Postal Code
AREA_CODE VARCHAR2 360 Area Code
CHANGED_TRX_FLAG VARCHAR2 1 Flag to indicate if this is a new transaction or a modified one. Active
HOLD_FLAG VARCHAR2 1 Transaction will not be considered for further processing if this flag is set to Y
CREDIT_HOLD_FLAG VARCHAR2 1 Credit will not be considered for further processing if this flag is set to Y
WORKER_ID NUMBER 18 Used to group transactions into batches Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
BATCH_ID NUMBER 18 This is the SYSTASK_ID for a given Job in MKT_IMP_JOBS
FILE_RECORD_NUM NUMBER This column is required by import wizard to relate record in the interface table to the file row
ERROR_MESSAGE VARCHAR2 3000 This is an optional column and would be useful if consumers want any error message as the first error
IMPORT_STATUS_CODE VARCHAR2 1 This column indicates import wizard if the import to base table was successful or Errored out
PROCESSED_FLAG VARCHAR2 1 Flag to indicate if the record is processed or not
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
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_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER21 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER22 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER23 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER24 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER25 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER26 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER27 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER28 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER29 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER30 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE31 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE32 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE33 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE34 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE35 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE36 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE37 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE38 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE39 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE40 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE41 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE42 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE43 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE44 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE45 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER31 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER32 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER33 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER34 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER35 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER36 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER37 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER38 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER39 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER40 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER41 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER42 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER43 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER44 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER45 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER46 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER47 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER48 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER49 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER50 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE46 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE47 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE48 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE49 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE50 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE51 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE52 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE53 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE54 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE55 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE56 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE57 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE58 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE59 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE60 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE61 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE62 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE63 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE64 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE65 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE66 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE67 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE68 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE69 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE70 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE71 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE72 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE73 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE74 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE75 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE76 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE77 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE78 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE79 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE80 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE81 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE82 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE83 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE84 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE85 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE86 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE87 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE88 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE89 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE90 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE91 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE92 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE93 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE94 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE95 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE96 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE97 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE98 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE99 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE100 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE101 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE102 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE103 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE104 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE105 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE106 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE107 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE108 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE109 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE110 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE111 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE112 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE113 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE114 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE115 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE116 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE117 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE118 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE119 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE120 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE121 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE122 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE123 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE124 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE125 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE126 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE127 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE128 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE129 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE130 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE131 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE132 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE133 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE134 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE135 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE136 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE137 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE138 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE139 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE140 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE141 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE142 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE143 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE144 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE145 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE146 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE147 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE148 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE149 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE150 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active

Foreign Keys

Table Foreign Table Foreign Key Column
CN_TP_TRANSACTIONS_STAGING_T cn_srp_participants_all PARTICIPANT_ID
CN_TP_TRANSACTIONS_STAGING_T cn_srp_participants_all CREDITED_PARTICIPANT_ID
CN_TP_TRANSACTIONS_STAGING_T cn_eligible_cats_all_b ELIGIBLE_CAT_ID
CN_TP_TRANSACTIONS_STAGING_T cn_rs_rules_all_b CLSFN_RULE_ID
CN_TP_TRANSACTIONS_STAGING_T cn_roles_b ROLE_ID
CN_TP_TRANSACTIONS_STAGING_T cn_tp_process_codes_b PROCESS_CODE
CN_TP_TRANSACTIONS_STAGING_T cn_rs_rules_all_b CREDIT_RULE_ID

Indexes

Index Uniqueness Tablespace Columns
CN_TP_TRANSACTIONS_STAGING_N1 Non Unique Default REQUEST_ID, BATCH_ID
CN_TP_TRANSACTIONS_STAGING_N2 Non Unique Default SOURCE_TRX_NUMBER, TRANSACTION_TYPE, REVENUE_TYPE
CN_TP_TRANSACTIONS_STAGING_N3 Non Unique Default REQUEST_ID, UPPER("PARTICIPANT_NAME"), UPPER("PARTICIPANT_EMAIL")
CN_TP_TRANSACTIONS_STAGING_N4 Non Unique Default REQUEST_ID, UPPER("CREDITED_PARTICIPANT_NAME"), UPPER("CREDITED_PARTICIPANT_EMAIL")
CN_TP_TRANSACTIONS_STAGING_N5 Non Unique Default BUSINESS_UNIT_ID, SOURCE_EVENT_DATE