BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROPOSAL_IDPrompt Table: GM_PROP_ID_VW
CMTD=03 - Committed
CNCL=05 - Canceled
DENY=04 - Denied
DRAF=01 - Draft
NSUB=Not Submitted
RDY=02 - Ready
SUBM=Submitted
SUBR=Submitted With Error
GM_PROPOSAL_VW8(SQL View) |
Index Back |
|---|---|
Proposal w/o sales person viewProposal without sales person code view |
| SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.CUST_ID , A.SALES_PERSON ,A.SUBMIT_STATUS ,A.DUE_DT ,A.THRESHOLD_PCT ,A.TOTAL_BUDGET_AMT ,A.COST_AMT ,A.PM_MARGIN_PCT ,A.CURRENCY_CD ,A.CURRENT_VERSION ,' ' FROM PS_GM_PROPOSAL A WHERE A.SALES_PERSON = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 5 | SALES_PERSON | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer. |
| 6 | SUBMIT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Proposal Submission Status
CMTD=03 - Committed CNCL=05 - Canceled DENY=04 - Denied DRAF=01 - Draft NSUB=Not Submitted RDY=02 - Ready SUBM=Submitted SUBR=Submitted With Error |
| 7 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 8 | THRESHOLD_PCT | Number(3,0) | SMALLINT NOT NULL | Confidence % |
| 9 | TOTAL_BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | TOTAL_BUDGET_AMT |
| 10 | COST_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount |
| 11 | PM_MARGIN_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | CURRENT_VERSION | Character(1) | VARCHAR2(1) NOT NULL | Current Version |
| 14 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |