BILL_HEADER_VW

(SQL View)
 Index Back

Billing Invoice Header View


SELECT A.BUSINESS_UNIT , A.INVOICE_ID , A.EMPLID , A.EXT_ORG_ID , A.ADDRESS_TYPE , A.BILL_TYPE_ID , A.PRIOR_INVOICE_ID , A.INVOICE_TYPE , A.BILL_REQ_ID , A.BI_REQ_NBR , A.BILL_DATE_TIME , A.DUE_DT , A.OPRID , A.TOTAL_BILL , A.SF_BILL_STATUS , A.NAME ,%subrec(ADDRESS_SBR,A) , A.ACAD_CAREER , A.ACAD_PROG_PRIMARY , A.ACAD_LEVEL_PROJ , A.ACAD_PLAN , A.TUITION_RES , A.PRT_BILL_FLAG , A.RE_PRT_BILL_FLAG , A.PRT_DTTM_STAMP , A.RE_PRT_DTTM_STAMP , A.INVOICE_DT , A.PRIOR_IVC_BALANCE ,G.SETID ,' ' ,A.BI_SCAN_LINE ,A.CONTACT_NAME FROM PS_BI_BILL_HEADER A , PS_SETID_TBL G WHERE g.setid = ( SELECT Z.SETID FROM PS_SET_CNTRL_REC Z WHERE z.setcntrlvalue = a.business_unit AND z.recname = 'BI_BILL_MSG_TBL' )

# 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 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

Prompt Table: BI_BILL_HEADER

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
5 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: HCR_ADDR_TYP_I

6 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type ID
PP=Payment Plan
PRE=Pre-Payment
STU=Student
TP=Third Party
7 PRIOR_INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Prior Invoice ID
8 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Invoice
ADJ=Adjustment Only Bill
ARB=Rebill Bill
RAD=Regular bill with adjustments
REG=Regular Bill

Default Value: REG

9 BILL_REQ_ID Character(10) VARCHAR2(10) NOT NULL Bill Request ID
10 BI_REQ_NBR Number(10,0) DECIMAL(10) NOT NULL Billing Request Nbr
11 BILL_DATE_TIME DateTime(26) TIMESTAMP NOT NULL Bill Date and Time

Default Value: %date

12 DUE_DT Date(10) DATE NOT NULL Due Date

Default Value: %date

13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_CS.OPRID

Prompt Table: OPR_DEF_TBL_CS

14 TOTAL_BILL Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Billed
15 SF_BILL_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
C=Cancelled
I=Initiated
16 NAME Character(50) VARCHAR2(50) NOT NULL Name
17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
22 CITY Character(30) VARCHAR2(30) NOT NULL City
23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
24 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
29 COUNTY Character(30) VARCHAR2(30) NOT NULL County
30 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

34 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
35 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
36 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
37 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
38 TUITION_RES Character(5) VARCHAR2(5) NOT NULL Tuition Residency
39 PRT_BILL_FLAG Character(1) VARCHAR2(1) NOT NULL Print Bill Flag

Y/N Table Edit

Default Value: N

40 RE_PRT_BILL_FLAG Character(1) VARCHAR2(1) NOT NULL RePrint Bill Flag

Y/N Table Edit

Default Value: N

41 PRT_DTTM_STAMP DateTime(26) TIMESTAMP Print Date/Time Stamp
42 RE_PRT_DTTM_STAMP DateTime(26) TIMESTAMP RePrint Date/Time Stamp
43 INVOICE_DT Date(10) DATE Invoice Date
44 PRIOR_IVC_BALANCE Signed Number(17,2) DECIMAL(15,2) NOT NULL Prior Invoice Amount
45 SETID Character(5) VARCHAR2(5) NOT NULL SetID
46 STRM Character(4) VARCHAR2(4) NOT NULL Term
47 BI_SCAN_LINE Character(60) VARCHAR2(60) NOT NULL Bill Scan Line
48 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name