GST_REPORT_REQ

(SQL Table)
Index Back

India GST Reporting

India 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