ORCN - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Inventory and Production /

Retail Chains

API ORCN

ORCN - Retail Chains Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
ChainCode ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
ChainName ^KEY ^UNIQUE	Chain Name	nVarChar		20			NAME	Yes
SuppNum	Vendor Code	nVarChar		20
SuppName	Vendor Name	nVarChar		20
Locked	Locked	VarChar	Y) Yes N) No	1		N
SavePath	File Path	Text		16
UsePartSup	Use Goods Del.	VarChar	Y) Yes N) No	1		N
BaseCode	Basic Grid Template	Int		11		-1
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
ExportNum	Export Counter	Int		11		0
UserSign	User Signature	Int		6	OUSR Users

SELECT statement

SELECT
   ORCN.ChainCode AS 'Internal Number', 
   ORCN.ChainName AS 'Chain Name', 
   ORCN.SuppNum AS 'Vendor Code', 
   ORCN.SuppName AS 'Vendor Name', 
   ORCN.Locked AS 'Locked', 
   ORCN.SavePath AS 'File Path', 
   ORCN.UsePartSup AS 'Use Goods Del.', 
   ORCN.BaseCode AS 'Basic Grid Template', 
   ORCN.DataSource AS 'Data Source', 
   ORCN.ExportNum AS 'Export Counter', 
   ORCN.UserSign AS 'User Signature'
FROM ORCN AS ORCN

Related information

OUSR SQL Table

biuan SAP® BUSINESS ONE

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