OCFP - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / CFOP for Nota Fiscal

DTW Administration / Setup / General / User Default Groups

API OCFP / / Nota Fiscal CFOP

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
ID ^KEY ^UNIQUE	CFOP ID	Int		11			PRIMARY	Yes
Code ^KEY ^UNIQUE	CFOP Code	nVarChar		6			CFOP_CODE	Yes
Descrip	Description	Text		16
App	Application	Text		16
Locked	Locked	VarChar	Y) Yes N) No	1		N
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) OBServer A) Auto Incr. D) Data Doc. P) Partner Implementation	1		N
UserSign	User Signature	nVarChar		6	OUSR Users
LogInstanc	Log Instance	Int		11
UserSign2	Updating User	Int		6	OUSR Users
UpdateDate	Update Date	Date		8

Table relationship map

SELECT statement

SELECT
   OCFP.ID AS 'CFOP ID', 
   OCFP.Code AS 'CFOP Code', 
   OCFP.Descrip AS 'Description', 
   OCFP.App AS 'Application', 
   OCFP.Locked AS 'Locked', 
   OCFP.DataSource AS 'Data Source', 
   OCFP.UserSign AS 'User Signature', 
   OCFP.LogInstanc AS 'Log Instance', 
   OCFP.UserSign2 AS 'Updating User', 
   OCFP.UpdateDate AS 'Update Date'
FROM OCFP AS OCFP

Related information

NotaFiscalCFOP Object· Table: OCFP

Represents CFOP codes for Nota Fiscal documents. CFOP codes describes the business transaction from the tax authorities' point of view. Source table: OCFP

OCFP SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
NotaFiscalCFOP

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Application

Browser

Code

Description

UserFields

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