VOUCHER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style A=Adjustment ADJ=Adjustments ERS=ERS Voucher J=Journal JRNL=Journal Voucher P=Purchase Order PPAY=Prepaid Voucher R=Regular REG=Regular Voucher THRD=Third Party Voucher TMPL=Template Voucher
4	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
5	ERS_INV_SEQ	Number(3,0)	SMALLINT NOT NULL	ERS Invoice Sequence
6	INVOICE_DT	Date(10)	DATE	Invoice Date
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor Set ID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	ADDRESS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
11	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
12	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	VCHR_TTL_LINES	Number(5,0)	INTEGER NOT NULL	Lines Entered
15	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open Default Value: O
16	ENTRY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Entry Status C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Loaded by Batch VoucherModule O=Open P=Postable R=Recycle S=Schedule for Payment X=Deleted Default Value: O
17	ACCOUNTING_DT	Date(10)	DATE	Accounting Date
18	POST_VOUCHER	Character(1)	VARCHAR2(1) NOT NULL	Post Voucher Now D=Post Later N=Do Not Post P=Post Immediately Default Value: D
19	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
20	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
21	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
22	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	N=No P=Processed Y=Yes Default Value: N
23	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
24	DUP_INVOICE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Status Y/N Table Edit Default Value: N
25	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
26	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
27	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
28	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
29	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.
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency
33	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
34	DSCNT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Amount
35	DSCNT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Discount
36	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
37	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use tax amount.
38	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base use tax amount.
39	USETAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Use tax code.
40	USETAX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate use tax.
41	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
42	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
43	SALETX_CD	Character(8)	VARCHAR2(8) NOT NULL	Sales Tax Code
44	SALETX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Sales Tax
45	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT invoice amount.
46	VAT_INV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT invoice amount base.
47	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non invoice amount.
48	VAT_NONINV_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non invoice amount base.
49	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
50	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
51	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
52	MISC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
53	FRGHT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Freight Charges
54	DUE_DT	Date(10)	DATE	Expected Birth Date
55	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
56	PYMNT_CNT_MAX	Number(5,0)	INTEGER NOT NULL	Maximum payment count. Default Value: 1
57	PYMNT_CNT_TOTAL	Number(5,0)	INTEGER NOT NULL	Total payment count. Default Value: 1
58	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Payment Terms ID
59	ENTERED_DT	Date(10)	DATE	Entered on
60	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
61	TIME_EDIT	Time(15)	TIMESTAMP	Cumulative Edit Time
62	VCHR_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
63	VCHR_TMPLTE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
64	WTHD_ADJUST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Withholding adjustments. Y/N Table Edit Default Value: N
65	WTHD_FISCAL_YR	Character(4)	VARCHAR2(4) NOT NULL	Withholding Year
66	POST_STATUS_WTHD	Character(1)	VARCHAR2(1) NOT NULL	Withholding Post Status N=Not Postable P=Posted U=Unposted Default Value: U
67	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Y/N Table Edit Default Value: N
68	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT basis amount.
69	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT basis amount in base current.
70	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT calculated amount.
71	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT amount.
72	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT recovery amount.
73	VAT_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT recovery amount base.
74	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action E=ERS Match N=No Matching Y=Standard Match Default Value: N
75	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status E=Match Exceptions Exist I=Match in Progress M=Matched N=Not Applicable O=Manually Overridden R=Rejected T=To be Matched Default Value: N
76	BCM_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check N=Not Budget Checked V=Valid Budget Check Default Value: N
77	BCM_TRAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Transaction Type AR=Accounts Receivable Item EN=Encumbrance EX=Expended JU=Journal Unpost JV=Journal Voucher PM=AR Payment (Reference Item) PN=AR Payment (No Reference Item) PO=Purchase Order PR=Pre Encumbrance RQ=Requisition Default Value: EX
78	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt
79	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
80	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process Y/N Table Edit Default Value: N
81	MANUAL_CLOSE_DT	Date(10)	DATE	Manual Close Date
82	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Contract ID
83	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location
84	CUR_RT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Exchange Rate Source T=Use Exchange Rate Tables U=User Specified Default Value: T
85	DSCNT_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Discount Amount Control T=Controlled by Payment Terms U=User Specified Default Value: T
86	DUE_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Due Date Control T=Controlled by Terms U=User Specified Default Value: T
87	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Specify at this Level Default Value: P
88	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
89	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set
90	APPR_CHECK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approval Check Flag Y/N Table Edit Default Value: N
91	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending Default Value: P
92	APPR_INSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Unique number for each runtime occurrence of a virtual approver process
93	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
94	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	VAT declaration point. D=Delivery I=At Invoice Time P=At Payment Time
95	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT calculation type. E=Exclusive I=Inclusive N=Not Applicable
96	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	VAT reporting entity.
97	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type
98	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	VAT code.
99	VAT_RCRD_INPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT record input. Y/N Table Edit Default Value: N
100	VAT_RCRD_OUTPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT record output. Y/N Table Edit Default Value: N
101	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT recovery percent.
102	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	VAT calculate at gross or net. G=Calculate at Gross N=Calculate at Net
103	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT recalculation at payment.
104	VAT_CALC_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT include freight.
105	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate non recoverable VAT.
106	VAT_NRCVR_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non recoverable amount.
107	VAT_NRCVR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non recoverable amount.
108	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT calculated amount base current.
109	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
110	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
111	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
112	VAT_RGSTRN_SELLER	Character(12)	VARCHAR2(12) NOT NULL	Seller's VAT registration.
113	MISC_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Miscellaneous Charge Y/N Table Edit Default Value: N
114	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Seller's VAT Rgstrn Country
115	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Buyer's VAT Rgstrn Country
116	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Ship to Country
117	COUNTRY_VAT_RPTG	Character(3)	VARCHAR2(3) NOT NULL	VAT Reporting Country
118	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT document id.
119	VAT_DCMNT_LN_MAX	Number(5,0)	INTEGER NOT NULL	VAT document maximum line count.
120	SALETX_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Calculated Sales Tax Amount
121	SALETX_CLC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Calculated Sales Tax Base Amt
122	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Document Type L=Letter N=Notice O=Other Q=Request R=Report
123	DOC_SEQ_DATE	Date(10)	DATE	Document Sequence Date
124	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Document Sequence Number
125	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Document Sequencing Status A=GL BU Undefined B=GL BU Blank C=Accounting Date Blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number
126	VOUCHER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Voucher Type A=Adjustment Voucher B=Batch Edit Voucher C=Recurring Voucher E=ERS Voucher J=Journal Voucher P=Prepaid Voucher R=Regular Voucher T=Third Party Voucher V=VAT Register Voucher X=Template Voucher
127	VNDR_TMPLTE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Template Flag
128	VAT_TREATMENT_PUR	Character(3)	VARCHAR2(3) NOT NULL	VAT Treatment Pur DOM=Domestic VAT EUA=Intra-EU Acquisitiom IMP=Import OOS=Outside the Scope of VAT
129	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT exception type. N=None S=Suspended X=Exonerated
130	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	VAT certification id.
131	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Ship From Country
132	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
133	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT rebate amount.
134	VAT_REBATE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT rebate amount base.
135	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag
136	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Letter of Credit ID
137	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Revalue Flag
138	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check N=Not Budget Checked V=Valid Budget Check Default Value: V
139	BUDGET_MISC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status V=Valid Default Value: V
140	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Override Transaction
141	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Override Oper
142	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Override Date
143	PREPAID_REF	Character(10)	VARCHAR2(10) NOT NULL	Prepayment Reference
144	PREPAID_AUTO_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Automatically Apply Prepayment Y/N Table Edit Default Value: Y
145	SBI_DOC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Self Billing Invoice Options G=Group Vouchers by Vendor I=Individual SBI P=Packing Slip Default Value: G
146	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
147	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match Y/N Table Edit Default Value: N
148	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
149	ERS_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Buyers Sales Tax G=GST N=None U=Use Tax V=Value Added Tax
150	ERS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ERS Type N=Not Applicable P=PO Receipt R=Non PO Receipt
151	INV_RECPT_DT	Date(10)	DATE	Invoice Receipt Date
152	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
153	RECEIPT_DT	Date(10)	DATE	Received Date
154	SHIP_DATE	Date(10)	DATE	Item Shipping Date
155	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Accounting Date C=Constructive Doc Receipt Date I=Invoice Date R=Receipt Date S=Ship Date U=User Specified Date
156	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
157	UNMTCH_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pay Unmatched Voucher Y/N Table Edit Default Value: N
158	UNMTCH_PAY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Unmatched Pay Status N=Not Applicable P=Paid U=Unpaid Default Value: N
159	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source CNTR=Contracts CONS=Consigned Inventory EDI=EDI MADJ=Match Adjustment NERS=Non PO Evaluated Receipt ONL=On Line PAYR=Payroll Interface PERS=PO Evaluated Receipts QUCK=Quick Invoice RTV=Return To Vendor TADJ=Tax Adjustment
160	VCHR_SYSGEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Generated Y/N Table Edit Default Value: N
161	MEMO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Memo Amount
162	MEMO_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Memo Amt Base
163	PAY_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	An indicator used in Benefits Billing to identify amounts that have been, or are to be, paid (as opposed to a charge).
164	PAY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment amount - base current.
165	SBI_FLG	Character(1)	VARCHAR2(1) NOT NULL	SBI Applicable Y/N Table Edit Default Value: N
166	SBI_IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	SBI In Process Y/N Table Edit Default Value: N
167	SBI_NUM	Character(40)	VARCHAR2(40) NOT NULL	Self-Billed Invoice ID Number
168	SBI_PROCESS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
169	DELETE_DT	Date(10)	DATE	Deletion Date
170	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency
171	VAT_RPTG_CURR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amounts for reporting currency.
172	VAT_OVR_RPTG_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT reporting amount overridden.
173	RATE_MULT_VAT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
174	RATE_DIV_VAT	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
175	VAT_INV_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT amount in reporting currency.
176	VAT_TRANS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT transaction amount reporting.
177	VAT_DCLRTN_DT	Date(10)	DATE	VAT declaration date.
178	VAT_DCLRTN_DT_SRC	Character(1)	VARCHAR2(1) NOT NULL	VAT declaration date source. A=Delivery Date - Ext Process D=Delivery Date - Txn Entry I=Invoice Date M=Manual Entry N=Not Applicable
179	VAT_CALC_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT include miscellaneous.
180	LC_EXTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Landed Cost Extract Status Default Value: N
181	EIN_FEDERAL	Character(9)	VARCHAR2(9) NOT NULL	EIN Federal
182	EIN_STATE_LOCAL	Character(20)	VARCHAR2(20) NOT NULL	EIN State Local
183	TAX_PYMNT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Tax payment type.
184	TAX_GRP	Character(4)	VARCHAR2(4) NOT NULL	Tax group.
185	VAT_ADVPAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT on advance payments.
186	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
187	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT transaction amount.
188	VAT_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT transaction amount base currency.
189	WTHD_PREPAY_OPT	Character(1)	VARCHAR2(1) NOT NULL	Signifies if Withholding applies to the prepayment N=Not Applicable V=Postpone to regular voucher
190	VAT_CF_ANLSYS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Chartfield Analysis
191	VAT_NRCVR_CHRG_CD	Character(10)	VARCHAR2(10) NOT NULL	Prorate VAT Non-Recovery
192	VAT_RPTG_CURR_CTRL	Character(1)	VARCHAR2(1) NOT NULL	VAT Reporting Currency Control E=Exchange Rate N=None T=VAT Transaction Amount V=VAT Invoiced Amount
193	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description