biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Location
DTW Administration / Setup / Inventory / Warehouse Locations
API OLCT / / Warehouse Locations
OLCT - Location Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUELocation CodeInt
11
PRIMARYYes
Location KEY UNIQUENamenVarChar
100
LOCATIONYes
UserSignUser SignatureInt
6OUSR
Users
PanCirNoPAN Circle No.nVarChar
32
PanWardNoPAN Ward No.nVarChar
32
PanOfficerPAN Assessing OfficernVarChar
32
TanCirNoTAN Circle No.nVarChar
32
TanWardNoTAN Ward No.nVarChar
32
TanOfficerTAN Assessing OfficernVarChar
32
LstVatNoLST/VAT NumbernVarChar
100
CstNoCST NumbernVarChar
100
ExemptNoExemption NumbernVarChar
100
TanNoTAN NumbernVarChar
100
ServTaxNoService Tax NumbernVarChar
100
AsseTypeAssessee TypenVarChar
100
CompTypeCompany TypenVarChar
100
NatOfBizNature of BusinessnVarChar
100
TinNoTIN NumbernVarChar
100
PanNoPAN NumbernVarChar
10
RegTypeRegistration TypenVarChar
XM) XM
XD) XD
EM) EM
ED) ED
SD) SD
2
EccNoECC NumbernVarChar
40
CeRegNoCE Register NumbernVarChar
40
CeRangeCE RangenVarChar
60
CeDivisionCE DivisionnVarChar
60
CeComRateCE CommissioneratenVarChar
60
ManuCodeManufaturer CodenVarChar
60
JurisdJurisdictionnVarChar
60
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100
CountryCountrynVarChar
3OCRY
Countries
StateStatenVarChar
3
BuildingBuilding/Floor/RoomText
16
SSIExmptSSI ExemptionVarChar
Y) Yes
N) No
1
N
SSIExmptStSSI Exemption StatusVarChar
E) New Location
N) Upgrade Not Changed
C) Upgrade Changed
1
E
CitAddressCIT AddressnVarChar
127
CitCityCIT CitynVarChar
100
CitPinCodeCIT Pin CodenVarChar
10

Table relationship map

SELECT statement

SELECT OLCT.Code AS 'Location Code', OLCT.Location AS 'Name', OLCT.UserSign AS 'User Signature', OLCT.PanCirNo AS 'PAN Circle No.', OLCT.PanWardNo AS 'PAN Ward No.', OLCT.PanOfficer AS 'PAN Assessing Officer', OLCT.TanCirNo AS 'TAN Circle No.', OLCT.TanWardNo AS 'TAN Ward No.', OLCT.TanOfficer AS 'TAN Assessing Officer', OLCT.LstVatNo AS 'LST/VAT Number', OLCT.CstNo AS 'CST Number', OLCT.ExemptNo AS 'Exemption Number', OLCT.TanNo AS 'TAN Number', OLCT.ServTaxNo AS 'Service Tax Number', OLCT.AsseType AS 'Assessee Type', OLCT.CompType AS 'Company Type', OLCT.NatOfBiz AS 'Nature of Business', OLCT.TinNo AS 'TIN Number', OLCT.PanNo AS 'PAN Number', OLCT.RegType AS 'Registration Type', OLCT.EccNo AS 'ECC Number', OLCT.CeRegNo AS 'CE Register Number', OLCT.CeRange AS 'CE Range', OLCT.CeDivision AS 'CE Division', OLCT.CeComRate AS 'CE Commissionerate', OLCT.ManuCode AS 'Manufaturer Code', OLCT.Jurisd AS 'Jurisdiction', OLCT.Street AS 'Street', OLCT.Block AS 'Block', OLCT.ZipCode AS 'Zip Code', OLCT.City AS 'City', OLCT.County AS 'County', OLCT.Country AS 'Country', OLCT.State AS 'State', OLCT.Building AS 'Building/Floor/Room', OLCT.SSIExmpt AS 'SSI Exemption', OLCT.SSIExmptSt AS 'SSI Exemption Status', OLCT.CitAddress AS 'CIT Address', OLCT.CitCity AS 'CIT City', OLCT.CitPinCode AS 'CIT Pin Code' FROM OLCT AS OLCT

Related information


Warehouse Locations WarehouseLocations Object· Table: OLCT
The WarehouseLocations object enables to define geographical locations for warehouses. Source table: OLCT.

OLCT SQL Table

Countries OCRY SQL Table

Users OUSR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates