SETIDDefault Value: OPR_DEF_TBL_FS.SETID
CNTRCT_IDVERSION_NBRDefault Value: 1
Prompt Table: CNT_PO_VW
Prompt Table:
VENDOR_LOC_VW
Set Control Field: SETID
Prompt Table: BUYER_ACTIVE_VW
CS_CNTDEFBU_VW(SQL View) |
Index Back |
|---|---|
Bind Mappings for Contract Def3/22/2011 TBG Bind Mappings for Contract Defaults |
| SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.BUSINESS_UNIT , B.DESCR , A.VNDR_LOC , A.BUYER_ID FROM PS_CNTRCT_DEFAULTS A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_CNTRCT_HDR C WHERE C.SETID = A.SETID AND C.CNTRCT_ID = A.CNTRCT_ID AND C.VERSION_STATUS = 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.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
Default Value: 1 |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: CNT_PO_VW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VENDOR_LOC_VW
|
| 7 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ACTIVE_VW |