VCHR_ACT_TMP1

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
6 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
7 DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
8 INTEREST_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the interest.