EM_BU_AP_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	VOUCHER_NUM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Voucher Numbering Y/N Table Edit Default Value: N
3	VCHR_NUM_LAST_USED	Number(8,0)	INTEGER NOT NULL	Last Voucher Number
4	GRP_AP_ID_LASTUSED	Number(10,0)	DECIMAL(10) NOT NULL	Group ID last assigned
5	GRP_AP_NUM_OPT	Character(1)	VARCHAR2(1) NOT NULL	Group Id Auto Numbering Option Y/N Table Edit Default Value: N
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
7	BU_PSGL_SW	Character(1)	VARCHAR2(1) NOT NULL	Using PS/GL Y/N Table Edit Default Value: N
8	POST_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Posting Option Y/N Table Edit Default Value: Y
9	POST_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	Post Date Indicator A=Use Accounting Date C=Use Current Date P=Post All Transactions S=Use Specific Date Default Value: C
10	POST_THRU_DT	Date(10)	DATE	Post Thru Date
11	COMBINE_PYMNT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Combine Pymnt Option Y/N Table Edit Default Value: N
12	DB_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
13	PO_NUM_LAST_USED	Number(10,0)	DECIMAL(10) NOT NULL	Last Encumbrance Number
14	PO_NUM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Purchase Orders Y/N Table Edit Default Value: N
15	REQ_NUM_LAST_USED	Number(10,0)	DECIMAL(10) NOT NULL	Last Pre Encumbrance Number
16	REQ_NUM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Requisitions Y/N Table Edit Default Value: N
17	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Prompt Table: DST_CNTRL_TBL
18	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
19	POST_UNAPPRV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Post Unapproved Vouchers Y/N Table Edit Default Value: Y
20	POST_UNMATCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Post Unmatched Vouchers Y/N Table Edit Default Value: Y
21	CNTRCT_REL_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Contract Release Date Option A=Any Date C=Current Date N=No Date P=Period End Dt S=Specific Dt Default Value: C
22	CONTRACT_REL_DT	Date(10)	DATE	Contract Release Date
23	REVALUE_OPTION	Character(4)	VARCHAR2(4) NOT NULL	Revaluation Posting Option BUS=Business Unit VCHR=Voucher VNDR=Supplier Default Value: VCHR
24	HOL_PROC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing level B=Specify Calendar at Bank level U=Specify Calendar Default Value: B
25	USE_BUS_DAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Business Day Y/N Table Edit Default Value: N
26	GO_NXT_PRV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Go Next or Prior Business Day N=Next Business Day P=Prior Business Day Default Value: P
27	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups. Prompt Table: BUS_CAL_HOL_DFN
28	HIDE_SUT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Hide Sales Use Tax Y/N Table Edit Default Value: N
29	HIDE_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Hide Value Added Tax Y/N Table Edit Default Value: N
30	VCHR_SUT_MSG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Sales and Use Tax Edit Message E=Error Message N=No Message W=Warning Message Default Value: W
31	VCHR_VAT_MSG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Value Added Tax Edit Message E=Error Message N=No Messages W=Warning Message Default Value: W
32	SBI_DOC_DFLT	Character(1)	VARCHAR2(1) NOT NULL	SBI Numbering Option D=Default from Higher Level G=Group Vouchers (Auto-Num) I=Individual Voucher (Auto-Num) P=Individual Vchr-Invoice Number Default Value: D
33	ERS_OPT_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Option D=Default from Higher Level N=No ERS Y=Allow ERS Default Value: D
34	ERS_INV_DT_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date D=Default from Higher Level F=Freight Terms R=Receipt Date Default Value: D
35	ERS_TAX_TYPE_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Sales Tax D=Default from Higher Level N=No Taxes U=Use Tax V=Value Added Tax Default Value: D
36	VCHR_MTCH_ADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Match Exception Adjustment Opt A=Automatic Generate N=None S=Stage Default Value: N
37	VCHR_TAX_ADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Voucher Tax Adjustment Option A=Automatic N=None P=Pending S=Stage to Pending File Default Value: N
38	TAX_ADJ_LIMIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Limit Option B=Both Over/Under N=Not Applicable O=Over U=Under Default Value: N
39	TAX_ADJ_DIFF_OPT	Character(1)	VARCHAR2(1) NOT NULL	SUT Difference Opt A=Accrue Difference N=Not Applicable S=Short Pay Default Value: N
40	RTV_VCHR_ADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Voucher Adjust Option A=Create Adjustment N=No adjustment S=Stage to Pending File Default Value: N
41	RTV_DEBIT_MEMO	Character(1)	VARCHAR2(1) NOT NULL	RTV Debit Memo Y/N Table Edit Default Value: N
42	ASSTN_ALG_NAME	Character(15)	VARCHAR2(15) NOT NULL	Document Association Prompt Table: AP_ASSTN_ALGHDR
43	VCHR_BLD_DEFN	Character(10)	VARCHAR2(10) NOT NULL	Voucher Build Criteria Prompt Table: VCHR_BLD_DEFN
44	RECEIPT_DELAY_DAYS	Number(3,0)	SMALLINT NOT NULL	Receipt Delay Days
45	MTCH_ADJ_DELAY_DAY	Number(3,0)	SMALLINT NOT NULL	Match Adjust Delay Days
46	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Acct Date C=Doc Date I=Inv Date R=Recpt Date S=Ship Date U=User Date Default Value: I
47	CUR_EXC_DT_SRC_DFT	Character(1)	VARCHAR2(1) NOT NULL	Cur Exc Dt Src Default A=Accounting Dt D=Default I=Invoice Dt Default Value: D
48	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_VW
49	COPYTO_GROSS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Copy Gross Amount to Voucher Y/N Table Edit Default Value: Y
50	EARLY_PY_RSN_CD	Character(4)	VARCHAR2(4) NOT NULL	Early Payment Reason Code Prompt Table: XPYM_RSN_SY_VW
51	TSYMBOL_ATTRIB	Character(16)	VARCHAR2(16) NOT NULL	Treasury Symbol Attribute
52	LATE_PY_RSN_CD	Character(4)	VARCHAR2(4) NOT NULL	Late Payment Reason Code Prompt Table: XPYM_RSN_SY_VW
53	LATE_CHRG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Late Charge Option C=Compute Charges N=Not Applicable Default Value: N
54	LATE_CHRG_CD	Character(4)	VARCHAR2(4) NOT NULL	Late Charge Code Prompt Table: LATE_CHRG_VW
55	APPL_CREDIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Allow Auto Credit Application A=Allow Auto Credit Application N=No Auto Credit Application Default Value: N
56	REAL_TIME_POST	Character(1)	VARCHAR2(1) NOT NULL	Allow Real-Time Posting Y/N Table Edit Default Value: N
57	POST_TO_GL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Automatically Post to Ledger Y/N Table Edit Default Value: N
58	POST_PREPAID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prepayment Application Y/N Table Edit Default Value: N
59	GFEE_RUN_EEG	Character(1)	VARCHAR2(1) NOT NULL	Checkbox to determine whether to run Entry Event during a batch process. Y/N Table Edit
60	PROCESS_LINES_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process order lines online Y/N Table Edit Default Value: N