RE_SLSCAT_SRCH(SQL View) |
Index Back |
---|---|
Sales Category Charge GroupSearch 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)) |
# | 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 |