VAT_UPD_REQUEST

(SQL Table)
 Index Back

VAT Transaction Update Request

  • Parent Record Of GST_LOAD_SRC VAT_UPD_REQ_BU VAT_UPD_REQ_SRC

    • # 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 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

    Prompt Table: VAT_ENTITY

    6 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: N

    7 ALL_PRODUCTS Character(1) VARCHAR2(1) NOT NULL All Products

    Y/N Table Edit

    Default Value: N

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

    Default Value: %DATE