SPT_CLC_PAY_TMP

(SQL Table)
Index Back

Sngl 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 BASIS_TO_DAY Number(2,0) SMALLINT NOT NULL Basis To Day
4 DSCNT_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Discount Terms Sequence Number
5 NET_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Net Terms Timing ID
6 DSCNT_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Discount Terms Timing ID
7 TERMS_ADJUST_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Terms Adjustment Days
8 DSCNT_TRMS_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Discount Terms Percent
9 DSCNT_TRMS_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Terms Amount