PROCESS_INSTANCERUN_CNTL_IDPrompt Table: ORG_RGSTN_DTL
Prompt Table: STATE_TBL
Prompt Table: FS_MAP_HDR_TBL
GST_RPT_RUN_AET(SQL Table) |
Index Back |
|---|---|
India GST ReportingIndia GST Reporting AET Record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 5 | DATE_FROM | Date(10) | DATE | Date From |
| 6 | DATE_TO | Date(10) | DATE | Date To |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
Prompt Table: ORG_RGSTN_DTL |
| 9 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 10 | GST_RGSTN_NBR | Character(30) | VARCHAR2(30) NOT NULL | GST Registration Number |
| 11 | FS_MAP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Map ID
Prompt Table: FS_MAP_HDR_TBL |
| 12 | FS_MAP_RET | Number(4,0) | SMALLINT NOT NULL | Result |
| 13 | FILEPATH | Character(30) | VARCHAR2(30) NOT NULL | File Information |
| 14 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 15 | FS_RET_DESRC | Character(254) | VARCHAR2(254) NOT NULL | Result Description |