OPRIDEM_BUSINESS_UNITPROPOSE_IDA=Approved
C=Cancelled
D=Denied
P=Pending
S=Submitted
Default Value: P
O=Buyer Offer
P=Supplier Proposal
EM_PRO_BUYER_V2(SQL View) |
Index Back |
|---|
| SELECT B.OPRID , A.EM_BUSINESS_UNIT , A.VENDOR_ID , A.PROPOSE_ID , A.PROPOSAL_STATUS , A.PROPOSE_TYPE , A.CUR_TOT_INV_AMT , A.NEW_TOT_DISC_AMT , A.NEW_TOT_SETL_AMT , A.CREATE_DATE , A.CURRENCY_CD , A.EXPIRATION_DATE FROM PS_EM_PROPOSAL_HDR A , PS_EM_BU_USRSEC_VW B WHERE A.EM_BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSE_TYPE = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EM_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | From Business Unit |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | PROPOSE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Propose ID |
| 5 | PROPOSAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Status:
A=Approved C=Cancelled D=Denied P=Pending S=Submitted Default Value: P |
| 6 | PROPOSE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Type
O=Buyer Offer P=Supplier Proposal |
| 7 | CUR_TOT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total invoice amount |
| 8 | NEW_TOT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 9 | NEW_TOT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 10 | CREATE_DATE | Date(10) | DATE | Creation Date |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |