biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / User Default Groups
API OCFP / / Nota Fiscal CFOP
OCFP - CFOP for Nota Fiscal Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ID KEY UNIQUECFOP IDInt
11
PRIMARYYes
Code KEY UNIQUECFOP CodenVarChar
6
CFOP_CODEYes
DescripDescriptionText
16
AppApplicationText
16
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) OBServer
A) Auto Incr.
D) Data Doc.
P) Partner Implementation
1
N
UserSignUser SignaturenVarChar
6OUSR
Users
LogInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
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


Nota Fiscal CFOP 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

Users OUSR SQL Table



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