|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Business Partner Addresses - History
Table Name: ACR1
Table Description: Business Partner Addresses - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Address | Address Name | nVarChar | 50 | - | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | ACRD | Â | Â | Â |
| Street | Street | nVarChar | 100 | - | Â | Â | Â |
| Block | Block | nVarChar | 100 | - | Â | Â | Â |
| ZipCode | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| City | City | nVarChar | 100 | - | Â | Â | Â |
| County | County | nVarChar | 100 | - | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| State | State | nVarChar | 3 | OCST | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 2 | Â | Â |
| LicTradNum | Federal Tax ID | nVarChar | 32 | - | Â | Â | Â |
| LineNum | Row No. | Int | 11 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| Building | Building/Floor/Room | Text | 16 | - | Â | Â | Â |
| AdresType | Address Type | VarChar | 1 | - | S | S | Ship To |
| Â | Â | Â | Â | Â | Â | B | Bill To |
| Address2 | Address Name 2 | nVarChar | 50 | - | Â | Â | Â |
| Address3 | Address Name 3 | nVarChar | 50 | - | Â | Â | Â |
| AddrType | Address Type | nVarChar | 100 | - | Â | Â | Â |
| StreetNo | Street No. | nVarChar | 100 | - | Â | Â | Â |
| AltCrdName | Alternative BP Name | nVarChar | 200 | - | Â | Â | Â |
| AltTaxId | Alternative Tax ID | nVarChar | 32 | - | Â | Â | Â |
| TaxOffice | Tax Office | nVarChar | 50 | - | Â | Â | Â |
| GlblLocNum | Global Location Number | nVarChar | 50 | - | Â | Â | Â |
| Ntnlty | Nationality | nVarChar | 100 | - | Â | Â | Â |
| DIOTNat | DIOT Nationality | nVarChar | 3 | OCRY | Â | Â | Â |
| TaaSEnbl | TaaS Service Enabled on Address | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| GSTRegnNo | GSTIN | nVarChar | 15 | - | Â | Â | Â |
| GSTType | GST Type | Int | 11 | OGTY | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTS | Creation Time Incl. Sec. | Int | 11 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| MYFType | MYF Type | nVarChar | 2 | - | Â | S1 | MYF Wholesale Sales |
| Â | Â | Â | Â | Â | Â | S2 | Retail Sales |
| Â | Â | Â | Â | Â | Â | P1 | MYF Wholesale Purchases |
| Â | Â | Â | Â | Â | Â | P3 | Other Expense Transactions |
| VatResDate | VAT Verfication Response Date | Date | 8 | - | Â | Â | Â |
| VatResCode | VAT Verfication Response Code | Int | 11 | ORVC | Â | Â | Â |
| VatResName | VAT Verfication Response Name | nVarChar | 254 | - | Â | Â | Â |
| VatResAddr | VAT Verfication Response Addr | nVarChar | 254 | - | Â | Â | Â |
| EnNtnlty | Encryption of Nationality | Text | 16 | - | Â | Â | Â |
| EnLicTradN | Encrypt TAX ID Number | Text | 16 | - | Â | Â | Â |
| Active | Active | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AlwChInAdd | Allow Changes in Address Components | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SiretNo | SIRET No. | nVarChar | 32 | - | Â | Â | Â |
| RoutingCod | Routing Code | nVarChar | 100 | - | Â | Â | Â |
| Suffix | Suffix | nVarChar | 20 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CardCode |
| Â | Â | Address |
| Â | Â | AdresType |
| Â | Â | LogInstanc |