SSF_INX_TMP

(SQL Table)
Index Back

Invoice Temp Record (Main)

Temporary record used by the XMLPublisher AE program to print invoices.

  • Parent Record Of SSF_INXBANK_TMP SSF_INXH_TMP SSF_INXMS_TMP
  • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    32 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    36 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

    37 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)
    38 TRANS_SORT_2 Character(1) VARCHAR2(1) NOT NULL Transaction Sort Field 2

    Prompt Table: BI_SORT_TRAN_VW

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

    Prompt Table: BI_SORT_TRAN_VW

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

    Prompt Table: BI_SORT_TRAN_VW

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

    Y/N Table Edit

    Default Value: N

    42 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)
    43 SSF_SUMFLD1_DESCR Character(30) VARCHAR2(30) NOT NULL Summary Field 1 Descr
    44 SUMM_FIELD_2 Character(1) VARCHAR2(1) NOT NULL Summarization Field 2

    Prompt Table: BI_SUMM_FLD_VW

    45 SSF_SUMFLD2_DESCR Character(30) VARCHAR2(30) NOT NULL Summary Field 2 Descr
    46 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

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

    Prompt Table: BI_SORT_IVC_VW

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

    Prompt Table: BI_SORT_IVC_VW

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

    Prompt Table: BI_SORT_IVC_VW

    50 SSF_EXTR_BNK_INFO Character(1) VARCHAR2(1) NOT NULL Extract Bank Information
    51 SSF_TPC_STDCHG_DEF Character(1) VARCHAR2(1) NOT NULL Use Cross Ref Student Charge
    52 SSF_TEMPLATE_CTRL Character(4) VARCHAR2(4) NOT NULL Template Control Field
    53 STDNT_ENRL_BLOCK Character(5) VARCHAR2(5) NOT NULL Student Enrollment Block
    54 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
    55 NAME Character(50) VARCHAR2(50) NOT NULL Name
    56 TOTAL_BILL Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Billed
    57 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    58 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected
    59 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    60 TUITION_RES Character(5) VARCHAR2(5) NOT NULL Tuition Residency
    61 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
    62 SSF_ZIP_SRCH Character(12) VARCHAR2(12) NOT NULL Postal Code
    63 SSF_COUNTRY_SRCH Character(3) VARCHAR2(3) NOT NULL Country
    64 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    65 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_VW2

    66 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

    Prompt Table: COMM_CA_CTX_VW

    67 BILL_COMM_FLAG Character(1) VARCHAR2(1) NOT NULL Bill Comm. Flag

    Y/N Table Edit

    Default Value: N

    68 ALT_BILLING_CM_FLG Character(1) VARCHAR2(1) NOT NULL Additional Bill Communication

    Y/N Table Edit

    Default Value: N

    69 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: SCC_STN_LTR_TBL

    70 LS_CONTACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contact Type

    Prompt Table: ORG_CNT_TYP_TBL

    71 PRT_CLASS_SCHEDULE Character(1) VARCHAR2(1) NOT NULL Print Schedule of Classes
    72 PRT_TERM_SCHEDULE Character(4) VARCHAR2(4) NOT NULL Print Term Schedule
    73 OVERRIDE_ADDR_REQ Character(1) VARCHAR2(1) NOT NULL Address not required

    Y/N Table Edit

    Default Value: N

    74 PRINT_ZERO_BILL Character(1) VARCHAR2(1) NOT NULL Print Zero Bill

    Y/N Table Edit

    Default Value: N

    75 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
    76 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    77 SSF_NAME_COMM Character(50) VARCHAR2(50) NOT NULL Name of person receiving Comm
    78 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    79 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    80 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    81 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    82 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    83 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    84 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    85 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    86 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    87 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    88 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    89 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    90 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    91 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    92 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    93 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    94 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    95 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship

    Default Value: NI

    96 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr
    97 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
    98 GUARDIAN_RELATIONS Character(2) VARCHAR2(2) NOT NULL Guardian Relationship
    LG=Legal Guardian
    NA=Not Applicable
    OT=Other
    PG=Parent Guardian
    SG=Self Guardian
    XG=Primary Guardian

    Default Value: NA

    99 ADDR_TYPE3 Character(4) VARCHAR2(4) NOT NULL Address Type
    100 SSF_INS_COMMLAST Character(1) VARCHAR2(1) NOT NULL Insert Comm Last Rec
    101 PRT_BILL_FLAG Character(1) VARCHAR2(1) NOT NULL Print Bill Flag