SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OCRC
Table Description: Credit Cards
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| CreditCard |
Credit Card Code |
Int |
6 |
- |
|
|
|
| CardName |
Credit Card Name |
nVarChar |
30 |
- |
|
|
|
| AcctCode |
G/L Account |
nVarChar |
15 |
OACT |
|
|
|
| Phone |
Telephone |
nVarChar |
50 |
- |
|
|
|
| CompanyId |
Company ID |
nVarChar |
20 |
- |
|
|
|
| Locked |
Locked |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| IntTaxCode |
Internal Tax Code |
nVarChar |
2 |
- |
|
|
|
| |
|
|
|
|
|
1 |
Isracard |
| |
|
|
|
|
|
2 |
CAL |
| |
|
|
|
|
|
3 |
Diners |
| |
|
|
|
|
|
4 |
American Express |
| |
|
|
|
|
|
6 |
Leumi Card |
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| Country |
Country/Region Code |
nVarChar |
3 |
OCRY |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
CreditCard |
| CARD_NAME |
Yes |
CardName |