AP_VCHR_CDWN_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AP_TMPLT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Voucher Entry Template Type A=All C=Permission O=User ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
3	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class Prompt Table: OPRCLASS_VW
4	COPY_DOWN_ID	Character(10)	VARCHAR2(10) NOT NULL	Copy Down ID
5	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
6	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Y/N Table Edit Default Value: Y
7	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Y/N Table Edit Default Value: Y
8	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity Y/N Table Edit Default Value: Y
9	UNIT_PRICE_SW	Character(1)	VARCHAR2(1) NOT NULL	Unit Price for the Voucher Entry Template Y/N Table Edit Default Value: Y
10	QTY_VCHR_SW	Character(1)	VARCHAR2(1) NOT NULL	Qty Vchr at Voucher Line Level for the Voucher Entry Template Y/N Table Edit Default Value: Y
11	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Y/N Table Edit Default Value: Y
12	MERCHANDISE_AMT_SW	Character(1)	VARCHAR2(1) NOT NULL	Merchandise Amt at Voucher Line Level for the Voucher Entry Template Y/N Table Edit Default Value: Y
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Y/N Table Edit Default Value: Y
14	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number Y/N Table Edit Default Value: Y
15	SPEEDCHART_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedChart Key Y/N Table Edit Default Value: Y
16	ACCOUNT_CODE	Character(20)	VARCHAR2(20) NOT NULL	Accounting Tag Y/N Table Edit Default Value: Y
17	MERCHANDISE_AMT_DL	Character(1)	VARCHAR2(1) NOT NULL	Merchandise Amt at Distribution Line Level for the Voucher Entry Template Y/N Table Edit Default Value: Y
18	QTY_VCHR_DL	Character(1)	VARCHAR2(1) NOT NULL	Qty Vchr at Voucher Distribution Level for the Voucher Entry Template Y/N Table Edit Default Value: Y
19	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Y/N Table Edit Default Value: Y
20	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Y/N Table Edit Default Value: Y
21	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Y/N Table Edit Default Value: Y
22	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key Y/N Table Edit Default Value: Y
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Y/N Table Edit Default Value: Y
24	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Y/N Table Edit Default Value: Y
25	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Y/N Table Edit Default Value: Y
26	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Y/N Table Edit Default Value: Y
27	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Y/N Table Edit Default Value: Y
28	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Y/N Table Edit Default Value: Y
29	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Y/N Table Edit Default Value: Y
30	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Y/N Table Edit Default Value: Y
31	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Y/N Table Edit Default Value: Y
32	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Y/N Table Edit Default Value: Y
33	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Y/N Table Edit Default Value: Y
34	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Y/N Table Edit Default Value: Y
35	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Y/N Table Edit Default Value: Y
36	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Y/N Table Edit Default Value: Y
37	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Y/N Table Edit Default Value: Y
38	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Y/N Table Edit Default Value: Y
39	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Y/N Table Edit Default Value: Y
40	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Y/N Table Edit Default Value: Y
41	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Y/N Table Edit Default Value: Y
42	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event Y/N Table Edit Default Value: Y
43	BUDGET_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	Show Budget Date Y/N Table Edit Default Value: Y
44	VISUAL_RATE_CUR_SW	Character(1)	VARCHAR2(1) NOT NULL	AP Exchange Rate Copy Down Y/N Table Edit Default Value: Y
45	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Y/N Table Edit Default Value: Y
46	STATISTIC_AMT_SW	Character(1)	VARCHAR2(1) NOT NULL	Show Statistic Amount Y/N Table Edit Default Value: Y
47	VAT_SW	Character(1)	VARCHAR2(1) NOT NULL	Display VAT Flag H=Hide VAT checkbox N=Display VAT checkbox off Y=Display VAT checkbox on Y/N Table Edit Default Value: Y
48	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: Y
49	SALES_TAX_SW	Character(1)	VARCHAR2(1) NOT NULL	AP Sales Tax Copy Down Y/N Table Edit Default Value: Y
50	ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	AP Asset Copy Down Y/N Table Edit Default Value: Y
51	AMORTIZATION_SW	Character(1)	VARCHAR2(1) NOT NULL	Amortization Y/N Table Edit
52	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=Not Selected Y=Seleted Y/N Table Edit Default Value: N