SII_VAT_REQUEST

(SQL Table)
Index Back

VAT Transaction Update Request

  • Parent Record Of SII_VAT_REQ_BU SII_VAT_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 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

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

    Default Value: O

    6 RPT_TXN_FRM_DT Date(10) DATE NOT NULL Select Transactions From
    7 RPT_TXN_THRU_DT Date(10) DATE NOT NULL Select Transactions Thru
    8 RPT_YEAR Character(4) VARCHAR2(4) NOT NULL Reporting Year
    9 RPT_PERIOD Character(2) VARCHAR2(2) NOT NULL Reporting Period
    10 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
    11 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

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

    Y/N Table Edit

    Default Value: N