CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
BILL_PLAN_IDCONTRACT_LINE_NUMY/N Table Edit
CA_BP_LOCDOC_VW(SQL View) |
Index Back |
|---|
| SELECT CONTRACT_NUM , BILL_PLAN_ID , CONTRACT_LINE_NUM , LOC_DOC_ID , SUB_ACCOUNT_NUM , LOC_DOC_ID_END_DT , LOC_DOC_INACTIVE FROM PS_CA_DETAIL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 2 | BILL_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 3 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 4 | LOC_DOC_ID | Character(30) | VARCHAR2(30) NOT NULL | Letter of Credit Document ID |
| 5 | SUB_ACCOUNT_NUM | Character(50) | VARCHAR2(50) NOT NULL | Subaccount ID |
| 6 | LOC_DOC_ID_END_DT | Date(10) | DATE | LOC Doc ID End Date |
| 7 | LOC_DOC_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Inactive Doc ID
Y/N Table Edit |