VAT_CALC_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VAT_CALC_TXN_ID	Character(22)	VARCHAR2(22) NOT NULL	VAT Calculation Transaction ID
4	VAT_CALC_LINE_NUM	Number(5,0)	INTEGER NOT NULL	VAT Calculation Line Number
5	VAT_CALC_SCHED_NUM	Number(6,0)	INTEGER NOT NULL	Schedule Number
6	VAT_CALC_DISTRIB	Number(5,0)	INTEGER NOT NULL	VAT Distribution Line
7	VAT_TYPE_SRC	Character(2)	VARCHAR2(2) NOT NULL	VAT Type Source AP=AP AR=AR BI=BI EX=EX GL=GL OM=OM PC=PO Change Orders PO=PO Stage Type 'O' PR=PO Stage Type 'R'
8	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
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	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
11	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
12	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
13	VAT_RCVRY_PCT_TMP	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	VAT Recovery Percent Temp
14	VAT_CALC_LINE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculation Line Amount
15	DSCNT_PCT_TMP	Number(9,5)	DECIMAL(8,5) NOT NULL	Discount Percentage Temp
16	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
17	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.
18	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
19	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
20	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
21	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
22	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
23	VAT_DSCNT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj
24	VAT_DSCNT_ADJ_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discount Adjust Base Curr
25	VAT_DSCNT_RCVRY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj Rcvr
26	VAT_DSCNT_RCVR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discnt Recovery Base Curr
27	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
28	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt in Base Curr
29	VAT_REBATE_PCT_TMP	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	VAT Rebate Percent Temp
30	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.
31	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
32	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
33	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.
34	VAT_CALC_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
35	VAT_CALC_EFFDT	Date(10)	DATE	VAT Calculation Effective Date
36	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
37	TAX_CD_PCT_TMP	Signed Number(9,6)	DECIMAL(7,6) NOT NULL	VAT Tax Code Pct Temp
38	VAT_BASIS_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Basis Amount Temp
39	VAT_CALC_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Calculated Amount Temp
40	VAT_RCVRY_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Recovery Amount Temp
41	VAT_DSCNT_ADJ_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Adjustment Temp
42	VAT_DSCNT_RCVR_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Recovery Amt Temp
43	VAT_REBATE_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Rebate Amount Temp
44	VAT_CALC_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Miscellaneous
45	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
46	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
47	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
48	VAT_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount in base currency against which the VAT is applicable
49	ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up
50	ROUND_RULE_TMP	Character(1)	VARCHAR2(1) NOT NULL	Round Rule
51	VAT_BASIS_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Basis Amt Temp (base)
52	VAT_AMT_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	Calculated VAT Amt Temp (base)
53	VAT_RCVRY_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Recovery Amt Temp (base)
54	VAT_D_ADJ_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Adj Temp (base)
55	VAT_D_RCV_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Recovery Temp
56	VAT_REBATE_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Rebate Amt Temp (base)
57	VAT_TRANS_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Trans Amt Temp
58	VAT_TX_AMT_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Trans Amt Temp (base)
59	ROUND_FACTOR	Number(15,7)	DECIMAL(14,7) NOT NULL	Rounding Factor
60	TRUNC_PRECISION	Signed Number(3,0)	DECIMAL(2) NOT NULL	Truncation Precision
61	ROUND_INTER_RESULT	Signed Number(17,0)	DECIMAL(16) NOT NULL	Rounding inter result
62	AMOUNT_OUT1	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 1
63	AMOUNT_OUT2	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 2
64	AMOUNT_OUT3	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 3
65	AMOUNT_OUT4	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 4
66	AMOUNT_OUT5	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 5
67	AMOUNT_OUT6	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 6
68	AMOUNT_OUT7	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 7
69	ROUND_AMOUNT_TMP1	Signed Number(24,0)	DECIMAL(23) NOT NULL	Round Amount Temp1
70	ROUND_AMOUNT_TMP2	Signed Number(18,8)	DECIMAL(16,8) NOT NULL	Round Amount Temp2
71	ERROR_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Error Status 1=None 2=Unbalanced 3=CF Combo Error 4=No Exchange Rate 5=Acct Not Specified 6=IU Processor Error 7=Document Sequencing Error