PYMT_TRMS_NET

(SQL Table)
Index Back

Net Payment Terms

  • Parent record: PYMT_TRMS_CNTL
  • # 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 BASIS_FROM_DAY Number(2,0) SMALLINT NOT NULL Basis From Day

    Default Value: 1

    6 BASIS_TO_DAY Number(2,0) SMALLINT NOT NULL Basis To Day

    Default Value: 31

    7 NET_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Net Terms Timing ID

    Prompt Table: PYMT_TRMS_TIME

    8 DSC_TRMS_AVAIL_FLG Character(1) VARCHAR2(1) NOT NULL Discount Terms Available

    Y/N Table Edit

    Default Value: N

    9 REBATE_TERM_FLG Character(1) VARCHAR2(1) NOT NULL Rebate Term Available

    Y/N Table Edit

    Default Value: N

    10 REBATE_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Daily Rebate Percent
    11 REBATE_MAX_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Maximum Rebate Percent