PAYMENT_SRCH_VW(SQL View) |
Index Back |
|---|---|
All Payments |
| SELECT a.deposit_bu , a.deposit_id , a.payment_seq_num , a.payment_id , b.oprid , b.assn_oprid , a.payment_status , a.accounting_dt , a.entry_dt , a.pp_sw , b.bank_setid , b.bank_cd , b.bnk_id_nbr , b.bank_acct_key , b.bank_account_num , a.deposit_bu , a.group_id , a.payment_amt , a.payment_currency , a.unpost_reason FROM PS_PAYMENT a , ps_deposit_control b WHERE a.deposit_bu=b.deposit_bu AND a.deposit_id=b.deposit_id |
| # | 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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW |
| 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.
Prompt Table: DEPOSIT_CONTROL |
| 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 | ASSN_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels. |
| 7 | PAYMENT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet |
| 8 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 9 | ENTRY_DT | Date(10) | DATE | Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT). |
| 10 | PP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Payment Predictor
Y/N Table Edit |
| 11 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 12 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 13 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 14 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 15 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 16 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL | Represents the high level grouping of multiple general ledger business units. |
| 17 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 18 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 19 | PAYMENT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different. |
| 20 | UNPOST_REASON | Character(10) | VARCHAR2(10) NOT NULL | Reason code for Unposted groups. For informational purposes. |