GST_REPORT_REQ(SQL Table) |
Index Back |
---|---|
India GST ReportingIndia GST Reporting Run Control Record. |
# | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
4 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
5 | DATE_FROM | Date(10) | DATE | Date From |
6 | DATE_TO | Date(10) | DATE | Date To |
7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
8 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
9 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
Prompt Table: ORG_RGSTN_DTL |
10 | SEARCH_BUTTON1 | Character(1) | VARCHAR2(1) NOT NULL | Search |
11 | FS_MAP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Map ID
Prompt Table: GST_MAP_HDR_VW |
12 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
13 | SELECT_ALL | Character(1) | VARCHAR2(1) NOT NULL | Select All |
14 | SELECT_ALL_BTN | Character(1) | VARCHAR2(1) NOT NULL | Select All |
15 | DESELECT_ALL_BTN | Character(1) | VARCHAR2(1) NOT NULL | De-Select All Button |
16 | DESELECT_ALL | Character(1) | VARCHAR2(1) NOT NULL | Deselect All |