CA_RNW_LN_LINK(SQL Table) |
Index Back |
|---|---|
Rnw Lines not Linked to Cycle |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RNW_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL |
PSIRS-KK
Prompt Table: CA_RNW_PKG |
| 2 | RNW_CYCLE_NBR |
Number(6,0) | INTEGER NOT NULL |
PSIRS-KK
Prompt Table: CA_RNW_CYCLE |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 4 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 5 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: CA_PROD_RNW_VW |
| 6 | 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 |
| 7 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_DETAIL.CURRENCY_CD |
| 9 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 10 | ACCTG_DIST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Distribution Option
D=Default L=Inherit From Line |
| 11 | 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. |
| 12 | GROSS_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Amount |
| 13 | NET_AMOUNT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Amount |
| 14 | BUNDLE_OFFERING | Character(20) | VARCHAR2(20) NOT NULL |
Offering ID
Prompt Table: %EDITTABLE |