CONVR_PYMT_D_VW

(SQL View)
Index Back

Payment DEP Prompt for Convers


SELECT PAYMENT_ID , DEPOSIT_BU , DEPOSIT_ID , PAYMENT_AMT , PAYMENT_CURRENCY , ACCOUNTING_DT FROM PS_PAYMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONVR_QUAL_FIELD Character(30) VARCHAR2(30) NOT NULL Conversation Qualifier Field
2 CONVR_QUAL_BU Character(5) VARCHAR2(5) NOT NULL Conversation Qualifier BU
3 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.
4 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.
5 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.
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple