CNTRCT_ACTX_T(SQL Table) |
Index Back |
|---|---|
Contract Activity Temp Table07/24/2009 PKL 1905919001 Ensured that contract activity report show current version number DESCRSHORT = CNTRCT_STATUS Xlat short DESCR_VALUE_1 = PRCR_DOC_TYPE xlat long name DESCR_VALUE_2 = Document status xlat long name CURRENCY_CD1 = CNTRCT_HDR.CURRENCY_CD CURRENCY_CD = Document Currency Code |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | CNTRCT_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 7 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 8 | CNTRCT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 9 | 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 |
| 10 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | CNT_ACTRPT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used as the Document ID for the Contract Activity Report. |
| 12 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 13 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 14 | DESCR_VALUE_1 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 15 | CNTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled |
| 16 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | AMT_CNTRCT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount of Contract. |
| 18 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 19 | DOCSTAT_DATE | Date(10) | DATE | Document Date |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 22 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 23 | STATUS_TEXT | Character(4) | VARCHAR2(4) NOT NULL | Status Text |
| 24 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 25 | DESCR_VALUE_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |