|
|
SQL 
Administration / 
Credit Cards
DTW Administration / Setup / Sales Opportunities / Sales Stages
API ACRC
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CreditCard KEY UNIQUE | Credit Card Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardName KEY | Credit Card Name | nVarChar | 30 | CARD_NAME | No | |||
| AcctCode | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Phone | Telephone | nVarChar | 20 | |||||
| CompanyId | Company ID | nVarChar | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| IntTaxCode | Internal Tax Code | nVarChar | 2 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| Country | Country Code | nVarChar | 3 | OCRY Countries |
Table relationship map
SELECT statement
SELECT
ACRC.CreditCard AS 'Credit Card Code',
ACRC.CardName AS 'Credit Card Name',
ACRC.AcctCode AS 'G/L Account',
ACRC.Phone AS 'Telephone',
ACRC.CompanyId AS 'Company ID',
ACRC.Locked AS 'Locked',
ACRC.DataSource AS 'Data Source',
ACRC.UserSign AS 'User Signature',
ACRC.LogInstanc AS 'Log Instance',
ACRC.UpdateDate AS 'Date of Update',
ACRC.IntTaxCode AS 'Internal Tax Code',
ACRC.UserSign2 AS 'Updating User',
ACRC.Country AS 'Country Code'
FROM ACRC AS ACRC
Related information
G/L Accounts OACT SQL Table
Countries OCRY SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates