CA_MS_SLC_SS_VW(SQL View) |
Index Back |
---|---|
Contract Milestone Search ViewThis is a Self-Service iClient search view for the CA_Milestone table |
SELECT CONTRACT_NUM ,MS_SEQNUM FROM PS_CA_MILESTONE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
2 | MS_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Milestone Number |