AR_CA_HEADER_VW(SQL View) |
Index Back |
|---|---|
AR Contract Header ViewAR Contract Header View |
| SELECT H.BUSINESS_UNIT , H.CONTRACT_NUM , H.CONTRACT_TYPE , H.LOC_REFERENCE_ID , %Coalesce(A.REF_AWD_NUMBER, ' ') FROM PS_CA_CONTR_HDR H LEFT JOIN PS_GM_AWARD A ON H.CONTRACT_NUM = A.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 2 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 4 | LOC_REFERENCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Letter of Credit ID |
| 5 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |