WM_CINQ_CHRG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEARCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Search ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW
4	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification Prompt Table: WM_CINQ_SHOP_VW
5	DATE_FROM	Date(10)	DATE	Date From
6	DATE_TO	Date(10)	DATE	Date To
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
8	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: WM_CINQ_BUPC_VW
9	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: WM_CINQ_PROJ_VW
10	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_ALL_VW Set Control Field: BUSINESS_UNIT_GL
11	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_CUR_VW Set Control Field: BUSINESS_UNIT_GL
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
13	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID Prompt Table: PSOPRDEFN
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
16	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
17	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
18	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
19	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
20	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
21	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
22	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
23	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
24	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
25	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
26	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW