WTHD_CALC7_TAO

#	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	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
5	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
6	WTHD_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Withholding Entity
7	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type
8	WTHD_JUR_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Jurisdiction
9	WTHD_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Withholding Class
10	OVERRIDE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Override Rule Type Parameters Default Value: N
11	WTHD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
12	NETAMT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Net Amount
13	FREIGHT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Freight
14	MISC_CHG_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Miscellaneous Charges
15	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
16	DSCNT_ALWAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always take discount
17	WHTD_DSCNT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Discount
18	WTHD_SUT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Sales/Use Tax
19	WTHD_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply VAT
20	EXCISE_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Excise Tax
21	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.
22	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
23	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
24	APPL_ON_FIRST_PAY	Character(1)	VARCHAR2(1) NOT NULL	Applicable to First Payment
25	DECIMAL_POS_TXN	Number(2,0)	SMALLINT NOT NULL	Txn Decimal Positions
26	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
27	ORG_WTHD_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Original withholding amount calculated by the withholding calculation ae.
28	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
29	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
30	MISC_CHG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement
31	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
32	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
33	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.
34	VAT_DSCNT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Dscnt Adj
35	EXS_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount
36	PP_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Applied Prepaid Gross Amt
37	ACCUM_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This accumulated basis field will be stored in the currency of the withholding entity.
38	FREIGHT_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
39	DSCNT_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
40	TAX_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
41	VAT_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amount
42	MISC_CHG_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc Charge Amt
43	EXS_TAX_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount
44	MERCHANDISE_AMT_S	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt