GRP_LVL_DFHI_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
3	GRP_AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of Control Group A=Assigned E=Entry Set Aside O=Open R=Ready for Review S=Supervisor Set Aside V=Verified
4	ACCOUNTING_DT_IND	Character(1)	VARCHAR2(1) NOT NULL	Accounting Date Indicator C=Use Current Date D=Business Unit Default P=Use Payment Date S=Use Specific Date
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
7	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: D
8	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
9	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_HDR
10	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
11	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.
12	VCHR_BALANCE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Voucher Balance Option D=Default from Higher Level K=Reject Unbalanced Vouchers R=Recycle Unbalanced Vouchers
13	DOC_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Type Flag D=Default from Higher Level S=Specify at This level
14	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
15	CHART_EDIT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Edit Option D=Default from Higher Level K=Reject w/ edit error N=No Edits R=Recycle S=Use suspense account W=Warning
16	COMBO_EDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Edit Combinations
17	DUP_INVOICE_IND	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Indicator D=Default from Higher Level S=Specify at this Level
18	DUP_INV_NUM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Invoice Number N=No Y=Yes
19	DUP_INV_DT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date N=No Y=Yes
20	DUP_INV_VENDOR_NUM	Character(1)	VARCHAR2(1) NOT NULL	Vendor ID N=No Y=Yes
21	DUP_INV_GROSS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Gross Amount N=No Y=Yes
22	DUP_INV_BUS_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Business Unit N=No Y=Yes
23	DUP_INV_COMB_CODE	Number(3,0)	SMALLINT NOT NULL	Dupl Invoice Combination Code
24	DUP_INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Severity K=Reject R=Recycle W=Warning
25	SHIP_LOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Ship To/End Location Flag D=Default from Higher Level S=Specify at this Level
26	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
27	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
28	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code
29	SALETX_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Tolerance Flag D=Default from Higher Level S=Specify at this Level
30	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
31	SALETX_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Tolerance Amount
32	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code
33	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type