DOC_TYPE_A_VW

(SQL View)
 Index Back

Automatic Doc Types


select setid, doc_type, descr, jrnl_code from PS_DOC_TYPE_TBL where seq_type = 'A'

  • Related Language Record: DOC_TYPE_LANG

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

    Prompt Table: SP_SETID_NONVW

    2 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

    Prompt Table: DOC_TYPE_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code

    Prompt Table: JRNL_CODE_TBL