RUN_BI_FFEXT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_BI_NONVW
5	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUST_BI_A2_VW
6	BILL_STATUS_OPTNS	Character(1)	VARCHAR2(1) NOT NULL	Billing status options
7	DATE_BATCH	Character(8)	VARCHAR2(8) NOT NULL	Date represented in string format as MMDDYYYY used on batch files.
8	BATCH_DATE	Date(10)	DATE	Batch Date
9	BATCH_DATE_X	Character(10)	VARCHAR2(10) NOT NULL	Batch Date
10	TGT_PYMT_DATE_X	Character(10)	VARCHAR2(10) NOT NULL	Target Payment Date
11	FEDERAL_HWY_PARMS	Character(1)	VARCHAR2(1) NOT NULL	Federal Highway Parameters
12	FINAL_RUN_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates the final run of the federal highway extract file creation. Y/N Table Edit
13	FNL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Finalized should be included on the federal highway extract file. Y/N Table Edit
14	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit
15	INV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Invoiced should be included on the federal highway extract file. Y/N Table Edit
16	NEW_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of New should be included on the federal highway extract file. Y/N Table Edit
17	PEND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Pending should be included on the federal highway extract file. Y/N Table Edit
18	READY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Ready should be included on the federal highway extract file. Y/N Table Edit
19	RECREATE_FILE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether the federal highway extract file is to be recreated. Y/N Table Edit
20	SELECTION_GRP_LBL	Character(1)	VARCHAR2(1) NOT NULL	Run Parameters
21	TARGET_PYMT_DT	Date(10)	DATE	The Target Payment Date on the final run of the Federal Highway Extract File process for an invoice. Default Value: %Date
22	TARGET_PYMT_DT_FNL	Date(10)	DATE	The Finalized Target Payment Date Prompt Table: BI_FHWA_PYDT_VW
23	TMP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Temporary should be included on the federal highway extract file. Y/N Table Edit
24	TMR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether billing status of Temporary Ready should be included on the federal highway extract file. Y/N Table Edit