|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Fiscal IDs for BP Master Data
Table Name: CRD7
Table Description: Fiscal IDs for BP Master Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CardCode | BP Code | nVarChar | 25 | OCRD | Â | Â | Â |
| Address | Address | nVarChar | 50 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| CNAEId | Brazil CNAE Code | Int | 11 | OCNA | Â | Â | Â |
| TaxId10 | Tax ID 10 | nVarChar | 100 | - | Â | Â | Â |
| TaxId11 | Tax ID 11 | nVarChar | 100 | - | Â | Â | Â |
| AddrType | Address Type | VarChar | 1 | - | S | S | Ship To |
| Â | Â | Â | Â | Â | Â | B | Bill To |
| ECCNo | E.C.C. No. | nVarChar | 40 | - | Â | Â | Â |
| CERegNo | C.E. Registration No. | nVarChar | 40 | - | Â | Â | Â |
| CERange | C.E. Range | nVarChar | 60 | - | Â | Â | Â |
| CEDivis | C.E. Division | nVarChar | 60 | - | Â | Â | Â |
| CEComRate | C.E. Commisionerate | nVarChar | 60 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| SefazDate | Date of Update from SEFAZ | Date | 8 | - | Â | Â | Â |
| TaxId12 | Tax ID 12 | nVarChar | 50 | - | Â | Â | Â |
| TaxId13 | Deductee Ref. No. in India | nVarChar | 100 | - | Â | Â | Â |
| AToRetrNFe | Authorization to Retrieve NFe from SEFAZ | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxId14 | ITR Filing | nVarChar | 250 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CardCode |
| Â | Â | Address |
| Â | Â | AddrType |