CN_TP_SIM_TXNS_CRDS_GT
This table stores temporary data during the creation of Calculation Simulations based on a mapping from some source.
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | 18 | The identifier of the simulation transaction. If the simulation transaction is supposed to override a real transaction, this ID must match. | |
PARTICIPANT_ID | NUMBER | 18 | Unique identifier for salesrep of the transaction | |
SOURCE_EVENT_DATE | DATE | Date on which the transaction was processed in the source system | ||
SOURCE_EVENT_PERIOD_ID | NUMBER | 18 | Period ID of source event date | |
CREDIT_DATE | DATE | Date based on which crediting rule will be determined | ||
ROLLUP_DATE | DATE | Date based on which rollup hierarchy will be determined | ||
TRANSACTION_AMT_SOURCE_CURR | NUMBER | Transaction Amount in source currency | ||
SOURCE_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code in which the source amounts are specified | |
TRANSACTION_AMT_FUNC_CURR | NUMBER | Transaction Amount in Functional Currency | ||
SOURCE_TO_FUNC_CURR_CNVRT | NUMBER | Conversion rate used to convert from source to functional currency | ||
DISCOUNT_PERCENTAGE | NUMBER | Discount Percentage, exposed in UI | ||
MARGIN_PERCENTAGE | NUMBER | Margin Percentage, exposed in UI | ||
TRANSACTION_QTY | NUMBER | Quantity of the unit sold in the transaction | ||
TRANSACTION_SUB_TYPE | VARCHAR2 | 30 | In V1, possible value is only Base | |
TRANSACTION_TYPE | VARCHAR2 | 30 | Transaction Type, identifying the source of the transaction | |
NEW_TRANSACTION_ID | NUMBER | 18 | Points to the new transaction created by an adjustment | |
ELIGIBLE_CAT_ID | NUMBER | 18 | Eligible Category, populated during classification | |
SOURCE_TYPE | VARCHAR2 | 30 | Will identify the source of the transaction. Possible Values are Manual and Collection | |
OBJECT_STATUS | VARCHAR2 | 30 | Status of the transaction | |
COLLECTION_STATUS | VARCHAR2 | 30 | Collection Status of the transaction | |
ADJUSTMENT_STATUS | VARCHAR2 | 30 | Adjustment Status | |
ADJUSTMENT_COMMENTS | VARCHAR2 | 1000 | Reason for adjustment | |
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 | |
SOURCE_ORG_ID | NUMBER | 18 | Unique identifier of organization from which the transaction is imported | |
ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |
SOURCE_TRX_NUMBER | VARCHAR2 | 30 | User friendly unique identifier of the transaction | |
SOURCE_TRX_ID | NUMBER | 18 | Header ID of the source trx | |
SOURCE_TRX_LINE_ID | NUMBER | 18 | Line ID of the source trx | |
SOURCE_TRX_SALES_LINE_ID | NUMBER | 18 | Sales credit id of the source trx | |
CUSTOMER_ID | NUMBER | Unique identifier for customer | ||
INVENTORY_ITEM_ID | NUMBER | Unique identifier for item | ||
ORDER_NUMBER | VARCHAR2 | 30 | Unique identifier for order | |
BOOKED_DATE | DATE | Date order gets booked | ||
INVOICE_NUMBER | VARCHAR2 | 30 | Unique identifier for invoice | |
INVOICE_DATE | DATE | Invoice Date | ||
BILL_TO_ADDRESS_ID | NUMBER | Unique identifier of billing address | ||
SHIP_TO_ADDRESS_ID | NUMBER | Unique identifierr of shipping address | ||
BILL_TO_CONTACT_ID | NUMBER | Unique identifier of billing point of contact | ||
SHIP_TO_CONTACT_ID | NUMBER | Unique identifier of shipping point of contact | ||
SALES_CHANNEL | VARCHAR2 | 30 | Sales Channel | |
UOM_CODE | VARCHAR2 | 10 | Unit of Measure | |
REASON_CODE | VARCHAR2 | 30 | Reason for adjustment | |
CLSFN_RULE_ID | NUMBER | 18 | Unique identifier for classification rule | |
ROLE_ID | NUMBER | 18 | Uniquely identifying the role of the salesrep in the group | |
TERR_ID | NUMBER | 18 | Unique identifier of territory | |
TERR_NAME | VARCHAR2 | 1000 | Territory Name | |
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. | |
HOLD_FLAG | VARCHAR2 | 1 | Transaction will not be considered for further processing if this flag is set to Y | |
PRESERVE_CREDIT_FLAG | VARCHAR2 | 1 | Flag to indicate if the corresponding credit has been adjusted. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE15 | VARCHAR2 | 240 | 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_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. | |
ATTRIBUTE17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
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. | |
ATTRIBUTE32 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE33 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE34 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE35 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE36 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE37 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE38 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE39 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE40 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE41 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE42 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE43 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE44 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE45 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
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. | |
ATTRIBUTE47 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE48 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE49 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE50 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE51 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE52 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE53 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE54 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE55 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE56 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE57 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE58 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE59 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE60 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE61 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE62 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE63 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE64 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE65 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE66 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE67 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE68 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE69 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE70 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE71 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE72 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE73 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE74 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE75 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE76 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE77 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE78 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE79 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE80 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE81 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE82 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE83 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE84 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE85 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE86 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE87 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE88 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE89 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE90 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE91 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE92 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE93 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE94 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE95 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE96 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE97 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE98 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE99 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE100 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE101 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE102 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE103 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE104 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE105 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE106 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE107 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE108 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE109 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE110 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE111 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE112 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE113 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE114 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE115 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE116 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE117 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE118 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE119 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE120 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE121 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE122 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE123 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE124 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE125 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE126 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE127 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE128 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE129 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE130 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE131 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE132 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE133 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE134 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE135 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE136 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE137 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE138 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE139 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE140 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE141 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE142 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE143 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE144 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE145 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE146 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE147 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE148 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE149 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ATTRIBUTE150 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
ERROR_CODE | VARCHAR2 | 30 | ERROR_CODE column capatures the classification and crediting error reason. | |
CALC_CURRENCY_CODE | VARCHAR2 | 15 | Participant's calculation currency code | |
CALC_TO_FUNC_CURR_CNVRT | NUMBER | Rate used to convert credit amount from calculation currency to functional currency. This column will be populated while creating record from credit UI | ||
CALC_TO_HOME_CURR_CNVRT | NUMBER | Rate used to convert credit amount from calculation currency to home currency | ||
CALC_TO_SOURCE_CURR_CNVRT | NUMBER | Rate used to convert amount from calculation currency to source currency : this will be populated during credit adjustment in UI | ||
CHANGED_CREDIT_FLAG | VARCHAR2 | 1 | Flag to indicate if this is a modified credit | |
CREATED_DURING | VARCHAR2 | 30 | Possible values: Crediting, Summarization, Rollup, Team Rollup | |
CREDITED_PARTICIPANT_ID | NUMBER | 18 | Unique identifier for credited salesrep | |
CREDIT_AMT_CALC_CURR | NUMBER | Credit amount in Calculation currency | ||
CREDIT_AMT_FUNC_CURR | NUMBER | Credit amount in functional currency | ||
CREDIT_AMT_HOME_CURR | NUMBER | Credit amount in Home currency | ||
CREDIT_AMT_SOURCE_CURR | NUMBER | Credit Amount in source currency | ||
CREDIT_ID | NUMBER | 18 | The identifier of the simulation credit. If the simulation credit is supposed to override a real credit, this ID must match. | |
CREDIT_RULE_ID | NUMBER | 18 | Unique identifier for credit rule | |
CREDIT_TYPE | VARCHAR2 | 30 | Possible Values : Direct, Indirect, Summarized | |
DIRECT_RULE_ID | NUMBER | 18 | Unique identifier for credit rule | |
HOME_CURRENCY_CODE | VARCHAR2 | 15 | Participant's home currency code | |
NEW_CREDIT_ID | NUMBER | 18 | Points to the adjusted credit record | |
REVENUE_TYPE | VARCHAR2 | 30 | Possible values : Revenue, Non revenue, a custom revenue type | |
ROLLUP_LEVEL | NUMBER | 18 | Level in the hierarchy in case of rollup credits | |
SOURCE_CREDIT_ID | NUMBER | 18 | Points to the source credit/summarized credit record from which the rollup credit is generated. This column will have value only for rollup credits. | |
SOURCE_TO_CALC_CURR_CNVRT | NUMBER | Rate used to convert credit amount from source currency to calculation currency. This will be populated while creating the credits in the crediting process | ||
SOURCE_TO_HOME_CURR_CNVRT | NUMBER | Rate used to ocnvert credit amount from Source currency to Participant's home currency. This column will be populated while creating record from the crediting process | ||
SPLIT_PCT | NUMBER | Split Percentage | ||
SUMMARY_CREDIT_ID | NUMBER | 18 | Points to the summarized credit record. This column will have value for direct credits if summarization is enabled. | |
TRANSACTION_AMT_CALC_CURR | NUMBER | Transaction amount in Calculation currency | ||
TRANSACTION_AMT_HOME_CURR | NUMBER | Transaction amount in Home currency | ||
CREDIT_OBJECT_STATUS | VARCHAR2 | 30 | Status of the credit Possible values : Credited,Summary Rolled up,Rolled up,Rollup Error,Eligible,Eligibility Error,Reversed |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CN_TP_SIM_TXNS_CRDS_N1 | Non Unique | TRANSACTION_ID, CREDIT_ID |