CA_TXN_CRM(SQL Table) |
Index Back |
|---|---|
Transaction Attributes: CRM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CA_TXN_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Transaction ID |
| 2 | SETID_AGR | Character(5) | VARCHAR2(5) NOT NULL | Agreement SetID |
| 3 | AGREEMENT_CODE | Character(30) | VARCHAR2(30) NOT NULL | This field represents the agreement code (name) for an agreement |
| 4 | AGR_RENEWAL_NUM | Number(4,0) | SMALLINT NOT NULL | This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) |
| 5 | AGREEMENT_LINE | Character(10) | VARCHAR2(10) NOT NULL | This field records the value for the agreement line number |
| 6 | BUSINESS_UNIT_RF | Character(5) | VARCHAR2(5) NOT NULL | Field Services Business Unit |
| 7 | BUSINESS_UNIT_RC | Character(5) | VARCHAR2(5) NOT NULL | Call Center Business Unit |
| 8 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 9 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 10 | BUSINESS_UNIT_RO | Character(5) | VARCHAR2(5) NOT NULL | Order Capture Business Unit |
| 11 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Order Capture ID |
| 12 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 13 | CA_TXN_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
CRM Transaction Type
01=Agreement 02=Service Order 03=Case 04=Order Capture |
| 14 | CA_TXN_SUB_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
CRM Transaction Subtype
01=Fee 02=Uplift/Discount 03=Material 04=Labor 05=Expense 06=Onetime Fee |
| 15 | SERVICE_TYPE_CD | Character(8) | VARCHAR2(8) NOT NULL | User-definable code to classify the type of service. |
| 16 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 17 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 18 | RC_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | Case Source How this case origianated |
| 19 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case Type |
| 20 | EXP_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
This field is used to store the type of expense.
AIR=Airfare ENT=Entertainment FDB=Food - Breakfast FDD=Food - Dinner FDL=Food - Lunch GAS=Gas LOD=Lodging MIL=Mileage MIS=Miscellaneous PAR=Parking PHO=Phone REN=Rental Car TOL=Tolls |
| 21 | COST_CAT_CD | Character(6) | VARCHAR2(6) NOT NULL | Code used to define cost categories. |
| 22 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 23 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |