biuan SAP® BUSINESS ONE SDK
SQL Administration / Credit Cards
DTW Administration / Setup / Banking / Credit Cards
API OCRC / / Credit Cards
OCRC - Credit Cards Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreditCard KEY UNIQUECredit Card CodeInt
6
PRIMARYYes
CardName KEY UNIQUECredit Card NamenVarChar
30
CARD_NAMEYes
AcctCodeG/L AccountnVarChar
15OACT
G/L Accounts
PhoneTelephonenVarChar
20
CompanyIdCompany IDnVarChar
20
LockedLockedVarChar
Y) Yes
N) No
1
N
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
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
IntTaxCodeInternal Tax CodenVarChar
2
UserSign2Updating UserInt
6OUSR
Users
CountryCountry CodenVarChar
3OCRY
Countries

Table relationship map

SELECT statement

SELECT OCRC.CreditCard AS 'Credit Card Code', OCRC.CardName AS 'Credit Card Name', OCRC.AcctCode AS 'G/L Account', OCRC.Phone AS 'Telephone', OCRC.CompanyId AS 'Company ID', OCRC.Locked AS 'Locked', OCRC.DataSource AS 'Data Source', OCRC.UserSign AS 'User Signature', OCRC.LogInstanc AS 'Log Instance', OCRC.UpdateDate AS 'Date of Update', OCRC.IntTaxCode AS 'Internal Tax Code', OCRC.UserSign2 AS 'Updating User', OCRC.Country AS 'Country Code' FROM OCRC AS OCRC

Related information


Credit Cards CreditCards Object· Table: OCRC
The CreditCards object enables to define credit cards that the company can use for incoming and outgoing payments. Source table: OCRC.

OCRC SQL Table

G/L Accounts OACT 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