CONTRACT_NUMCONTRACT_LINE_NUMCA_FEE_STATUS1=Fee Generated
2=Bil Actual Fee
3=Bil Additional Award Fee
4=Rev Actual Fee
5=Rev Additional Award Fee
CA_PR_FEE_VW1(SQL View) |
Index Back |
|---|---|
CA_PR_FEE_VW1Cost Plus Project Resource Fee view used by view CA_PR_FEE_VW |
| SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , CA_FEE_STATUS , SUM(FOREIGN_AMOUNT) , FOREIGN_CURRENCY FROM PS_CA_PR_SUMM WHERE CONTRACT_NUM <> ' ' AND CONTRACT_LINE_NUM <> 0 AND CA_FEE_STATUS IN ('2','3','4','5') GROUP BY CONTRACT_NUM , CONTRACT_LINE_NUM , CA_FEE_STATUS, FOREIGN_CURRENCY |
| # | 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 | 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. |
| 5 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |