| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPR_DEF_TBL_PM
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
CNTRCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 5 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 6 |
CAT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Category Line Number
|
| 7 |
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
|
| 8 |
SUBNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Subscribing Node
|
| 9 |
CS_CNTRCT_ID_PR |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Contract ID
|
| 10 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 11 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 12 |
CNTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
|
| 13 |
AMT_CNTRCT_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Maximum Amount of Contract.
|
| 14 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 16 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 17 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 18 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 19 |
QTY_LINE_RELEASED |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Total Line Qty Released
|
| 20 |
AMT_LINE_RELEASED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Amt Released
|
| 21 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime
|