VAT_VCHR_TMP

(SQL Table)
Index Back

VAT Voucher Temporary Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
2 TAX_POINT_DT Date(10) DATE Tax Point Date
3 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
4 VAT_NONINV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amt Base Curr
5 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
6 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
7 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
8 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
9 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
10 VAT_ANLSYS_CD Character(6) VARCHAR2(6) NOT NULL VAT Analysis Code
11 VAT_ANLSYS_CD_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Analysis Code Type
E=EC Acquisition Tax
I=VAT Inclusive
N=No VAT
R=Reverse Charge Tax
V=VAT Chargeable
12 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
13 BSE_CALC_PRE_DSCNT Character(1) VARCHAR2(1) NOT NULL Calc Basis Before Discount
14 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
15 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.