biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Sales Opportunities / Sales Stages
API ACRC
ACRC - Credit Cards Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreditCard KEY UNIQUECredit Card CodeInt
6
PRIMARYYes
CardName KEYCredit Card NamenVarChar
30
CARD_NAMENo
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 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



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