AR_CA_SRCH_VW(SQL View) |
Index Back |
|---|---|
AR Contract Search ViewAR Contract Search View. |
| SELECT H.CONTRACT_NUM , %Coalesce(D.CONTRACT_LINE_NUM, 0) , H.CONTRACT_TYPE , %Coalesce(B.BILLING_SPECIALIST, ' ') , %Coalesce(B.BILLING_AUTHORITY, ' ') , H.LOC_REFERENCE_ID , %Coalesce(G.REF_AWD_NUMBER, ' ') FROM PS_CA_CONTR_HDR H LEFT OUTER JOIN PS_CA_DETAIL D ON H.CONTRACT_NUM = D.CONTRACT_NUM LEFT OUTER JOIN PS_CA_BILL_PLAN B ON D.CONTRACT_NUM = B.CONTRACT_NUM AND D.BILL_PLAN_ID = B.BILL_PLAN_ID LEFT OUTER JOIN PS_GM_AWARD G ON G.CONTRACT_NUM = H.CONTRACT_NUM |
| # | 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 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 4 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 5 | BILLING_AUTHORITY | Character(8) | VARCHAR2(8) NOT NULL | Billing Authority |
| 6 | LOC_REFERENCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Letter of Credit ID |
| 7 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |