GPMX_GL_AFN2_VW(SQL View) |
Index Back |
---|---|
GL Aux Folios Report DetAuxFolGL Aux Folios Report Node: DetAuxFol |
SELECT OPRID %Concat RUN_CNTL_ID , GPMX_GL_FR_ACC_POL , GPMX_DATE FROM PS_GPMX_RC_GL_AFOR |
# | 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_GL_FR_ACC_POL | Character(50) | VARCHAR2(50) NOT NULL | Accountin Policy Number used to generate Auxiliary Folios Report. |
3 | GPMX_DATE | Date(10) | DATE NOT NULL |
Date - Mexico
Default Value: %date |