VAT_BI_IDEN1_VW(SQL View) |
Index Back |
|---|---|
Bill Line Identifier View1 |
| SELECT DISTINCT SETID , 'ID' , CHARGE_ID , DESCR FROM PS_BI_CHARGE |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |