MPT_CLC_PAY_TMP

(SQL Table)
Index Back

Mult Trms Calc Ex Pay Data Tmp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
3 INSTALLMENT_NBR Number(2,0) SMALLINT NOT NULL Installment Number
4 SNGL_PYMNT_TRMS_CD Character(5) VARCHAR2(5) NOT NULL Single-Payment Terms ID
5 INSTALLMENT_PCT Number(12,8) DECIMAL(11,8) NOT NULL Installment Percent
6 INST_GROSS_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Installment Gross Amount
7 INST_BASIS_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Installment Basis Amount
8 INST_BASIS_DT Date(10) DATE Installment Basis Date