GPMX_SMART_KEYGPMX_NID_RFCCAL_RUN_IDGPMX_FISCAL_FOLIOGPMX_GL_AFN3_VW(SQL View) |
Index Back |
|---|---|
GL Aux Folios Report ComprNalGL Aux Folios Report Node: ComprNal |
| SELECT A.OPRID %Concat A.RUN_CNTL_ID AS GPMX_SMART_KEY , B.GPMX_NID_RFC AS GPMX_NID_RFC , B.CAL_RUN_ID AS CAL_RUN_ID , B.GPMX_FISCAL_FOLIO AS GPMX_FISCAL_FOLIO , B.CALC_RSLT_VAL AS CALC_RSLT_VAL , B.METHODNAME AS METHODNAME , C.CURRENCY_CD AS CURRENCY_CD FROM PS_GPMX_RC_GL_AFOR A , PS_GPMX_DIG_TBL B , PS_GP_RSLT_SEG_VW C WHERE A.COMPANY = B.COMPANY AND B.EMPLID = C.EMPLID AND B.EMPL_RCD = C.EMPL_RCD AND B.GP_PAYGROUP = C.GP_PAYGROUP AND B.CAL_RUN_ID = C.CAL_RUN_ID AND B.CAL_ID = C.CAL_ID AND B.ORIG_CAL_RUN_ID = C.ORIG_CAL_RUN_ID AND B.RSLT_SEG_NUM = C.RSLT_SEG_NUM AND B.CALC_RSLT_VAL > 0 AND C.PYMT_DT BETWEEN A.GPMX_SBEG_DT AND A.GPMX_SEND_DT ORDER BY GPMX_SMART_KEY, B.GPMX_NID_RFC, B.CAL_RUN_ID |
| # | 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_NID_RFC |
Character(20) | VARCHAR2(20) NOT NULL | National ID: RFC |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | GPMX_FISCAL_FOLIO |
Character(50) | VARCHAR2(50) NOT NULL | Fiscal Folio (UUID) SAT |
| 5 | GPMX_TOT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Amount |
| 6 | METHODNAME | Character(32) | VARCHAR2(32) NOT NULL | Method Name |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |