biuan SAP® BUSINESS ONE SDK
API ACR7
ACR7 - 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
CNAEIdBrazilian 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 ACR7.CardCode AS 'BP Code', ACR7.Address AS 'Address', ACR7.TaxId0 AS 'Tax ID 0', ACR7.TaxId1 AS 'Tax ID 1', ACR7.TaxId2 AS 'Tax ID 2', ACR7.TaxId3 AS 'Tax ID 3', ACR7.TaxId4 AS 'Tax ID 4', ACR7.TaxId5 AS 'Tax ID 5', ACR7.TaxId6 AS 'Tax ID 6', ACR7.TaxId7 AS 'Tax ID 7', ACR7.TaxId8 AS 'Tax ID 8', ACR7.TaxId9 AS 'Tax ID 9', ACR7.CNAEId AS 'Brazilian CNAE Code', ACR7.TaxId10 AS 'Tax ID 10', ACR7.TaxId11 AS 'Tax ID 11', ACR7.AddrType AS 'Address Type', ACR7.ECCNo AS 'E.C.C. No.', ACR7.CERegNo AS 'C.E. Registration No.', ACR7.CERange AS 'C.E. Range', ACR7.CEDivis AS 'C.E. Division', ACR7.CEComRate AS 'C.E. Commisionerate', ACR7.LogInstanc AS 'Log Instance', ACR7.SefazDate AS 'Date of Update from SEFAZ', ACR7.TaxId12 AS 'Tax ID 12', ACR7.TaxId13 AS 'Deductee Ref. No. in India' FROM ACR7 AS ACR7

Related information


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