VAT_SRC_DEFN

(SQL Table)
 Index Back

VAT Update Source Definition

Source products using the VAT Transaction Loader

  • Related Language Record: VAT_SRC_DFN_LNG

  • Parent Record Of SII_RGS_MAP_LST SII_SRC_VEW_LST VAT_UPD_SRC_LST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VAT_SOURCE_DEFN Character(10) VARCHAR2(10) NOT NULL Update VAT Source Definition
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
    N=Inactive
    Y=Active

    Y/N Table Edit

    Default Value: N

    4 RECNAME_BU Character(15) VARCHAR2(15) NOT NULL Business Unit Recname

    Prompt Table: RECNAME_BU_VW

    5 RECNAME_DOCID_TMP Character(15) VARCHAR2(15) NOT NULL Doc ID Work Table

    Prompt Table: RECDEFN_VW

    6 RECNAME_HEADER Character(15) VARCHAR2(15) NOT NULL Header Record

    Prompt Table: RECDEFN_VW

    7 RECNAME_LINE Character(15) VARCHAR2(15) NOT NULL Line Record

    Prompt Table: RECNAME_VAT_VW

    8 RECNAME_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table

    Prompt Table: RECDEFN_VW

    9 RECNAME_XREF_TMP Character(15) VARCHAR2(15) NOT NULL Cross Reference Work Table

    Prompt Table: RECDEFN_VW

    10 FIELDNAME_BU Character(18) VARCHAR2(18) NOT NULL Business Unit Field Name

    Default Value: BUSINESS_UNIT

    Prompt Table: RECFIELD_SRC_VW

    11 FIELDNAME_BU_GL Character(18) VARCHAR2(18) NOT NULL Business Unit GL Field Name

    Default Value: BUSINESS_UNIT_GL

    Prompt Table: RECFIELD_BU_VW

    12 FIELDNAME_PROC_FLG Character(18) VARCHAR2(18) NOT NULL In-Process Fieldname

    Prompt Table: RECFIELD_HDR_VW

    13 ONVALUE Character(4) VARCHAR2(4) NOT NULL On Value
    14 OFFVALUE Character(4) VARCHAR2(4) NOT NULL Off Value
    15 RESET_PROCINSTANCE Character(1) VARCHAR2(1) NOT NULL Reset Proc Instance

    Y/N Table Edit