GPCH_AL_SDR_DTL

(SQL Table)
Index Back

Unique Report Address

Unique Report Address

  • Related Language Record: GPCH_AL_SDR_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPRDEFN.LANGUAGE_CD

    4 GPCH_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

    Prompt Table: GPCH_BL_PR_RPT

    5 GPCH_SI_SUB_RPT Character(2) VARCHAR2(2) NOT NULL To select a Sub Category of a Report
    FR=GPCHTX01 - FR
    GE=GPCHTX01 - GE
    NA=Not Applicable
    TI=GPCHTX01 - TI
    VD=GPCHTX01 - VD

    Default Value: NA

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    14 GPCH_AL_POSTBOX Long Character CLOB Post Box
    15 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    16 GPCH_AL_SIGNATURE Character(30) VARCHAR2(30) NOT NULL Signature