|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Service Call BP Address
Table Name: ASC7
Table Description: Service Call BP Address
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OSCL | Â | Â | Â |
| TaxId0 | Tax ID 0 | nVarChar | 100 | - | Â | Â | Â |
| TaxId1 | Tax ID 1 | nVarChar | 100 | - | Â | Â | Â |
| TaxId2 | Tax ID 2 | nVarChar | 100 | - | Â | Â | Â |
| TaxId3 | Tax ID 3 | nVarChar | 100 | - | Â | Â | Â |
| TaxId4 | Tax ID 4 | nVarChar | 100 | - | Â | Â | Â |
| TaxId5 | Tax ID 5 | nVarChar | 100 | - | Â | Â | Â |
| TaxId6 | Tax ID 6 | nVarChar | 100 | - | Â | Â | Â |
| TaxId7 | Tax ID 7 | nVarChar | 100 | - | Â | Â | Â |
| TaxId8 | Tax ID 8 | nVarChar | 100 | - | Â | Â | Â |
| TaxId9 | Tax ID 9 | nVarChar | 100 | - | Â | Â | Â |
| State | State Code | nVarChar | 3 | - | Â | Â | Â |
| County | County Code | nVarChar | 7 | - | Â | Â | Â |
| Incoterms | Incoterms | nVarChar | 3 | - | Â | Â | Â |
| Vehicle | Vehicle ID | nVarChar | 10 | - | Â | Â | Â |
| VidState | Vehicle ID (State) | nVarChar | 3 | - | Â | Â | Â |
| NfRef | NF Reference | nVarChar | 254 | - | Â | Â | Â |
| Carrier | Carrier Code | nVarChar | 15 | OCRD | Â | Â | Â |
| QoP | Quantity of Packs | Int | 11 | - | Â | Â | Â |
| PackDesc | Pack Description | nVarChar | 10 | - | Â | Â | Â |
| Brand | Brand | nVarChar | 20 | - | Â | Â | Â |
| NoSU | Number of Shipping Unit | Int | 11 | - | Â | Â | Â |
| NetWeight | Net Weight | Num | 19.6 | - | Â | Â | Â |
| GrsWeight | Gross Weight | Num | 19.6 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 191 | Â | Â |
| TaxId10 | Tax ID 10 | nVarChar | 100 | - | Â | Â | Â |
| TransCat | Transaction Category | nVarChar | 100 | - | Â | Â | Â |
| FormNo | Form No. | nVarChar | 100 | - | Â | Â | Â |
| TaxId11 | Tax ID 11 | nVarChar | 100 | - | Â | Â | Â |
| StreetS | Street | nVarChar | 100 | - | Â | Â | Â |
| BlockS | Block | nVarChar | 100 | - | Â | Â | Â |
| BuildingS | Building/Floor/Room | Text | 16 | - | Â | Â | Â |
| CityS | City | nVarChar | 100 | - | Â | Â | Â |
| ZipCodeS | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| CountyS | County | nVarChar | 100 | - | Â | Â | Â |
| StateS | State | nVarChar | 3 | OCST | Â | Â | Â |
| CountryS | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| AddrTypeS | Address Type | nVarChar | 100 | - | Â | Â | Â |
| StreetNoS | Street No. | nVarChar | 100 | - | Â | Â | Â |
| StreetB | Street | nVarChar | 100 | - | Â | Â | Â |
| BlockB | Block | nVarChar | 100 | - | Â | Â | Â |
| BuildingB | Building/Floor/Room | Text | 16 | - | Â | Â | Â |
| CityB | City | nVarChar | 100 | - | Â | Â | Â |
| ZipCodeB | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| CountyB | County | nVarChar | 100 | - | Â | Â | Â |
| StateB | State | nVarChar | 3 | OCST | Â | Â | Â |
| CountryB | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| AddrTypeB | Address Type | nVarChar | 100 | - | Â | Â | Â |
| StreetNoB | Street No. | nVarChar | 100 | - | Â | Â | Â |
| ImpORExp | Import or Export | VarChar | 1 | - | Â | N | Â |
| Â | Â | Â | Â | Â | Â | Y | Â |
| Vat | VAT | VarChar | 1 | - | N | N | No VAT Support |
| Â | Â | Â | Â | Â | Â | Y | VAT Support |
| AltCrdNamB | Alternative BP Name | nVarChar | 200 | - | Â | Â | Â |
| AltTaxIdB | Alternative Tax ID | nVarChar | 32 | - | Â | Â | Â |
| Address2S | Address Name 2 | nVarChar | 50 | - | Â | Â | Â |
| Address3S | Address Name 3 | nVarChar | 50 | - | Â | Â | Â |
| Address2B | Address Name 2 | nVarChar | 50 | - | Â | Â | Â |
| Address3B | Address Name 3 | nVarChar | 50 | - | Â | Â | Â |
| MainUsage | Main Usage Code of Document | Int | 11 | OUSG | Â | Â | Â |
| GlbLocNumS | Global Location Number | nVarChar | 50 | - | Â | Â | Â |
| GlbLocNumB | Global Location Number | nVarChar | 50 | - | Â | Â | Â |
| CollectDT | Date and Time of Collection | nVarChar | 20 | - | Â | Â | Â |
| TransprtDT | Transport Starting Date | Date | 8 | - | Â | Â | Â |
| TransprtRS | Transport Reason | nVarChar | 100 | - | Â | Â | Â |
| TaxId12 | Tax ID 12 | nVarChar | 50 | - | Â | Â | Â |
| TaxId13 | Deductee Ref. No. in India | nVarChar | 100 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LogInstanc |