RE_SLSCAT_SRCH

(SQL View)
Index Back

Sales Category Charge Group

Search view for the Charge Group Codes for the Sales Reporting Categories to be used by Lease Administration to classify the sales reported and to separate each Sales Category as a separate bill line.

SELECT A.SETID , A.TXN_GRP , A.CHG_GRP_CD , A.INSTANCE_NAME FROM PS_RE_SLS_CAT A WHERE (%CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT) OR (A.EFFDT = ( SELECT MIN(C.EFFDT) FROM PS_RE_SLS_CAT C WHERE C.SETID = A.SETID AND C.CHG_GRP_CD = A.CHG_GRP_CD AND C.TXN_GRP = A.TXN_GRP AND C.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_RE_SLS_CAT B WHERE B.SETID = A.SETID AND B.CHG_GRP_CD = A.CHG_GRP_CD AND B.TXN_GRP = A.TXN_GRP AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT))

  • Related Language Record: RE_SLSCATSR_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
    1=Base Rent
    2=Security Deposit
    3=Straightline Accounting
    4=Operating Expense
    5=Percent Rent
    6=Miscellaneous Rent
    7=Manual Fee
    8=Lease Obligation
    9=Lease Interest Expense
    A=Prior Period Lease Obligation
    B=Prior Period Lease Interest
    C=Rent Expense
    D=Lease Incentive

    Default Value: 5

    3 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.
    4 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Sales Category Name