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 |