AUC_CNT_USRSTYL(SQL View) |
Index Back |
---|---|
Contract Style View13-Oct-2015 MB : Contract Style View - A view for CNTRCT_STYLE record which fetches the contract style values for the four process options (GN, AP, PO, BPO). |
SELECT A.OPRID ,B.CNTRCT_STYLE_NAME ,B.CNTRCT_STYLE ,B.CNTRCT_STRUCT_CD ,B.DESCR50 ,B.STYLE_STATUS ,B.CNTRCT_PROC_OPT FROM PS_CNTRCT_STYLE B , PS_OPR_DEF_TBL_SS A WHERE ((A.AUC_GENCONTRACT='Y' AND B.CNTRCT_PROC_OPT = 'GN') OR (A.AUC_SINGRELPOCONT='Y' AND B.CNTRCT_PROC_OPT = 'BPO') OR (A.AUC_PO_CONTRACT='Y' AND B.CNTRCT_PROC_OPT = 'PO') OR (A.AUC_REC_VCHRCNTRCT='Y' AND B.CNTRCT_PROC_OPT = 'AP')) AND B.STYLE_STATUS='A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Style Description |
3 | CNTRCT_STYLE | Character(10) | VARCHAR2(10) NOT NULL | Contract Style |
4 | CNTRCT_STRUCT_CD | Character(4) | VARCHAR2(4) NOT NULL |
Valid Structures for Contract Styles
ADHD=Ad Hoc Document AP=Recurring Voucher BPO=Release to Single PO Only DST=Distributor GN=General Contract GRPM=Group Multi Supplier GRPS=Group Single Supplier MFG=Manufacturer PADV=Prepaid Voucher w/ Advance PO PO=Purchase Order POD=Purchase Order Document PPAY=Prepaid Voucher RPOV=Recurring PO Voucher SED=Sourcing Event Document SPP=Special Purpose |
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
6 | STYLE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Style Status
A=Active I=Inactive |
7 | CNTRCT_PROC_OPT | Character(4) | VARCHAR2(4) NOT NULL |
Contract Process Option
AP=Recurring Voucher BPO=Release to Single PO Only DST=Distributor GN=General Contract GRPM=Group Multi Supplier GRPS=Group Single Supplier MFG=Manufacturer PADV=Prepaid Voucher w/ Advance PO PO=Purchase Order PPAY=Prepaid Voucher RPOV=Recurring PO Voucher SPP=Special Purpose |