| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RNW_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
PSIRS-KK
|
| 2 |
RNW_CYCLE_NBR |
Number(6,0) |
INTEGER NOT NULL |
PSIRS-KK
Default Value: 1
|
| 3 |
RNW_CYCLE_START_DT |
Date(10) |
DATE NOT NULL |
PSIRS-KK
|
| 4 |
RNW_CYCLE_END_DT |
Date(10) |
DATE NOT NULL |
PSIRS-KK
|
| 5 |
RNW_CYCLE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
PSIRS-KK
DON=Done
PND=Pending
RDY=Ready
Default Value: PND
|
| 6 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
CA_PROD_RNW_VW
|
| 7 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
PROD_UOM_VW
|
| 8 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
RNW_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
PSIRS-KK
|
| 11 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 12 |
RNW_HOLD_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Cycle
Y/N Table Edit
Default Value: N
|
| 13 |
HOLD_RSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Hold Reason
Prompt Table:
CA_HOLD_RSN
|
| 14 |
RNW_CYC_HOLD_DT |
Date(10) |
DATE |
Renewal Cycle Hold Date
|
| 15 |
CREATE_CONTRACT_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
Create one contract line
A=Consolidated
E=Individual
Default Value: E
|
| 16 |
PRICE_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Basis
G=Contract Line Billing Amount
L=Then Current List Price
N=Contract Line Net Billing Amt
P=Contract Line List Price
U=User-entered Amount
|
| 17 |
ACCTG_DIST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Distribution Option
D=Default
L=Inherit From Line
|
| 18 |
RENEWAL_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Renewal Action
AUTO=Automatic
MANL=Manual
|
| 19 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 20 |
REV_PRICE_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Basis for Revenue
G=Contract Line Revenue Amount
L=Then Current Revenue Price
N=Contract Line Net Revenue Amt
P=Contract Line Revenue Price
U=User-entered Amount
Default Value: CA_RNW_CYCLE.PRICE_BASIS
|
| 21 |
GROSS_AMT_REV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Revenue Amount
|
| 22 |
NET_AMOUNT_REV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Revenue Amount
|
| 23 |
BUNDLE_OFFERING |
Character(20) |
VARCHAR2(20) NOT NULL |
Offering ID
Prompt Table:
%EDITTABLE
|