PYMT_MISC_VW(SQL View) |
Index Back |
|---|---|
PYMT_MISC_VW |
| SELECT DISTINCT A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , A.PAYMENT_ID , B.OPRID , A.CURRENCY_CD , A.PAYMENT_AMT , D.ACCOUNTING_DT , C.CUST_ID , C.SUBCUST_QUAL1 , C.SUBCUST_QUAL2 , D.JOURNAL_ID , D.JOURNAL_DATE , D.MOVEMENT_FLAG FROM PS_PAYMENT A , PS_DEPOSIT_CONTROL B , PS_PAYMENT_ID_CUST C , PS_PAY_MISC_DST D WHERE A.DEPOSIT_BU = B.DEPOSIT_BU AND A.DEPOSIT_ID = B.DEPOSIT_ID AND A.DEPOSIT_BU = C.DEPOSIT_BU AND A.DEPOSIT_ID = C.DEPOSIT_ID AND A.PAYMENT_SEQ_NUM = C.PAYMENT_SEQ_NUM AND A.DEPOSIT_BU = D.DEPOSIT_BU AND A.DEPOSIT_ID = D.DEPOSIT_ID AND A.PAYMENT_SEQ_NUM = D.PAYMENT_SEQ_NUM AND A.MISC_PAYMENT = 'Y' AND A.MISC_DST_BAL = 'C' AND A.PAYMENT_STATUS IN ('J', 'R') AND D.SYSTEM_DEFINED = 'U' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL | Identifies the business unit to which a deposit is posted. |
| 2 | DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 3 | PAYMENT_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 4 | PAYMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 8 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 9 | 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. |
| 10 | SUBCUST_QUAL1 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 11 | SUBCUST_QUAL2 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 12 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 13 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 14 | MOVEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural R=Reversal |