biuan SAP® BUSINESS ONE SDK
API ORCN
ORCN - Retail Chains Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ChainCode KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ChainName KEY UNIQUEChain NamenVarChar
20
NAMEYes
SuppNumVendor CodenVarChar
20
SuppNameVendor NamenVarChar
20
LockedLockedVarChar
Y) Yes
N) No
1
N
SavePathFile PathText
16
UsePartSupUse Goods Del.VarChar
Y) Yes
N) No
1
N
BaseCodeBasic Grid TemplateInt
11
-1
DataSourceData SourceVarChar
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
ExportNumExport CounterInt
11
0
UserSignUser SignatureInt
6OUSR
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


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