VAT_CLCCC_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: CC_SEC_VW
3	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
4	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
5	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
7	TRANS_DT	Date(10)	DATE NOT NULL	Transaction Date
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: CC_TRANS_LINE.DTTM_STAMP
10	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment Default Value: DST
11	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
12	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
13	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. "
14	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
15	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
16	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.
17	VAT_RCVRY_PCT_TMP	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	VAT Recovery Percent Temp
18	VAT_CALC_LINE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculation Line Amount
19	DSCNT_PCT_TMP	Number(9,5)	DECIMAL(8,5) NOT NULL	Discount Percentage Temp
20	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
21	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.
22	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
23	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
24	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
25	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
26	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt in Base Curr
27	VAT_DSCNT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj
28	VAT_DSCNT_ADJ_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discount Adjust Base Curr
29	VAT_DSCNT_RCVRY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj Rcvr
30	VAT_DSCNT_RCVR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Discnt Recovery Base Curr
31	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
32	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt in Base Curr
33	VAT_REBATE_PCT_TMP	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	VAT Rebate Percent Temp
34	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.
35	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
36	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
37	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.
38	VAT_CALC_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
39	VAT_CALC_EFFDT	Date(10)	DATE	VAT Calculation Effective Date
40	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.
41	TAX_CD_PCT_TMP	Signed Number(9,6)	DECIMAL(7,6) NOT NULL	VAT Tax Code Pct Temp
42	VAT_BASIS_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Basis Amount Temp
43	VAT_CALC_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Calculated Amount Temp
44	VAT_RCVRY_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Recovery Amount Temp
45	VAT_DSCNT_ADJ_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Adjustment Temp
46	VAT_DSCNT_RCVR_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Recovery Amt Temp
47	VAT_REBATE_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Rebate Amount Temp
48	VAT_CALC_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Miscellaneous
49	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
50	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
51	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
52	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
53	ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up
54	ROUND_RULE_TMP	Character(1)	VARCHAR2(1) NOT NULL	Round Rule
55	VAT_BASIS_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Basis Amt Temp (base)
56	VAT_AMT_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	Calculated VAT Amt Temp (base)
57	VAT_RCVRY_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Recovery Amt Temp (base)
58	VAT_D_ADJ_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Adj Temp (base)
59	VAT_D_RCV_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Discount Recovery Temp
60	VAT_REBATE_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Rebate Amt Temp (base)
61	VAT_TRANS_AMT_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Trans Amt Temp
62	VAT_TX_AMT_BSE_TMP	Signed Number(30,5)	DECIMAL(28,5) NOT NULL	VAT Trans Amt Temp (base)
63	ROUND_FACTOR	Number(15,7)	DECIMAL(14,7) NOT NULL	Rounding Factor
64	TRUNC_PRECISION	Signed Number(3,0)	DECIMAL(2) NOT NULL	Truncation Precision
65	ROUND_INTER_RESULT	Signed Number(17,0)	DECIMAL(16) NOT NULL	Rounding inter result
66	AMOUNT_OUT1	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 1
67	AMOUNT_OUT2	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 2
68	AMOUNT_OUT3	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 3
69	AMOUNT_OUT4	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 4
70	AMOUNT_OUT5	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 5
71	AMOUNT_OUT6	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 6
72	AMOUNT_OUT7	Signed Number(31,5)	DECIMAL(29,5) NOT NULL	Output Amount 7
73	ROUND_AMOUNT_TMP1	Signed Number(24,0)	DECIMAL(23) NOT NULL	Round Amount Temp1
74	ROUND_AMOUNT_TMP2	Signed Number(18,8)	DECIMAL(16,8) NOT NULL	Round Amount Temp2
75	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