AM_STD_WRTY

(SQL Table)
 Index Back

Asset Standard Warranties

  • Related Language Record: AM_STD_WRTY_LNG

    • # 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: SP_SETID_NONVW

    2 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 MFG_WRTY_FLG Character(1) VARCHAR2(1) NOT NULL Manufacturer's Warranty
    N=No
    Y=Yes
    5 COVERAGE Long Character CLOB Coverage
    6 WRTY_REFUND_DAYS Number(4,0) SMALLINT NOT NULL This field is intended to indicate the number of days during which an item can be returned for a refund.
    7 WRTY_RETURN_DAYS Number(4,0) SMALLINT NOT NULL This field is intended to indicate the number of days during which the covered item can be returned for credit
    8 WRTY_REPLACE_DAYS Number(4,0) SMALLINT NOT NULL This field is intended to indicate the number of days during which the item may be returned for replacement with a similar item.
    9 WRTY_RMA_REQ_FLG Character(1) VARCHAR2(1) NOT NULL This field is intended to indicate whether a request for material authorization is required under the warranty
    N=No
    Y=Yes
    10 WRTY_LOAN_FLG Character(1) VARCHAR2(1) NOT NULL This field is intended to indicate whether the warranty covers provision of a loaned item to the customer while the defective item is being repaired.
    N=No
    Y=Yes
    11 WRTY_ON_SITE_FLG Character(1) VARCHAR2(1) NOT NULL This field is intended to indicate whether the warranty covers on-site repair.
    N=No
    Y=Yes
    12 WRTY_XFER_FLG Character(1) VARCHAR2(1) NOT NULL This field is intended to indicate whether the warranty is transferable
    N=No
    Y=Yes