|
|
API ORCN
ORCN - Retail Chains Table
Users OUSR SQL 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
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
