biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Business Partner Master Data / Fiscal IDs for BP Master Data
API Business Partners / BP Fiscal Tax ID
CRD7 - Fiscal IDs for BP Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
25OCRD
Business Partner
PRIMARYYes
AddressAddressnVarChar
50
TaxId0Tax ID 0nVarChar
100
TaxId1Tax ID 1nVarChar
100
TaxId2Tax ID 2nVarChar
100
TaxId3Tax ID 3nVarChar
100
TaxId4Tax ID 4nVarChar
100
TaxId5Tax ID 5nVarChar
100
TaxId6Tax ID 6nVarChar
100
TaxId7Tax ID 7nVarChar
100
TaxId8Tax ID 8nVarChar
100
TaxId9Tax ID 9nVarChar
100
CNAEIdBrazil CNAE CodeInt
11OCNA
CNAE Code
TaxId10Tax ID 10nVarChar
100
TaxId11Tax ID 11nVarChar
100
AddrTypeAddress TypeVarChar
S) Ship To
B) Bill to
1
S
ECCNoE.C.C. No.nVarChar
40
CERegNoC.E. Registration No.nVarChar
40
CERangeC.E. RangenVarChar
60
CEDivisC.E. DivisionnVarChar
60
CEComRateC.E. CommisioneratenVarChar
60
LogInstancLog InstanceInt
11
0
SefazDateDate of Update from SEFAZDate
8
TaxId12Tax ID 12nVarChar
50
TaxId13Deductee Ref. No. in IndianVarChar
100

Table relationship map

SELECT statement

SELECT CRD7.CardCode AS 'BP Code', CRD7.Address AS 'Address', CRD7.TaxId0 AS 'Tax ID 0', CRD7.TaxId1 AS 'Tax ID 1', CRD7.TaxId2 AS 'Tax ID 2', CRD7.TaxId3 AS 'Tax ID 3', CRD7.TaxId4 AS 'Tax ID 4', CRD7.TaxId5 AS 'Tax ID 5', CRD7.TaxId6 AS 'Tax ID 6', CRD7.TaxId7 AS 'Tax ID 7', CRD7.TaxId8 AS 'Tax ID 8', CRD7.TaxId9 AS 'Tax ID 9', CRD7.CNAEId AS 'Brazil CNAE Code', CRD7.TaxId10 AS 'Tax ID 10', CRD7.TaxId11 AS 'Tax ID 11', CRD7.AddrType AS 'Address Type', CRD7.ECCNo AS 'E.C.C. No.', CRD7.CERegNo AS 'C.E. Registration No.', CRD7.CERange AS 'C.E. Range', CRD7.CEDivis AS 'C.E. Division', CRD7.CEComRate AS 'C.E. Commisionerate', CRD7.LogInstanc AS 'Log Instance', CRD7.SefazDate AS 'Date of Update from SEFAZ', CRD7.TaxId12 AS 'Tax ID 12', CRD7.TaxId13 AS 'Deductee Ref. No. in India' FROM CRD7 AS CRD7

Related information


BP Fiscal Tax ID BPFiscalTaxID Object· Table: CRD7
BPFiscalTaxID is a child object of the BusinessPartners and indicates the Brazilian Fiscal IDs info for each business partner. You can retrieve or set this object by using the FiscalTaxID property of the BusinessPartners object. This object...
   Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD SQL Table

CNAE Code OCNA SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates