STX_RGST_VW(SQL View) |
Index Back |
|---|---|
GST registration View |
| SELECT SETID ,ORG_CODE ,COUNTRY ,STATE ,STX_APPL_IND ,STX_RGSTN_NBR ,GST_RGSTN_NBR ,UIN_APPL_FLAG FROM PS_STX_RGSTN_DTL WHERE STX_APPL_IND <>'G' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ORG_CODE |
Character(6) | VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
Prompt Table: ORG_RGSTN_DTL |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 4 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 5 | STX_APPL_IND |
Character(1) | VARCHAR2(1) NOT NULL |
SalesTax Applicability Indicator
C=Central Sales Tax I=IntraState L=Local Sales Tax O=InterState V=Value Added Tax |
| 6 | STX_RGSTN_NBR | Character(20) | VARCHAR2(20) NOT NULL | Registration Number |
| 7 | GST_RGSTN_NBR | Character(30) | VARCHAR2(30) NOT NULL | GST Registration Number |
| 8 | UIN_APPL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | UIN Applicable Flag |