| # |
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 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR
|
| 3 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_VW
|
| 4 |
EXD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
Y/N Table Edit
Default Value: N
|
| 5 |
STX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
Y/N Table Edit
Default Value: Y
|
| 6 |
UIN_APPL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
UIN Applicable Flag
Default Value: N
|
| 7 |
EXD_ECC_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Excise Control Code number. This code is unique to the Excise Tax Location and it is issued by the Excise authority
|
| 8 |
EXD_RGSTN_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Excise Registration Code. This field is unique to a particular Excise Tax Location.
|
| 9 |
EXD_RANGE |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Range. This field defines the Excise Range for a particular Tax Location code. It is used in documents and registers printing.
|
| 10 |
EXD_DIVISION |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Division. This field defines the Excise Division for a particular Tax Location code. It is used in documents and registers printing.
|
| 11 |
EXD_COLLECTORATE |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Collectorate. This field defines the Excise Collectorate for a particular Tax Location code. It is used in documents and registers printing.
|
| 12 |
EXD_ZONE |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Zone. This field defines the Excise Zone for a particular Tax Location code. It is used in documents and registers printing.
|
| 13 |
EXD_REGION |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Region. This field defines the Excise Region for a particular Tax Location code. It is used in documents and registers printing.
|
| 14 |
EXD_CIRCLE |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Circle. This field defines the Excise Circle for a particular Tax Location code. It is used in documents and registers printing.
|
| 15 |
EXD_SERV_TAX_RGSTN |
Character(16) |
VARCHAR2(16) NOT NULL |
Service Tax Registration Number. This is unique to the Excise Tax Location.
|
| 16 |
EXD_TAX_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Tax Category. This field is used to capture vendor, customer, item and product categories
Prompt Table:
EXS_TAX_CAT_VW2
|
| 17 |
STX_TAX_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Category. This field is used to capture vendor, customer, item and product categories
Prompt Table:
EXS_TAX_CAT_VW2
|
| 18 |
STX_CST_RGSTN |
Character(30) |
VARCHAR2(30) NOT NULL |
Central Sales Tax Registration Number. It is allocated by the Sales Tax authority. The CST registration number should be captured for the vendor and customer at their location levels.
|
| 19 |
STX_LST_RGSTN |
Character(30) |
VARCHAR2(30) NOT NULL |
Local SalesTax Registration Number. It is allocated by the Sales Tax authority. The LST registration number should be captured for the vendor and customer at their location levels.
|
| 20 |
EXS_TAX_TXN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
|
| 21 |
CSD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customs Duty applicable flag
Y/N Table Edit
Default Value: N
|
| 22 |
CSD_TAX_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Custom Tax Category
Prompt Table:
EXS_TAX_CAT_VW2
|
| 23 |
GST_RGSTN_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
GST Registration Number
|