SSF_INVH_OUT_VW

(SQL View)
 Index Back

View used to print invoices

View to print invoices used by XMLPublisher AE Program.

SELECT A.PROCESS_INSTANCE ,A.BUSINESS_UNIT ,A.INVOICE_ID ,A.SSF_PCOMM_TYPE ,A.SSF_PCOMM_DESTID ,A.COMMON_ID ,A.SA_ID_TYPE ,A.INVOICE_DT ,A.BILL_REQ_ID ,A.BI_REQ_NBR ,A.INVOICE_FORM_ID ,A.REPORT_DEFN_ID ,A.TMPLDEFN_ID ,A.COUNTRY ,A.ADDRESS1 ,A.ADDRESS2 ,A.ADDRESS3 ,A.ADDRESS4 ,A.CITY ,A.NUM1 ,A.NUM2 ,A.HOUSE_TYPE ,A.ADDR_FIELD1 ,A.ADDR_FIELD2 ,A.ADDR_FIELD3 ,A.COUNTY ,A.STATE ,A.POSTAL ,A.GEO_CODE ,A.IN_CITY_LIMIT ,A.LOCATION ,A.LOCATION_DESCR ,A.INCLUDE_AA_TOTAL ,A.AA_DETAIL ,A.TERM_SUMMARY ,A.TRANS_SORT_1 ,A.TRANS_SORT_2 ,A.TRANS_SORT_3 ,A.TRANS_SORT_4 ,A.SUB_TOTAL_BY_1 ,A.SUMM_FIELD_1 ,A.SSF_SUMFLD1_DESCR ,A.SUMM_FIELD_2 ,A.SSF_SUMFLD2_DESCR ,A.BILL_SORT_1 ,A.BILL_SORT_2 ,A.BILL_SORT_3 ,A.BILL_SORT_4 ,A.SSF_EXTR_BNK_INFO ,A.SSF_TPC_STDCHG_DEF ,A.STDNT_ENRL_BLOCK ,A.NAME ,A.TOTAL_BILL ,A.ACAD_LEVEL_PROJ ,A.CAMPUS ,A.TUITION_RES ,A.ACADEMIC_LOAD ,A.SSF_ZIP_SRCH ,A.SSF_COUNTRY_SRCH ,A.PRT_CLASS_SCHEDULE ,A.PRT_TERM_SCHEDULE ,A.PRINT_ZERO_BILL ,A.LANG_CD ,A.EMPLID ,A.SSF_NAME_COMM ,A.COUNTRY_OTHER ,A.ADDRESS1_OTHER ,A.ADDRESS2_OTHER ,A.ADDRESS3_OTHER ,A.ADDRESS4_OTHER ,A.CITY_OTHER ,A.COUNTY_OTHER ,A.STATE_OTHER ,A.POSTAL_OTHER ,A.NUM1_OTHER ,A.NUM2_OTHER ,A.HOUSE_TYPE_OTHER ,A.ADDR_FIELD1_OTHER ,A.ADDR_FIELD2_OTHER ,A.ADDR_FIELD3_OTHER ,A.IN_CITY_LMT_OTHER ,A.GEO_CODE_OTHER ,A.EMPLID_RELATED ,B.ACAD_CAREER ,B.SSF_CAR_DESCRSHORT ,B.ACAD_PROG_PRIMARY ,B.SSF_PROG_DESCRSH ,B.ACAD_PLAN ,B.SSF_PLAN_DESCRSH ,B.ACAD_PROG ,B.BI_SCAN_LINE ,B.DUE_DT ,B.EXT_ORG_ID ,B.INVOICE_TYPE ,B.OPRID ,B.PRIOR_INVOICE_ID ,B.PRIOR_IVC_BALANCE ,B.PRT_BILL_FLAG ,B.PRT_DTTM_STAMP ,B.RE_PRT_BILL_FLAG ,B.RE_PRT_DTTM_STAMP ,B.SF_BILL_STATUS ,B.SSF_CR_INV_IND ,B.SSF_PREC_TYPE ,B.SSF_RELINV_AMT ,B.SSF_UPDATED_ADDR ,B.TYPE_OF_REQUEST ,C.BASE_CURRENCY ,B.BI_PRIOR_INV_CALC ,B.INVOICE_FLAG FROM PS_SSF_INX_TMP A , PS_SSF_INXH_TMP B , PS_BUS_UNIT_TBL_SF C WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE_ID = B.INVOICE_ID AND B.SSF_PREC_TYPE = 'H' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
4 SSF_PCOMM_TYPE Character(1) VARCHAR2(1) NOT NULL Print Comm Destination
O=Original Communication
X=Extra Communication
5 SSF_PCOMM_DESTID Number(2,0) SMALLINT NOT NULL Print Comm Dest ID
6 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
7 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
8 INVOICE_DT Date(10) DATE Invoice Date
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

Prompt Table: BI_REQUEST

11 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Layout ID
12 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
13 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

Prompt Table: PSXPRPTTMPL_VW

14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

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

Prompt Table: STATE_TBL

28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

31 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

32 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
33 INCLUDE_AA_TOTAL Character(1) VARCHAR2(1) NOT NULL Include Anticipated Aid Total

Y/N Table Edit

Default Value: N

34 AA_DETAIL Character(1) VARCHAR2(1) NOT NULL Anticipated Aid Detail

Y/N Table Edit

Default Value: N

35 TERM_SUMMARY Character(1) VARCHAR2(1) NOT NULL Term Summary
A=All Terms
B=Current and Future Terms
C=Current Term Only
F=Future Only

Default Value: A

36 TRANS_SORT_1 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 1
A=Due Date
B=Item Number All
C=Item Description
E=Transaction Date
G=Amount
J=Account Number
K=Term
L=Session
M=Academic Year
P=Student ID (Third Party)
Q=Student Name (Third Party)
37 TRANS_SORT_2 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 2

