WTHD_CLC51_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	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
12	WTHD_ADDTL_GROSS	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Additional Withheld Gross Amt
13	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
14	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
15	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
16	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
17	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
18	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid
19	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
20	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
21	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
22	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
23	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
24	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
25	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
26	PYMNT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Payment Action P=Prepayment Applied R=Record a Payment S=Schedule Payment W=Escheated Payment X=Cancelled
27	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
28	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
29	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
30	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes
31	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold
32	REMIT_BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Setid
33	REMIT_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Code
34	REMIT_BNK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Remit Bank Account
35	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
36	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
37	ORIG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Original Process Instance
38	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
39	DECIMAL_POS_TXN	Number(2,0)	SMALLINT NOT NULL	Txn Decimal Positions
40	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
41	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
42	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month
43	PREPAID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prepaid Status A=Applied B=Pending Application C=Pending Unapply D=Pending Change F=Fully Applied I=Inactive P=Available Prepayment R=Restricted U=Unapplied X=Cancelled
44	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
45	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
46	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
47	INVOICE_DT	Date(10)	DATE	Invoice Date
48	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
49	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
50	VCHR_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Voucher supplier loc
51	VCHR_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Voucher supplier's address seq
52	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
53	WTHD_RULE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
54	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.
55	BSE_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Base Rate Multiplier for Exchange Rates
56	BSE_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Base Rate Divisor for Exchange Rates
57	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. "
58	DECIMAL_POS_BSE	Number(2,0)	SMALLINT NOT NULL	Base Cur Decimal Positions
59	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
60	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
61	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
62	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
63	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
64	DECIMAL_POS_ENT	Number(2,0)	SMALLINT NOT NULL	Entity Decimal Positions
65	ENT_VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Supplier Set ID For Entity
66	ENT_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Supplier ID
67	ENT_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Supplier Location For Entity
68	ENT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Wthd_address_seq_num
69	ENTITY_HDR_EFFDT	Date(10)	DATE	Effective Date
70	APPLY_BALANCE	Character(1)	VARCHAR2(1) NOT NULL	Specifies whether we apply withholding on the invoicing vendor or the remit_to vendor I=Invoicing Supplier R=Remit to Supplier
71	NETAMT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Net Amount
72	FREIGHT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Freight
73	MISC_CHG_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Miscellaneous Charges
74	WHTD_DSCNT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Discount
75	WTHD_SUT_APPL	Character(1)	VARCHAR2(1) NOT NULL	Apply Sales/Use Tax
76	WTHD_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply VAT
77	EXCISE_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Excise Tax
78	ENT_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	TE Rate Multiplier
79	ENT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	TE Rate Divisor
80	WTHD_ROUND_OPT	Character(1)	VARCHAR2(1) NOT NULL	Withhold Rounding Option to be applied to withhold calculations. D=Round Down I=TDS Withholding Round N=Natural Round R=Nearest Rupee Rounding U=Round Up
81	BU_REGIST_ID	Character(20)	VARCHAR2(20) NOT NULL	BU Tax Identification Number
82	BU_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Category
83	COLLECT_AGENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Collection Agent Flag N=Is NOT Collection Agent Y=Is Collection Agent
84	VNDR_REGIST_ID	Character(20)	VARCHAR2(20) NOT NULL	Supplier Tax ID
85	VENDOR_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Vendor Category
86	WTHD_RULE_TMP	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
87	CONDITION_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Condition %
88	CONDITION_UNTIL	Date(10)	DATE	Condition Valid Until
89	HOLD_PAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Hold Pay Indicator D=Default from Entity Definition S=Specify at this Level
90	VJUR_HOLD_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Supplier Jur Hold Pay Flg
91	VJUR_REM_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Supplier Jur Remit supplier
92	VJUR_REM_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Supplier Jur Remit Supp Loc
93	VJUR_REM_ADDR_SEQ	Number(5,0)	INTEGER NOT NULL	Supplier Jur Remit address
94	REMIT_WTHD_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Remit Withhold to Flag E=Entity V=Supplier
95	WTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Withhold if missing N=Don't withholding Y=Withholdeable
96	APPL_VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Wthd Applicable Supplier Setid
97	APPL_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Wthd Applicable Supplier ID
98	APPL_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Wthd Applicable Supplier Loc
99	APPL_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Wthd applic Address Seq Num
100	CREATE_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Withholding Payment
101	HOLD_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment B=Hold wthd & regular payment N=Do Not Hold W=Hold Withholding only
102	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
103	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
104	APPL_ON_FIRST_PAY	Character(1)	VARCHAR2(1) NOT NULL	Applicable to First Payment
105	ADDTL_WTHD_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Additional Withhold Percent
106	BASE_MIN	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Minimum Basis Amount
107	WTHD_MIN	Signed Number(19,2)	DECIMAL(17,2) NOT NULL	Minimum Withhold Amount
108	WTHD_RULE_TMP2	Character(5)	VARCHAR2(5) NOT NULL	Withholding Rule
109	VNDR_JUR_EFFDT	Date(10)	DATE	Effective Date
110	BU_JUR_EFFDT	Date(10)	DATE	Effective Date
111	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099
112	WTHD_PAN_NUM	Character(15)	VARCHAR2(15) NOT NULL	PAN No.
113	EFT_PYMNT_FMT_CD	Character(3)	VARCHAR2(3) NOT NULL	Payment Format 00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer
114	DSCNT_ALWAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always take discount
115	LOC_BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bank SetID
116	LOC_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
117	LOC_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bank Account
118	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
119	PAY_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Setid
120	PAY_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Remit Supplier
121	PAY_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Supplier Location
122	PAY_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	The bank for the disbursing side of a settlement transaction.
123	PAY_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	The bank account for the disbursing side of a settlement transaction.
124	PAY_PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
125	PAY_PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method
126	PAY_PYMNT_HNDG_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
127	PAY_CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
128	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date
129	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code
130	PAY_CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Payments currency type
131	BU_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bu Bank Code
132	BU_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bu Bank account key
133	BU_PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Bu payment method
134	BU_PYMNT_HNDG_CD	Character(2)	VARCHAR2(2) NOT NULL	Bu payment handling code
135	BANK_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Bank Account Currency
136	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
137	PP_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Applied Prepaid Gross Amt
138	WTHD_CONT_REF	Character(15)	VARCHAR2(15) NOT NULL	Contract Reference
139	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
140	WTHD_CUMUL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Withhold Cumulative Flag
141	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.
142	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code
143	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle
144	WTHD_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Withholding P=Withhold at Payment V=Withhold at Voucher Posting
145	PAID_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is stored either as
146	PAID_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is store
147	BANK_SETID_RPLD	Character(5)	VARCHAR2(5) NOT NULL	This field is added by Stevne Li on 17th July, 2012 to store the replaced bank information when calculating withhold payment.
148	BANK_CD_RPLD	Character(5)	VARCHAR2(5) NOT NULL	This field is added by Stevne Li on 17th July, 2012 to store the replaced bank information when calculating withhold payment.
149	BANK_ACCT_KEY_RPLD	Character(4)	VARCHAR2(4) NOT NULL	This field is added by Stevne Li on 17th July, 2012 to store the replaced bank information when calculating withhold payment.