AM_VAT_ATTR_L2

(SQL Table)
Index Back

AM Vat Attributes

  • Parent record: AM_VAT_ATTR_L1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    4 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID
    5 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
    6 BUSINESS_UNIT_VAT Character(5) VARCHAR2(5) NOT NULL Vat Apportionment Business Uni

    Prompt Table: SP_BUVAT_NONVW

    7 CHARTFIELD_PR1_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 1 Value
    8 CHARTFIELD_PR2_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 2 Value
    9 YEAR_OF_REG Number(4,0) SMALLINT NOT NULL Year of Regularization
    10 VAT_CONFIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Final Coeff. of Constraint
    11 VAT_TAXFIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Final Coefficient of Taxation
    12 VAT_ADMFIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Final Coefficient of Admission
    13 VAT_RCVRFIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Final Vat Recoverability %
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    15 VAT_RCVRY_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recoverable Adjustment
    16 ADJUSTMENT_DT Date(10) DATE Adjustment Date

    Default Value: %DATE

    17 VAT_ATTR_STATUS Character(1) VARCHAR2(1) NOT NULL VAT Attribute Status
    E=Errored
    F=Final
    N=New
    P=Posted
    T=Temporary