Prompt Table: BI_SORT_TRAN_VW

38 TRANS_SORT_3 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 3

Prompt Table: BI_SORT_TRAN_VW

39 TRANS_SORT_4 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 4

Prompt Table: BI_SORT_TRAN_VW

40 SUB_TOTAL_BY_1 Character(1) VARCHAR2(1) NOT NULL Subtotal By

Y/N Table Edit

Default Value: N

41 SUMM_FIELD_1 Character(1) VARCHAR2(1) NOT NULL Summarization Field 1
A=Item Number All
B=Item Description
C=Item Type
D=Account Number
E=Item Nbr - Refund/Payment Only
F=Item Type Code
G=Student ID (Third Party)
H=Student Name (Third Party)
42 SSF_SUMFLD1_DESCR Character(30) VARCHAR2(30) NOT NULL Summary Field 1 Descr
43 SUMM_FIELD_2 Character(1) VARCHAR2(1) NOT NULL Summarization Field 2

Prompt Table: BI_SUMM_FLD_VW

44 SSF_SUMFLD2_DESCR Character(30) VARCHAR2(30) NOT NULL Summary Field 2 Descr
45 BILL_SORT_1 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 1
A=Name
B=Zip Code
C=Total Amount Due
D=Academic Program
E=Academic Level
F=Invoice Number
G=Campus
H=Tuition Residency
I=Academic Load
J=Student ID
K=Country
L=Corporation ID
M=Student Enrollment Block
N=Career

Default Value: A

46 BILL_SORT_2 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 2

Prompt Table: BI_SORT_IVC_VW

47 BILL_SORT_3 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 3

Prompt Table: BI_SORT_IVC_VW

48 BILL_SORT_4 Character(1) VARCHAR2(1) NOT NULL Bill Sort Field 4

Prompt Table: BI_SORT_IVC_VW

49 SSF_EXTR_BNK_INFO Character(1) VARCHAR2(1) NOT NULL Extract Bank Information
50 SSF_TPC_STDCHG_DEF Character(1) VARCHAR2(1) NOT NULL Use Cross Ref Student Charge
51 STDNT_ENRL_BLOCK Character(5) VARCHAR2(5) NOT NULL Student Enrollment Block
52 NAME Character(50) VARCHAR2(50) NOT NULL Name
53 TOTAL_BILL Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Billed
54 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
55 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
56 TUITION_RES Character(5) VARCHAR2(5) NOT NULL Tuition Residency
57 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
F=Enrolled Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
P=Enrolled Part-Time
T=Three Quarter Time
58 SSF_ZIP_SRCH Character(12) VARCHAR2(12) NOT NULL Postal Code
59 SSF_COUNTRY_SRCH Character(3) VARCHAR2(3) NOT NULL Country
60 PRT_CLASS_SCHEDULE Character(1) VARCHAR2(1) NOT NULL Print Schedule of Classes
61 PRT_TERM_SCHEDULE Character(4) VARCHAR2(4) NOT NULL Print Term Schedule
62 PRINT_ZERO_BILL Character(1) VARCHAR2(1) NOT NULL Print Zero Bill

Y/N Table Edit

Default Value: N

63 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
64 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
65 SSF_NAME_COMM Character(50) VARCHAR2(50) NOT NULL Name of person receiving Comm
66 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

Prompt Table: COUNTRY_TBL

67 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
68 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
69 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
70 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
71 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
72 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
73 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

Prompt Table: STATE_OTH

74 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
75 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
76 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
77 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
AB=House Boat Reference
WW=House Trailer Reference
78 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
79 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
80 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
81 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

Y/N Table Edit

82 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
83 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
84 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
85 SSF_CAR_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Career Descr Short
86 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
87 SSF_PROG_DESCRSH Character(10) VARCHAR2(10) NOT NULL Short Description
88 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
89 SSF_PLAN_DESCRSH Character(10) VARCHAR2(10) NOT NULL Short Description
90 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
91 BI_SCAN_LINE Character(60) VARCHAR2(60) NOT NULL Bill Scan Line
92 DUE_DT Date(10) DATE Expected Birth Date
93 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
94 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
95 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
96 PRIOR_INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Prior Invoice ID
97 PRIOR_IVC_BALANCE Signed Number(17,2) DECIMAL(15,2) NOT NULL Prior Invoice Amount
98 PRT_BILL_FLAG Character(1) VARCHAR2(1) NOT NULL Print Bill Flag
99 PRT_DTTM_STAMP DateTime(26) TIMESTAMP Print Date/Time Stamp
100 RE_PRT_BILL_FLAG Character(1) VARCHAR2(1) NOT NULL RePrint Bill Flag
101 RE_PRT_DTTM_STAMP DateTime(26) TIMESTAMP RePrint Date/Time Stamp
102 SF_BILL_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
C=Cancelled
I=Initiated
103 SSF_CR_INV_IND Character(1) VARCHAR2(1) NOT NULL Credit Invoice
104 SSF_PREC_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
105 SSF_RELINV_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Related Invoice Amount
106 SSF_UPDATED_ADDR Character(1) VARCHAR2(1) NOT NULL Updated Address Flag
107 TYPE_OF_REQUEST Character(1) VARCHAR2(1) NOT NULL Type of Request
C=Organization
E=Student
108 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
109 BI_PRIOR_INV_CALC Character(1) VARCHAR2(1) NOT NULL Prior Invoice Calc Option
1=Use Prior Invoice Amount
2=Account Balance Method
110 INVOICE_FLAG Character(1) VARCHAR2(1) NOT NULL Create Invoices
A=Create Account Statements
C=Create Credit Invoices
I=Create Invoices

Default Value: I