CA_PR_FEE_VW(SQL View) |
Index Back |
|---|---|
Used by query CA_LMT_FEE_RPTCost Plus Project Resource Fee view outer joined by CA_DETAIL |
| SELECT D.CONTRACT_NUM , D.CONTRACT_LINE_NUM , P.CA_FEE_STATUS , H.BUSINESS_UNIT , H.SOLD_TO_CUST_ID , H.CONTRACT_TYPE , H.CA_RQST_SRC , H.CONTRACT_ADMIN , P.FOREIGN_AMOUNT , D.CURRENCY_CD , D.CA_FEE_TYPE , D.BILL_PLAN_ID , D.ACCT_PLAN_ID , L.LIMIT_FEE_BIL , L.FEE_AMT_AAWD_BIL , G.LAST_RUN_DTM , F.LIMIT_FEE_REV , F.FEE_AMT_AAWD_REV , F.LAST_RUN_DTM FROM PS_CA_CONTR_HDR H , PS_CA_LMT_FEE_DTL L , PS_CA_DETAIL D , PS_CA_PR_FEE_VW1 P , PS_CA_AP_FEE_WS F , PS_CA_BP_FEE_WS G WHERE D.CONTRACT_NUM = P.CONTRACT_NUM (+) AND D.CONTRACT_LINE_NUM = P.CONTRACT_LINE_NUM (+) AND D.CONTRACT_NUM = F.CONTRACT_NUM (+) AND D.ACCT_PLAN_ID = F.ACCT_PLAN_ID (+) AND D.CONTRACT_NUM = G.CONTRACT_NUM (+) AND D.BILL_PLAN_ID = G.BILL_PLAN_ID (+) AND H.CONTRACT_NUM = D.CONTRACT_NUM AND H.CA_PROC_STATUS = 'A' AND D.CONTRACT_NUM = L.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = L.CONTRACT_LINE_NUM AND D.CA_FEE_TYPE <> '01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | CA_FEE_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Cost Plus Fee Status for Governement Contracts
1=Fee Generated 2=Bil Actual Fee 3=Bil Additional Award Fee 4=Rev Actual Fee 5=Rev Additional Award Fee |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 6 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 7 | 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 |
| 8 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL | Contract Administrator defined on CABU. |
| 9 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 10 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 11 | 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 |
| 12 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 13 | ACCT_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 14 | LIMIT_FEE_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Funded / Billing Fee Limit Amount |
| 15 | FEE_AMT_AAWD_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Additional Funded /Billing Award Amount |
| 16 | LAST_RUN_DTM | DateTime(26) | TIMESTAMP | Last Run On |
| 17 | LIMIT_FEE_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Fee Limit Amount |
| 18 | FEE_AMT_AAWD_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Additional Revenue Award Amount |
| 19 | RUN_DT | Date(10) | DATE | Run Date |