CNTRCT_BU_PO_VW(SQL View) |
Index Back |
---|---|
Contract PO Distrib BUsContract PO Distrib BUs ************************************************************************************ Date Initials Reference # Description 09/20/11 PRAG 12997362 We resolved critical security issues related to Business Unit Prompt values. ************************************************************************************ |
SELECT a.SETID , a.CNTRCT_ID , a.VERSION_NBR , a.CNTRCT_LINE_NBR , a.BUSINESS_UNIT , a.CNTRCT_TYPE ,%subrec(LAST_UPDATE_SBR, a) FROM PS_CNTRCT_BU_DSTRB a WHERE CNTRCT_TYPE = 'PO' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
3 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
4 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: CNT_PO_VW |
6 | CNTRCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Contract Type
AP=Recurring Voucher GN=General Contract MS=Master Contract PO=Purchase Order Default Value: PO |
7 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
8 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |