BI_REQUEST_VW2 (SQL View)	Index Back
Billing Request

BI_REQUEST_VW2

(SQL View)

Billing Request

select a.BUSINESS_UNIT ,a.BI_REQ_NBR ,a.BILL_REQ_ID ,a.EMPLID ,a.BI_REQ_DT_TM ,a.INVOICE_START ,a.INVOICE_END ,a.DUE_DT ,a.DUE_DAYS ,a.INVOICE_DT ,a.OPRID ,a.BILL_ONE_EMPLID ,a.INVOICE_FORM_ID ,a.JETFILE_CRYSTAL ,a.GENERATE_PRINT ,a.STRM ,a.ALL_TERM_FLAG from PS_BI_REQUEST a where a.type_of_request = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW

2 BI_REQ_NBR Number(10,0) DECIMAL(10) NOT NULL Billing Request Nbr

3 BILL_REQ_ID Character(10) VARCHAR2(10) NOT NULL Bill Request ID
Prompt Table: BI_STD_REQ_TBL

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

5 BI_REQ_DT_TM DateTime(26) TIMESTAMP Billing Request Dt/Time

6 INVOICE_START Character(22) VARCHAR2(22) NOT NULL Invoice Start Nbr

7 INVOICE_END Character(22) VARCHAR2(22) NOT NULL Invoice Nbr End

8 DUE_DT Date(10) DATE Due Date

9 DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Days

10 INVOICE_DT Date(10) DATE NOT NULL Invoice Date
Default Value: %date

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID

12 BILL_ONE_EMPLID Character(1) VARCHAR2(1) NOT NULL Bill By Option
A=Bill All Not Yet Billed
C=Bill Per Contract(s)
E=Bill One Ext Org ID
N=Bill Range
Y=Bill One ID
Default Value: N

13 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID
Prompt Table: BI_IVC_LAYOUT

14 JETFILE_CRYSTAL Character(1) VARCHAR2(1) NOT NULL Jet or Crystal Format
C=Crystal Bill
J=Form Based Extract Bill
O=Other Bill (SQR)
X=XML Publisher
Default Value: J

15 GENERATE_PRINT Character(1) VARCHAR2(1) NOT NULL Generate and Print Invoices
B=Generate & Print Bill
G=Generate Invoice
P=Print Bill
Default Value: G

16 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_VAL_TBL

17 ALL_TERM_FLAG Character(1) VARCHAR2(1) NOT NULL Bill Term Flag Label
A=All Terms
O=One Term
R=Term Range
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW
2	BI_REQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Billing Request Nbr
3	BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Request ID Prompt Table: BI_STD_REQ_TBL
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
5	BI_REQ_DT_TM	DateTime(26)	TIMESTAMP	Billing Request Dt/Time
6	INVOICE_START	Character(22)	VARCHAR2(22) NOT NULL	Invoice Start Nbr
7	INVOICE_END	Character(22)	VARCHAR2(22) NOT NULL	Invoice Nbr End
8	DUE_DT	Date(10)	DATE	Due Date
9	DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Due Days
10	INVOICE_DT	Date(10)	DATE NOT NULL	Invoice Date Default Value: %date
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_CS.OPRID
12	BILL_ONE_EMPLID	Character(1)	VARCHAR2(1) NOT NULL	Bill By Option A=Bill All Not Yet Billed C=Bill Per Contract(s) E=Bill One Ext Org ID N=Bill Range Y=Bill One ID Default Value: N
13	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Layout ID Prompt Table: BI_IVC_LAYOUT
14	JETFILE_CRYSTAL	Character(1)	VARCHAR2(1) NOT NULL	Jet or Crystal Format C=Crystal Bill J=Form Based Extract Bill O=Other Bill (SQR) X=XML Publisher Default Value: J
15	GENERATE_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Generate and Print Invoices B=Generate & Print Bill G=Generate Invoice P=Print Bill Default Value: G
16	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_VAL_TBL
17	ALL_TERM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bill Term Flag Label A=All Terms O=One Term R=Term Range Y/N Table Edit Default Value: Y