STX_RGSTN_DTL(SQL Table) |
Index Back |
|---|---|
Registration Details |
| # | 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 Default Value: L |
| 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
Default Value: N |