CA_BI_MGMT_VW2(SQL View) |
Index Back |
---|---|
Billing ManagementBilling Management General View. The contract num is available twice because we need it as a non-key in CA_BI_MGMT_INQ_PNL. |
SELECT DISTINCT A.CONTRACT_NUM , A.BILL_PLAN_ID ,A.DESCR , A.CURRENCY_CD , E.BUSINESS_UNIT , E.BUSINESS_UNIT_BI , E.BILL_TO_CUST_ID , E.CA_PROC_STATUS , A.BILL_PLAN_TYPE , A.BP_STATUS , E.CA_RQST_SRC , A.HOLD_FLAG , A.HOLD_DATE , A.BILL_THRU_DATE , A.CONTRACT_NUM , DET.CA_FEE_TYPE FROM PS_CA_BILL_PLAN A , PS_CA_CONTR_HDR E , PS_CA_DETAIL DET WHERE A.CONTRACT_NUM = E.CONTRACT_NUM AND A.CONTRACT_NUM = DET.CONTRACT_NUM (+) AND A.BILL_PLAN_ID = DET.BILL_PLAN_ID (+) AND E.CA_RQST_SRC <> 'OND' AND E.CA_PROC_STATUS <> 'C' AND NOT EXISTS ( SELECT 'X' FROM PS_CA_BI_MGMT_VW3 V3 WHERE V3.CONTRACT_NUM = A.CONTRACT_NUM AND V3.BILL_PLAN_ID = A.BILL_PLAN_ID AND V3.CURRENCY_CD = A.CURRENCY_CD) |
# | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
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 | CA_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active C=Closed P=Pending |
9 | BILL_PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Billing Method
01=As Incurred 02=Installment 03=Recurring 04=Milestone 05=Percent Complete 06=Immediate 07=Value Based |
10 | 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 |
11 | CA_RQST_SRC | Character(3) | VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard |
12 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hold
N=Hold Y=Hold |
13 | HOLD_DATE | Date(10) | DATE | Put On Hold Date |
14 | BILL_THRU_DATE | Date(10) | DATE | Billed Thru Date |
15 | CONTRACT_NUM_CA | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
16 | CA_FEE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Cost Plus Fee Type
01=None 02=Fixed Fee 03=Award Fee 04=Incentive Fee 05=Other Fee |