| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 2 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
|
| 3 |
CAT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Category Line Number
|
| 4 |
AMT_LINE_RELEASED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Amt Released
|
| 5 |
CURR_LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Current line release amount
|
| 6 |
ORIG_LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Date Initials Issue Description
092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|