| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Location Code |
Int |
11 |
- |
|
|
|
| Location |
Name |
nVarChar |
100 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| PanCirNo |
PAN Circle No. |
nVarChar |
32 |
- |
|
|
|
| PanWardNo |
PAN Ward No. |
nVarChar |
32 |
- |
|
|
|
| PanOfficer |
PAN Assessing Officer |
nVarChar |
32 |
- |
|
|
|
| TanCirNo |
TAN Circle No. |
nVarChar |
32 |
- |
|
|
|
| TanWardNo |
TAN Ward No. |
nVarChar |
32 |
- |
|
|
|
| TanOfficer |
TAN Assessing Officer |
nVarChar |
32 |
- |
|
|
|
| LstVatNo |
LST/VAT Number |
nVarChar |
100 |
- |
|
|
|
| CstNo |
CST Number |
nVarChar |
100 |
- |
|
|
|
| ExemptNo |
Exemption Number |
nVarChar |
100 |
- |
|
|
|
| TanNo |
TAN Number |
nVarChar |
100 |
- |
|
|
|
| ServTaxNo |
Service Tax Number |
nVarChar |
100 |
- |
|
|
|
| AsseType |
Assessee Type |
nVarChar |
100 |
- |
|
|
|
| CompType |
Company Type |
nVarChar |
100 |
- |
|
|
|
| NatOfBiz |
Nature of Business |
nVarChar |
100 |
- |
|
|
|
| TinNo |
TIN Number |
nVarChar |
100 |
- |
|
|
|
| PanNo |
PAN Number |
nVarChar |
10 |
- |
|
|
|
| RegType |
Registration Type |
nVarChar |
2 |
- |
|
XM |
XM |
| |
|
|
|
|
|
XD |
XD |
| |
|
|
|
|
|
EM |
EM |
| |
|
|
|
|
|
ED |
ED |
| |
|
|
|
|
|
SD |
SD |
| EccNo |
ECC Number |
nVarChar |
40 |
- |
|
|
|
| CeRegNo |
CE Register Number |
nVarChar |
40 |
- |
|
|
|
| CeRange |
CE Range |
nVarChar |
60 |
- |
|
|
|
| CeDivision |
CE Division |
nVarChar |
60 |
- |
|
|
|
| CeComRate |
CE Commissionerate |
nVarChar |
60 |
- |
|
|
|
| ManuCode |
Manufaturer Code |
nVarChar |
60 |
- |
|
|
|
| Jurisd |
Jurisdiction |
nVarChar |
60 |
- |
|
|
|
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| Block |
Block |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| County |
County |
nVarChar |
100 |
- |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| State |
State |
nVarChar |
3 |
- |
|
|
|
| Building |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| SSIExmpt |
SSI Exemption |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SSIExmptSt |
SSI Exemption Status |
VarChar |
1 |
- |
E |
E |
New Location |
| |
|
|
|
|
|
N |
Upgrade Not Changed |
| |
|
|
|
|
|
C |
Upgrade Changed |
| CitAddress |
CIT Address |
nVarChar |
254 |
- |
|
|
|
| CitCity |
CIT City |
nVarChar |
100 |
- |
|
|
|
| CitPinCode |
CIT Pin Code |
nVarChar |
10 |
- |
|
|
|
| OnHoldAct |
Capital Goods On Hold Account |
nVarChar |
15 |
OACT |
|
|
|
| GSTRegnNo |
GSTIN |
nVarChar |
15 |
- |
|
|
|
| GSTRelevt |
GST Location Relevant |
nVarChar |
2 |
- |
N |
|
|
| GSTTDS |
GSTIN TDS |
nVarChar |
30 |
- |
|
|
|
| GSTISD |
GSTIN ISD |
nVarChar |
30 |
- |
|
|
|
| GSTType |
GST Type |
Int |
11 |
OGTY |
|
-1 |
|
| |
|
|
|
|
|
1 |
Regular/TDS/ISD |
| |
|
|
|
|
|
2 |
Casual Taxable Person |
| |
|
|
|
|
|
3 |
Composition Levy |
| |
|
|
|
|
|
4 |
Government Department or PSU |
| |
|
|
|
|
|
5 |
Non-Resident Taxable Person |
| |
|
|
|
|
|
6 |
UN Agency or Embassy |
| VendorCode |
Vendor Code |
nVarChar |
15 |
OCRD |
|
|
|
| CstmerCode |
Customer Code |
nVarChar |
15 |
OCRD |
|
|
|
| DropShip |
Drop Ship Warehouse |
nVarChar |
8 |
OWHS |
|
|
|
| IngClrAc |
Ineligible ITC Clearing A/C |
nVarChar |
15 |
- |
|
|
|
| IntBrClrAc |
Inter-branch ITC Clearing A/C |
nVarChar |
15 |
- |
|
|
|