CNTRCT_ACTXVOU1(SQL View) |
Index Back |
|---|---|
Contract Activity - VoucherDESCR_VALUE_1 = PRCR_DOC_TYPE xlat long name DESCR_VALUE_2 = Document status xlat long name |
| SELECT A.VENDOR_SETID , A.VENDOR_ID , A.CNTRCT_SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_LINE_NBR , A.BUSINESS_UNIT , A.CNT_ACTRPT_ID , A.LINE_NBR , A.PRCR_DOC_TYPE , B1.XLATLONGNAME , A.DOCSTAT_DATE , A.CURRENCY_CD , A.MERCHANDISE_AMT , A.FIELDNAME , A.STATUS_TEXT , B2.XLATLONGNAME FROM PS_CNTRCT_ACT_VOU1 A , PSXLATITEM B1 , PSXLATITEM B2 WHERE B1.FIELDNAME = 'PRCR_DOC_TYPE' AND B1.FIELDVALUE = A.PRCR_DOC_TYPE AND B1.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM B11, B1, %CURRENTDATEIN) AND B2.FIELDNAME = A.FIELDNAME AND B2.FIELDVALUE = A.STATUS_TEXT AND B2.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM B21, B2, %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | CNTRCT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 5 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 6 | CNTRCT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 7 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | CNT_ACTRPT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used as the Document ID for the Contract Activity Report. |
| 9 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 10 | PRCR_DOC_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Document Type
CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order |
| 11 | DESCR_VALUE_1 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | DOCSTAT_DATE | Date(10) | DATE | Document Date |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 15 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 16 | STATUS_TEXT | Character(4) | VARCHAR2(4) NOT NULL | Status Text |
| 17 | DESCR_VALUE_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |