📚 SAP Business One SDK Help

Table Name: OEFDW

Table Description: EFD Wizard

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
RunName Wizard Run Name nVarChar 100 -      
RunDate Wizard Run Date Date 8 -      
RunTime Wizard Run Time Int 6 -      
Status Status VarChar 1 -   S Saved
            E Executed
UserSign User Signature Int 11 OUSR      
DateFrom Date From Date 8 -      
DateTo Date To Date 8 -      
Branch Branch Int 11 OUBR -2    
ProfType Profile Type nVarChar 2 -      
BlockC Block C VarChar 1 - Y Y Yes
            N No
BlockD Block D VarChar 1 - Y Y Yes
            N No
BlockE Block E VarChar 1 - Y Y Yes
            N No
BlockH Block H VarChar 1 - Y Y Yes
            N No
BlockG Block G VarChar 1 - Y Y Yes
            N No
BlockI Block I VarChar 1 - Y Y Yes
            N No
FlPurCode File Purpose Code VarChar 1 -   0 Remessa do arquivo original
            1 Remessa do arquivo substituto
AccEmploye Accountant Employee Int 11 OCRD      
AccExtern Accountant External nVarChar 15 OHEM      
ItmFrom From Item nVarChar 50 -      
ItmTo To Item nVarChar 50 -      
ItmGroup Item Group Int 6 -      
ItQryGroup Item Properties nVarChar 250 -      
RptReason Reporting Reason nVarChar 2 - 01 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
Key Unique Field
PRIMARY Yes AbsEntry