BUSINESS_UNITEM_AGREEMENT_IDVENDOR_SETIDVENDOR_IDVNDR_LOCY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
EM_MG_AGR_VC(SQL View) |
Index Back |
|---|---|
View of Suppliers w/o AgreemenView of Suppliers not linked to a Master Agreement |
| SELECT E.BUSINESS_UNIT , H.EM_AGREEMENT_ID , A.SETID , A.VENDOR_ID , C.VNDR_LOC , A.NAME1 , D.DESCR , H.EM_READY_FOR_REV , H.EM_AGREE_BUYER , H.EM_AGREE_SELLER FROM PS_VENDOR A , PS_EM_VENDOR_REG B , PS_VENDOR_LOC C , PS_VNDR_LOC_SCROL D , PS_EM_BUY_REG_TBL E , PS_SET_CNTRL_REC F , PS_SET_CNTRL_REC G , PS_EM_AGREEMENT H WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND C.SETID = D.SETID AND C.VENDOR_ID = D.VENDOR_ID AND C.VNDR_LOC = D.VNDR_LOC AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_VENDOR_LOC CC WHERE CC.SETID = C.SETID AND CC.VENDOR_ID = C.VENDOR_ID AND CC.VNDR_LOC = C.VNDR_LOC AND CC.EFFDT <= %CurrentDateIn) AND H.SETID = E.BUSINESS_UNIT AND H.VENDOR_SETID = C.SETID AND H.VENDOR_ID = C.VENDOR_ID AND H.VNDR_LOC = C.VNDR_LOC AND E.BUSINESS_UNIT = G.SETCNTRLVALUE AND G.REC_GROUP_ID = 'FS_38' AND G.RECNAME = 'VENDOR' AND G.SETID = A.SETID AND E.BUSINESS_UNIT = F.SETCNTRLVALUE AND F.REC_GROUP_ID = 'EM_01' AND F.RECNAME = 'EM_AGREEMENT' AND F.SETID = E.BUSINESS_UNIT AND H.EM_AGREE_BUYER = 'Y' AND H.EM_AGREE_SELLER = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EM_AGREEMENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Agreement Id |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | EM_READY_FOR_REV | Character(1) | VARCHAR2(1) NOT NULL |
This flag indicates whether a buyer is ready for an agreement to be reviewed by a seller. It triggers an e-mail for the seller.
Y/N Table Edit Default Value: N |
| 9 | EM_AGREE_BUYER | Character(1) | VARCHAR2(1) NOT NULL |
This flag indicates whether a buyer agrees with the contract.
Y/N Table Edit Default Value: N |
| 10 | EM_AGREE_SELLER | Character(1) | VARCHAR2(1) NOT NULL |
This flag indicates whether the agreement has been agreed to by the seller.
Y/N Table Edit Default Value: N |