📚 SAP Business One SDK Help

Table Name: OLCT

Table Description: Location

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 -      
Key Unique Field
PRIMARY Yes Code
LOCATION Yes Location