CA_BI_MGT_MI_V3

(SQL View)
Index Back

Billing Management Milest. Vw


SELECT B.CONTRACT_NUM , D.BILL_PLAN_ID , F.EVENT_OCCURRENCE , B.FOREIGN_CURRENCY , E.BUSINESS_UNIT , E.BUSINESS_UNIT_BI , E.BILL_TO_CUST_ID , A.BP_STATUS , A.HOLD_FLAG , A.HOLD_DATE , F.BILL_EVENT_TYPE , F.BP_EVENT_STATUS , F.CA_PERCENTAGE FROM PS_CA_PROJ_SUMMARY B , PS_CA_DETAIL D , PS_CA_DETAIL_PROJ C , PS_CA_CONTR_HDR E , PS_CA_BILL_PLAN A , PS_CA_BP_EVENTS F WHERE C.CONTRACT_NUM = B.CONTRACT_NUM AND C.BUSINESS_UNIT_PC = B.BUSINESS_UNIT_PC AND C.PROJECT_ID = B.PROJECT_ID AND C.ACTIVITY_ID = B.ACTIVITY_ID AND D.CONTRACT_NUM = C.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = C.CONTRACT_LINE_NUM AND C.CONTRACT_NUM = E.CONTRACT_NUM AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.BILL_PLAN_ID = D.BILL_PLAN_ID AND A.BILL_PLAN_TYPE = '04' AND A.CONTRACT_NUM = F.CONTRACT_NUM AND A.BILL_PLAN_ID = F.BILL_PLAN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
3 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
7 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
8 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
9 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

10 HOLD_DATE Date(10) DATE Put On Hold Date
11 BILL_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Event Types -- Date or Milestone
01=Date
02=Milestone
12 BP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=New Event
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
REC=Recycled
RIN=Reversal Initiated
RIP=Reversal In Progress
RRP=Recycled
RVS=Reversed
13 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage