|
|
SQL Reports / EFD Wizard
API OEFDW
OEFDW - EFD Wizard Table
Business Partner OCRD SQL Table
Employees OHEM SQL Table
Branches OUBR SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RunName | Wizard Run Name | nVarChar | 100 | |||||
| RunDate | Wizard Run Date | Date | 8 | |||||
| RunTime | Wizard Run Time | Int | 6 | |||||
| Status | Status | VarChar | S) Saved E) Executed | 1 | ||||
| UserSign | User Signature | Int | 11 | OUSR Users | ||||
| DateFrom | Date From | Date | 8 | |||||
| DateTo | Date To | Date | 8 | |||||
| Branch | Branch | Int | 11 | OUBR Branches | -2 | |||
| ProfType | Profile Type | nVarChar | 2 | |||||
| BlockC | Block C | VarChar | Y) Yes N) No | 1 | Y | |||
| BlockD | Block D | VarChar | Y) Yes N) No | 1 | Y | |||
| BlockE | Block E | VarChar | Y) Yes N) No | 1 | Y | |||
| BlockH | Block H | VarChar | Y) Yes N) No | 1 | Y | |||
| BlockG | Block G | VarChar | Y) Yes N) No | 1 | Y | |||
| BlockI | Block I | VarChar | Y) Yes N) No | 1 | Y | |||
| FlPurCode | File Purpose Code | VarChar | 0 1) Remessa do arquivo substituto | 1 | ||||
| AccEmploye | Accountant Employee | Int | 11 | OCRD Business Partner | ||||
| AccExtern | Accountant External | nVarChar | 15 | OHEM Employees | ||||
| ItmFrom | From Item | nVarChar | 20 | |||||
| ItmTo | To Item | nVarChar | 20 | |||||
| ItmGroup | Item Group | Int | 6 | |||||
| ItQryGroup | Item Properties | nVarChar | 127 | |||||
| RptReason | Reporting Reason | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
