ACCTG_TAG_HD

(SQL Table)
Index Back

Accounting Tag Header Records

This table contains Accounting tag header definition information.

  • Parent Record Of ACCTG_TAG_PERM ACCTG_TAG_TBL
  • # 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 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag
    3 BALANCE_PCT Character(1) VARCHAR2(1) NOT NULL Balanced Speedchart
    N=No
    Y=Yes

    Default Value: N

    4 ACCTG_TAG_TYPE Character(1) VARCHAR2(1) NOT NULL Permission for Accounting Tag
    C=Permission List
    O=User List
    U=All Users

    Default Value: U

    5 PUBLISH Character(1) VARCHAR2(1) NOT NULL Publish Data
    6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    8 ACCTG_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Accounting Line Type
    M=Multiple Line
    S=Single Line

    Default Value: M