|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Credit Cards
Table Name: ACRC
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 |
| Â | Â | LogInstanc |
| CARD_NAME | No | CardName |
| Â | Â | LogInstanc |