GPMX_GL_AFN1_VW

(SQL View)
 Index Back

GL Aux Folios Report RepAuxFol

GL Aux Folios Report Node: RepAuxFol

SELECT A.OPRID %Concat A.RUN_CNTL_ID , A.GPMX_VERSION , B.RFC_ER_ID_MEX , A.MONTHCD , A.GPMX_YEARCD , A.GPMX_REQUEST_TYPE FROM PS_GPMX_RC_GL_AFOR A , PS_COMPANY_TBL_MEX B WHERE A.COMPANY = B.COMPANY AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPANY_TBL_MEX WHERE COMPANY = A.COMPANY AND EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPMX_SMART_KEY Character(90) VARCHAR2(90) NOT NULL Smart Key Used to Sort GL Auxiliary Folios Report
2 GPMX_VERSION Character(5) VARCHAR2(5) NOT NULL Version
3 RFC_ER_ID_MEX Character(16) VARCHAR2(16) NOT NULL RFC ID Number
4 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
5 GPMX_YEARCD Character(4) VARCHAR2(4) NOT NULL Year Field with Translate Values Range From 2015 to 2099
6 GPMX_REQUEST_TYPE Character(2) VARCHAR2(2) NOT NULL Request type field used by Auxiliary Folios Report.
AF=Fiscalization Act
CO=Compensation
DE=Devolution
FC=Fiscalization Certified

Default Value: FC