VAT_BI_IDEN4LVW(SQL View) |
Index Back |
|---|---|
Bill Line Identifier Prompt |
| SELECT DISTINCT A.SETID , 'S' , A.DISC_SUR_ID , A.LANGUAGE_CD , A.DESCR FROM PS_BI_DISC_SUR_LNG A ,PS_BI_DISC_SUR B WHERE A.SETID = B.SETID AND A.BI_CURRENCY_CD = B.BI_CURRENCY_CD AND A.DISC_SUR_ID = B.DISC_SUR_ID AND A.EFFDT = B.EFFDT AND B.DISC_SUR_INDICATOR IN ('I', 'S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | 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 |
Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |