PYMT_TRMS_DSCNT

(SQL Table)
Index Back

Discount Payment Terms

  • Parent record: PYMT_TRMS_NET
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 NET_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Net Terms Sequence Number
    5 DSCNT_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Discount Terms Sequence Number
    6 DSCNT_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Discount Terms Timing ID

    Prompt Table: PYMT_TRMS_TIME

    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