GPMX_RC_GL_AFOR(SQL Table) |
Index Back |
|---|---|
Auxiliary Folios ReportRun Control Record for Auxiliary Folios Report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPMX_COMPANY_VW |
| 4 | GPMX_YEARCD | Character(4) | VARCHAR2(4) NOT NULL |
Year Field with Translate Values Range From 2015 to 2099
Default Value: 2015 |
| 5 | 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 Default Value: 01 |
| 6 | GPMX_DATE | Date(10) | DATE NOT NULL |
Date - Mexico
Default Value: %date |
| 7 | 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: CO |
| 8 | GPMX_VERSION | Character(5) | VARCHAR2(5) NOT NULL |
Version
Default Value: 1.2 |
| 9 | GPMX_GL_FR_ACC_POL | Character(50) | VARCHAR2(50) NOT NULL | Accountin Policy Number used to generate Auxiliary Folios Report. |
| 10 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 11 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 12 | GPMX_SBEG_DT | Date(10) | DATE | System Begin Date |
| 13 | GPMX_SEND_DT | Date(10) | DATE | System End Date |