VAT_CALC_TSTHDR

(SQL Table)
Index Back

VAT Calc Test Header

  • Parent Record Of VAT_CALC_TSTLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 INVOICE_DT Date(10) DATE Invoice Date

    Default Value: %date

    5 DSCNT_PCT Number(7,3) DECIMAL(6,3) NOT NULL Discount Percentage
    6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    7 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
    E=Exclusive
    I=Inclusive
    8 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
    G=Calculate at Gross
    N=Calculate at Net
    9 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
    10 VAT_CALC_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
    11 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Prompt Table: RT_TYPE_TBL