RUN_BI_PRNTIVC

#	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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
4	INVOICE_RANGE_OPT	Character(3)	VARCHAR2(3) NOT NULL	Invoice Range Option ALI=All Invoiced Bills ALL=All CUS=Cust ID CYC=Bill Cycle DT=Date Bill Added DTI=Date GRP=Copy Group ID INV=Invoice ID MUL=Multi-Select Table PVN=Public Voucher Number RGP=Reprint Group SEL=Range ID SHP=Ship ID SRC=Bill Source TYP=Bill Type Default Value: INV
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_BI_NONVW
6	TO_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field Prompt Table: SP_BU_BI_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: BI_BILL_TO_VW
8	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier Prompt Table: BI_CYCLE_VW
9	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source Prompt Table: BI_SRC_EF_VW
10	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier Prompt Table: BI_TYPE_EF_VW
11	RANGE_SELECTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Range Selection ID Prompt Table: BI_RNG_LKUP_DVW
12	START_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Starting Invoice Number Prompt Table: BI_INV_LKUP_DVW
13	END_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Ending Invoice Number Default Value: RUN_BI_PRNTIVC.START_INVOICE Prompt Table: BI_INV_LKUP_DVW
14	STARTING_DT	Date(10)	DATE	Bills Added On or After
15	DTTM_FROM	DateTime(26)	TIMESTAMP	From Date/Time
16	INVOICE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date Option P=Processing Date U=User Defined Default Value: P
17	INVOICE_DT	Date(10)	DATE	Invoice Date Default Value: %DATE
18	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma Default Value: P
19	PRT_ONLY_UNPRINTED	Character(1)	VARCHAR2(1) NOT NULL	Print Only Unprinted Invoices Y/N Table Edit Default Value: Y
20	PRINT_IND	Character(1)	VARCHAR2(1) NOT NULL	Print Copy Y/N Table Edit Default Value: N
21	PRT_ONLY_PRIMARY	Character(1)	VARCHAR2(1) NOT NULL	Print Only Primary Copy Y/N Table Edit Default Value: N
22	PRT_CUST_LABEL	Character(1)	VARCHAR2(1) NOT NULL	Print with Customer Label Y/N Table Edit Default Value: N
23	DIST_ORIGINAL_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Distribute Original Only Y/N Table Edit Default Value: N
24	CUSTOM_LABEL	Character(20)	VARCHAR2(20) NOT NULL	Custom Label
25	PRT_INVOICE_SORT	Character(1)	VARCHAR2(1) NOT NULL	Print Invoice Sort By B=Bus Unit, Invoice C=Customer, Invoice P=Country, Postal Default Value: P
26	USE_CURRENT_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Use Current Effective Address Y/N Table Edit Default Value: N
27	EDI_OPTION	Character(1)	VARCHAR2(1) NOT NULL	EDI Invoice Options 1=EDI Only 2=EDI and Print 3=Print Only Default Value: 1
28	CONSOLIDATE	Character(1)	VARCHAR2(1) NOT NULL	Consolidate Headers Y/N Table Edit
29	POST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled. A=Do Not Post B=Balance Only Now D=Delete This Group Now E=Delete ALL Accounting Entries G=Generate GL Distribution I=Balance and Post Later L=Batch Standard N=Batch Priority V=View Default Value: A
30	REPORT_CURR	Character(1)	VARCHAR2(1) NOT NULL	Currency Shown on Report B=Base Currency T=Transaction Currency Default Value: T
31	ADD_DT	Date(10)	DATE	Customer Added On Default Value: %DATE
32	SUPPRESS_SUMM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used to suppress the printing of Summary details on an Invoice that has been sent via Email to an Email ID from the Self Service Transactions. Y/N Table Edit Default Value: N
33	INCL_ATTACHED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Attached Bills Y/N Table Edit Default Value: N
34	FROM_DUE_DT	Date(10)	DATE	From Due Date
35	TO_DUE_DT	Date(10)	DATE	To Due Date
36	REPRINT_GROUP_ID	Character(30)	VARCHAR2(30) NOT NULL	Reprint Group ID
37	INVOICE_DT_FROM	Date(10)	DATE	Invoice Date From
38	INVOICE_DT_TO	Date(10)	DATE	Through
39	INCL_OPEN_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Include Open Items Only Y/N Table Edit Default Value: N
40	EMAIL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Email Notification Options 1=Email Only 2=Email & Print 3=Print Only Default Value: 1
41	SUM_IVC_PRINT_OPT	Character(4)	VARCHAR2(4) NOT NULL	Summarized Invoice Print Option BOTH=Print Both Summarized & Detail DETL=Print Detail SUM=Print Summarized Default Value: DETL
42	START_PVN	Number(6,0)	INTEGER NOT NULL	Starting Public Voucher Number
43	END_PVN	Number(6,0)	INTEGER NOT NULL	Ending Public Voucher Number
44	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_HDR_ACT_VW
45	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
46	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BUPCSE_NONVW
47	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PC_BUPC_PROJ
48	FED_FILE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Federal Highway File Options 1=File Only 2=File and Print Default Value: 1
49	EMAIL_IVC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Email Invoice Options 1=Email Only 2=Email & Print 3=Print Only Default Value: 1
50	EIVC_FILE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Electronic Invoice File Options 1=Xml Only 2=Xml and Print 3=Print Only Default Value: 1