PAYMENT1_VW(SQL View) |
Index Back |
---|---|
Unique Payments |
SELECT deposit_bu , deposit_id , payment_seq_num , payment_id , entry_dt FROM PS_PAYMENT WHERE payment_status = 'W' |
# | 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_BUARDS_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 | 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). |