CNTRCT_VALIDATE(SQL Table) |
Index Back |
|---|---|
Used to populate return rowsetUsed to populate return rowset for ValidateContract |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 2 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 3 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 4 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 5 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 6 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 7 | AMT_RELSD_OPEN_ITM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amt relsd for Open Item |
| 8 | AMT_CNTRCT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount of Contract. |
| 9 | QTY_LINE_MIN | Number(15,2) | DECIMAL(14,2) NOT NULL | Min Line Qty Per Order |
| 10 | QTY_LINE_MAX | Number(15,2) | DECIMAL(14,2) NOT NULL | Max Line Qty Per Contract |
| 11 | AMT_LINE_MIN | Number(27,3) | DECIMAL(26,3) NOT NULL | Min Line Amt Per Order |
| 12 | AMT_LINE_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Max Line Amt Per Contract |
| 13 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | STD_UOM | Character(1) | VARCHAR2(1) NOT NULL | Std UOM |
| 17 | UOM_PO | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure PO |
| 18 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 19 | VALID_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Valid XLAT flag |
| 20 | CNTRCT_VALID_CD | Character(2) | VARCHAR2(2) NOT NULL |
Return Codes for Contract Validation
1=Invalid quantity and amount 10=Out of the Contract date range 11=Invalid UOM 12=Contract below minimum qty 13=Contract exceeds maximum qty 14=Contract below minimum amt 15=Contract exceeds maximum amt 16=Contract total amount exceeded 17=No uom conversion exists 18=Invalid Version 2=Amount Only with Open Item 3=No Line w/Amount Only Contract 4=Enter a Contract Line Number 5=Contract/PO line is cancelled 6=Contract/PO line closed 7=Contract is different currency 8=Contract is different UOM 9=Invalid Supplier |