GST_TXNLOAD_REQ

(SQL Table)
 Index Back

GST Transaction Run Control

GST Transaction Run Control

  • Parent Record Of GST_LOAD_REQ_BU

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

    Default Value: 9999

    4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: O

    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 GL_BU Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW
    Set Control Field: SETID

    7 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.

    Prompt Table: ORG_RGSTN_DTL

    8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW
    Set Control Field: SETID

    9 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
    N=Specific Business Unit
    Y=All Business Units

    Y/N Table Edit

    Default Value: Y

    10 DATE_FROM Date(10) DATE NOT NULL Date From
    11 DATE_TO Date(10) DATE NOT NULL Date To
    12 ALL_PRODUCTS Character(1) VARCHAR2(1) NOT NULL All Products

    Y/N Table Edit

    Default Value: N

    13 AS_OF_DATE Date(10) DATE NOT NULL As of Date

    Default Value: %DATE