EM_BUYER_PRO_VW(SQL View) |
Index Back |
|---|---|
Dynamic Discount Proposal HeadDynamic Discount Proposal Header |
| SELECT DISTINCT B.OPRID , A.EM_BUSINESS_UNIT , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PROPOSE_ID , A.PROPOSE_TYPE , A.CREATE_DATE , A.PROPOSAL_STATUS , A.PYMNT_TERMS_CD , A.DUE_DATE , A.EXPIRATION_DATE , A.NEW_TOT_DISC_AMT , A.NEW_TOT_SETL_AMT , A.CUR_TOT_DISC_AMT , A.CUR_TOT_INV_AMT , A.CUR_TOT_SETL_AMT , A.TOT_DISC_DIFF_AMT , A.BASIS_DATE , A.TOT_INTEREST_AMT , A.TOT_GAIN_LOSS , A.DSCNT_DUE_DT , A.INTEREST_RATE , A.CURRENCY_CD , A.COMMENT1 FROM PS_EM_PROPOSAL_HDR A , PS_EM_BU_USRSEC_VW B WHERE A.EM_BUSINESS_UNIT = B.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_EM_AGREEMENT C WHERE A.EM_BUSINESS_UNIT = C.SETID AND A.VENDOR_SETID = C.VENDOR_SETID AND A.VENDOR_ID = C.VENDOR_ID AND A.VNDR_LOC = C.VNDR_LOC) |
| # | 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
Prompt Table: EM_BU_VNAGRT_VW |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | PROPOSE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Propose ID |
| 7 | PROPOSE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Proposal Type
O=Buyer Offer P=Supplier Proposal |
| 8 | CREATE_DATE | Date(10) | DATE |
Creation Date
Default Value: %DATE |
| 9 | PROPOSAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Status:
A=Approved C=Cancelled D=Denied P=Pending S=Submitted Default Value: P |
| 10 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: PYMT_TRMS_VW |
| 11 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 12 | EXPIRATION_DATE | Date(10) | DATE |
Expiration Date
Default Value: %DATE |
| 13 | NEW_TOT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 14 | NEW_TOT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | New Amount |
| 15 | CUR_TOT_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total discount amount |
| 16 | CUR_TOT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total invoice amount |
| 17 | CUR_TOT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current total settlement amount |
| 18 | TOT_DISC_DIFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total discount differenct amounts |
| 19 | BASIS_DATE | Date(10) | DATE |
Basis Date
Default Value: %DATE |
| 20 | TOT_INTEREST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total potential interest amounts earned |
| 21 | TOT_GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total gain or loss of potential total interest earned |
| 22 | DSCNT_DUE_DT | Date(10) | DATE | Discount Due Date |
| 23 | INTEREST_RATE | Number(9,5) | DECIMAL(8,5) NOT NULL | Interest Rate |
| 24 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 25 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |