PAYPLAN_RPT_REQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW
5	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %date
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_PYPLAN_VW
8	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer Prompt Table: CRSPD_VAL_VW
9	PAYMENT_PLAN	Character(15)	VARCHAR2(15) NOT NULL	Payment Plan Prompt Table: PAYPLAN_RPT_VW
10	PAYPLN_STAT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Plan Status Option A=Active B=Both P=Paid Default Value: B
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance