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 |