VAT_IDENGR4_LVW(SQL View) |
Index Back |
---|---|
BI Line Identifier Group View3 |
SELECT A.SETID , 'SVC' , A.SERVICE_TYPE_CD , A.LANGUAGE_CD , A.SHORT_DESCR FROM PS_RF_SRV_TYP_LANG A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IDEN_GRP_SETID | Character(5) | VARCHAR2(5) NOT NULL | Product Group SetID |
2 | IDENTIFIER_TBL | Character(3) | VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID CON=Contracts D=Discount Table G=Generic Identifier ID=PS/Billing Charge Id ITM=PS/Inventory Item ID LAB=Labor type PDA=Product Alias PRD=PS/Product Id PRM=PS/Promotion Code S=Surcharge Table SVC=Service UPC=UPC UPN=Universal Item ID |
3 | IDENTIFIER_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Identifier |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |