CA_AP_EVENT_VW

(SQL View)
 Index Back

SELECT A.CONTRACT_NUM , A.ACCT_PLAN_ID , B.EVENT_NUM , A.AP_STATUS , A.CUST_ID , A.HOLD_FLAG , C.BUSINESS_UNIT , D.BUSINESS_UNIT_GL , A.REV_RECOG_METHOD , A.LAST_REV_REC_DT , B.CA_PERCENTAGE , B.CURRENCY_CD , B.AMOUNT , B.AP_EVENT_STATUS , B.ACCOUNTING_DT , B.CA_PER_COMPLETE , B.PCT_CHANGE FROM PS_CA_ACCTPLAN A , PS_CA_AP_EVENT B , PS_CA_CONTR_HDR C , PS_BUS_UNIT_TBL_CA D WHERE %Join(COMMON_KEYS, CA_ACCTPLAN A, CA_AP_EVENT B ) AND A.CONTRACT_NUM = C.CONTRACT_NUM AND C.BUSINESS_UNIT = D.BUSINESS_UNIT

# 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 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
4 AP_STATUS Character(3) VARCHAR2(3) NOT NULL Rev Rec Plan Status
CAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CA_SOLD_TO_VW

6 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_FS_NONVW

8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_FS_NONVW

9 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
10 LAST_REV_REC_DT Date(10) DATE Processed On
11 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
14 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
15 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
16 CA_PER_COMPLETE Number(12,8) DECIMAL(11,8) NOT NULL Percent Complete
17 PCT_CHANGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Incremental % Complete