PO_CHNG_CNTRLN

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
F=Project Funding
R=Project Resource Transaction
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
8 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
11 CNTRCT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Divider
12 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 DECIMAL_POS_CNTR Number(1,0) SMALLINT NOT NULL Contract Cur Decimal Positions
15 QTY_WRK_LINE_OTHER Number(16,4) DECIMAL(15,4) NOT NULL Non Open Transaction Quantity
16 AMT_WRK_LINE_OTHER Number(27,3) DECIMAL(26,3) NOT NULL Non Open Transaction Amount
17 AMT_WRK_LINE_OPEN Number(27,3) DECIMAL(26,3) NOT NULL Open Transaction Amount
18 QTY_WRK_LINE_OTHMN Signed Number(17,4) DECIMAL(15,4) NOT NULL Non Open Transaction Quantity
19 AMT_WRK_LINE_OTHMN Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Open Transaction Amount
20 AMT_WRK_LINE_OPNMN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Transaction Amount