EM_BUSINESS_UNITPROPOSE_IDVOUCHER_IDEM_VCH_PRO_L_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.EM_BUSINESS_UNIT , B.PROPOSE_ID , B.VOUCHER_ID , C.DUE_DT , C.GROSS_AMT , C.DSCNT_AMT , (C.GROSS_AMT - C.DSCNT_AMT) , C.PYMNT_TERMS_CD , B.PROPOSE_DSCNT_AMT , B.PROPOSE_SETL_AMT FROM PS_EM_PROPOSAL_LN B , PS_VOUCHER C WHERE B.EM_BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EM_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | From Business Unit |
| 2 | PROPOSE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Propose ID |
| 3 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | 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. |
| 5 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 6 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 7 | CURRENT_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current Settlement Amount |
| 8 | 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. |
| 9 | PROPOSE_DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Proposed new discount amount |
| 10 | PROPOSE_SETL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Propose Settlement Amount |