biuan SAP® BUSINESS ONE SDK
API OEFDW
OEFDW - EFD Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
RunNameWizard Run NamenVarChar
100
RunDateWizard Run DateDate
8
RunTimeWizard Run TimeInt
6
StatusStatusVarChar
S) Saved
E) Executed
1
UserSignUser SignatureInt
11OUSR
Users
DateFromDate FromDate
8
DateToDate ToDate
8
BranchBranchInt
11OUBR
Branches
-2
ProfTypeProfile TypenVarChar
2
BlockCBlock CVarChar
Y) Yes
N) No
1
Y
BlockDBlock DVarChar
Y) Yes
N) No
1
Y
BlockEBlock EVarChar
Y) Yes
N) No
1
Y
BlockHBlock HVarChar
Y) Yes
N) No
1
Y
BlockGBlock GVarChar
Y) Yes
N) No
1
Y
BlockIBlock IVarChar
Y) Yes
N) No
1
Y
FlPurCodeFile Purpose CodeVarChar
0
1) Remessa do arquivo substituto
1
AccEmployeAccountant EmployeeInt
11OCRD
Business Partner
AccExternAccountant ExternalnVarChar
15OHEM
Employees
ItmFromFrom ItemnVarChar
20
ItmToTo ItemnVarChar
20
ItmGroupItem GroupInt
6
ItQryGroupItem PropertiesnVarChar
127
RptReasonReporting ReasonnVarChar
01) No final no período
02) Na mudança de forma de tributação da mercadoria (ICMS)
03) Na solicitação da baixa cadastral, paralisação temporária e outras situações
04) Na alteração de regime de pagamento ? condição do contribuinte
05) Por determinação dos fiscos
2
01

Table relationship map

SELECT statement

SELECT OEFDW.AbsEntry AS 'Internal Number', OEFDW.RunName AS 'Wizard Run Name', OEFDW.RunDate AS 'Wizard Run Date', OEFDW.RunTime AS 'Wizard Run Time', OEFDW.Status AS 'Status', OEFDW.UserSign AS 'User Signature', OEFDW.DateFrom AS 'Date From', OEFDW.DateTo AS 'Date To', OEFDW.Branch AS 'Branch', OEFDW.ProfType AS 'Profile Type', OEFDW.BlockC AS 'Block C', OEFDW.BlockD AS 'Block D', OEFDW.BlockE AS 'Block E', OEFDW.BlockH AS 'Block H', OEFDW.BlockG AS 'Block G', OEFDW.BlockI AS 'Block I', OEFDW.FlPurCode AS 'File Purpose Code', OEFDW.AccEmploye AS 'Accountant Employee', OEFDW.AccExtern AS 'Accountant External', OEFDW.ItmFrom AS 'From Item', OEFDW.ItmTo AS 'To Item', OEFDW.ItmGroup AS 'Item Group', OEFDW.ItQryGroup AS 'Item Properties', OEFDW.RptReason AS 'Reporting Reason' FROM OEFDW AS OEFDW

Related information


Business Partner OCRD SQL Table

Employees OHEM SQL Table

Branches OUBR 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates