CONTRACT_NUMCONTRACT_LINE_NUMAMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
A=Active
C=Cancelled
P=Pending
R=Renewed
GM_MD_CA_DTL_VW(SQL View) |
Index Back |
|---|---|
Contract Ln Detail of an AwardThis view contains the Contract Line Detail and Limit Details of an Award. |
| SELECT A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.PRODUCT_ID , A.DESCR , A.PRICING_STRUCTURE , A.START_DT , A.END_DT , A.CA_LINE_STATUS , A.LOC_DOC_ID , A.LOC_DOC_ID_END_DT , A.SUB_ACCOUNT_NUM , A.LOC_DOC_INACTIVE , B.LIMIT_AMT_BIL , B.LIMIT_AMT_REV , A.CURRENCY_CD FROM PS_CA_DETAIL A LEFT OUTER JOIN PS_CA_LMT_FEE_DTL B ON A.CONTRACT_NUM = B.CONTRACT_NUM AND A.CONTRACT_LINE_NUM = B.CONTRACT_LINE_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 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PRICING_STRUCTURE | Character(4) | VARCHAR2(4) NOT NULL |
Price Type
AMT=Amount PCT=Percent RATE=Rate RCR=Recurring |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | CA_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Obligation status
A=Active C=Cancelled P=Pending R=Renewed |
| 9 | LOC_DOC_ID | Character(30) | VARCHAR2(30) NOT NULL | Letter of Credit Document ID |
| 10 | LOC_DOC_ID_END_DT | Date(10) | DATE | LOC Doc ID End Date |
| 11 | SUB_ACCOUNT_NUM | Character(50) | VARCHAR2(50) NOT NULL | Subaccount ID |
| 12 | LOC_DOC_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL | Inactive Doc ID |
| 13 | LIMIT_AMT_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Funded/Billing Limit Amount |
| 14 | LIMIT_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Limit Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |