EX_VAT_DIST_VW

(SQL View)
 Index Back

EX VAT Distrib. Work Scroll

Expenses VAT Distribution Lines Work Scroll This record is used in TE_SHEET_VAT_SUM page.

SELECT ' ' , ' ' , 0 , 0 , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , 0 , 0 , 0 , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 TRANS_DT Date(10) DATE Transaction Date
6 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
7 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
8 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
12 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
13 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
14 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
15 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
16 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
17 VAT_APORT_CNTRL Character(1) VARCHAR2(1) NOT NULL VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
18 VAT_RCVRY_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
19 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
20 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
21 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
22 VAT_REBATE_PCT_SRC Character(1) VARCHAR2(1) NOT NULL VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
23 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
24 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
25 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
26 VAT_RECLAIM_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Reclaim Percent
27 VAT_RCLM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Reclaim Amount
28 VAT_RCLM_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base VAT Reclaim Amount
29 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
30 DESCR Character(30) VARCHAR2(30) NOT NULL Description