CA_AP_FEE_ADJ (SQL Table)	Index Back
Revenue Plan Fee Adjustment This is the fee adjustment schedule record. This record handles adjustments to scheduled fees.

CA_AP_FEE_ADJ

(SQL Table)

Revenue Plan Fee Adjustment

This is the fee adjustment schedule record. This record handles adjustments to scheduled fees.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
Default Value: 1

4 AP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=Pending
PRG=In Progress
RDY=Ready
RIN=Reversal Initiated
RIP=Reversal In Progress
RVS=Reversed
Default Value: NEW

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD

6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 1
4	AP_EVENT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Event Status CAN=Cancelled DON=Completed HLD=Hold Event NEW=Pending PRG=In Progress RDY=Ready RIN=Reversal Initiated RIP=Reversal In Progress RVS=Reversed Default Value: NEW
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_CONTR_HDR.CURRENCY_CD
6	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount