|
|
SQL Finance / Intrastat Wizard
API OISW
OISW - Intrastat Wizard Table
OISW SQL Table
Intrastat Configuration ODCI SQL Table
Employees OHEM SQL Table
Countries OCRY SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DeclDescr | Description | nVarChar | 127 | |||||
| DateFrom | Starting Date of Declaration | Date | 8 | |||||
| DateTo | Ending Date of Declaration | Date | 8 | |||||
| RunDate | Date of Run | Date | 8 | |||||
| ImpExpInd | Import Export Indicator | VarChar | I) Import E) Export | 1 | I | |||
| Status | Status | VarChar | O) Open C) Closed D) Deleted A) Archived | 1 | ||||
| MsgType | Message Type | Int | 0 9) Nil Declaration 3) Correction Declaration | 11 | 0 | |||
| TtlDocVal | Total Document Value | Num | 20 | |||||
| DocCount | Total Number of Documents | Int | 11 | |||||
| CompName | Company Name | nVarChar | 100 | |||||
| CompDeclID | Company Declaration ID | nVarChar | 32 | |||||
| CompStreet | Company Street | nVarChar | 100 | |||||
| CompCity | Company City | nVarChar | 100 | |||||
| CompZip | Company Zip Code | nVarChar | 20 | |||||
| CompCntry | Company Country | nVarChar | 3 | OCRY Countries | ||||
| DeclCntry | Declaration Country | nVarChar | 3 | OCRY Countries | ||||
| CntPersID | Contact Person ID | Int | 11 | OHEM Employees | ||||
| CntPerson | Contact Person | nVarChar | 127 | |||||
| CntEmail | Contact E-Mail | nVarChar | 100 | |||||
| CntPhone | Contact Phone | nVarChar | 20 | |||||
| CntFax | Contact Fax | nVarChar | 20 | |||||
| VATRegNo | VAT Reg. No. of Trader | nVarChar | 100 | |||||
| VATRegEx | VAT Reg. No. Extension | nVarChar | 10 | |||||
| DeclNum | Sequential Declaration Number | nVarChar | 14 | |||||
| DeclNoEx | No. of Declaration in Period | Int | 11 | |||||
| HeaderId | Header ID | Int | 11 | |||||
| DeclStat | Declaration Status | VarChar | 1 | |||||
| DeclDept | Declaring Department | Int | 6 | |||||
| DeclCurr | Declaration Currency | nVarChar | 3 | |||||
| ObligLvl | Degree of Obligation | VarChar | 1 | |||||
| TaxState | Federal State of Tax Office | nVarChar | 3 | |||||
| CustOffc | Customs Registration Office | nVarChar | 100 | |||||
| CustOffID | Customs Registration Office ID | nVarChar | 2 | |||||
| DeclSerNo | Declaration Sequence Number | nVarChar | 3 | |||||
| IntCtrlRef | Interchange Control Reference | nVarChar | 99 | |||||
| Addr1_3p | Third-Party Address Part 1 | nVarChar | 100 | |||||
| Addr2_3p | Third-Party Address Part 2 | nVarChar | 100 | |||||
| Addr3_3p | Third-Party Address Part 3 | nVarChar | 100 | |||||
| Addr4_3p | Third-Party Address Part 4 | nVarChar | 100 | |||||
| CntPers_3p | Third-Party Contact Person | nVarChar | 127 | |||||
| CntPhon_3p | Third-Party Contact Phone | nVarChar | 20 | |||||
| CntFax_3p | Third-Party Contact Fax | nVarChar | 20 | |||||
| FreeTxt1 | Free Text Line 1 | nVarChar | 70 | |||||
| FreeTxt2 | Free Text Line 2 | nVarChar | 70 | |||||
| FreeTxt3 | Free Text Line 3 | nVarChar | 70 | |||||
| FreeTxt4 | Free Text Line 4 | nVarChar | 70 | |||||
| FreeTxt5 | Free Text Line 5 | nVarChar | 70 | |||||
| ValidKey | Validation Key Identification | nVarChar | 35 | |||||
| ISDeclOffc | Intrastat Declaration Office | nVarChar | 10 | |||||
| ReleaseVer | Release Version | nVarChar | 11 | |||||
| UserSign | Created by User | Int | 6 | |||||
| PosCredVal | Positive Credit Memo Values | VarChar | Y) Yes N) No | 1 | Y | |||
| IncPrevDoc | Include Previous Documents | VarChar | Y) Yes N) No | 1 | ||||
| DeclPeriod | Declaration Period | VarChar | M) Monthly Q) Quarterly | 1 | M | |||
| Box1 | Box 1: Periodicity | Int | 0 8) First Month of Quarter 9) First and Second Months of Quarter | 6 | 0 | |||
| Box2 | Box 2: Company Activity | Int | 0 7) First Declaration 8) Stop Activity/Change of Federal Tax ID 9) First Declaration After Federal Tax ID Change | 6 | 0 | |||
| GroupData | Group Display Data | VarChar | Y) Yes N) No | 1 | Y | |||
| CstRecSt | Custom Section | nVarChar | 6 | |||||
| TaxCodeExt | Tax Code Extension | nVarChar | 99 | |||||
| ExportPath | Export Path | Text | 16 | |||||
| LLEFMAbs | EFM Template ID | Int | 11 | |||||
| SimpProc | Simplified Procedure | VarChar | Y) Yes N) No | 1 | ||||
| DspNMass | Require All Data | VarChar | Y) Yes N) No | 1 | ||||
| ExlDocQt | Exclude Docs W/ Qty Less Than | VarChar | Y) Yes N) No | 1 | ||||
| DocQtLm | Document Quantity Limit | Num | 20 | |||||
| ExlDocAm | Exclude Docs W/ Amt Less Than | VarChar | Y) Yes N) No | 1 | ||||
| DocAmLm | Document Amount Limit | Num | 20 | |||||
| RunTime | Time of Run | Int | 6 | |||||
| AddonRun | Upgraded Add-On Run | VarChar | Y) Yes N) No | 1 | N | |||
| BaseDecl | Base Declaration | Int | 11 | ODCI Intrastat Configuration | ||||
| GroupTrans | Group Transactions | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OISW.AbsEntry AS 'Internal Key',
OISW.DeclDescr AS 'Description',
OISW.DateFrom AS 'Starting Date of Declaration',
OISW.DateTo AS 'Ending Date of Declaration',
OISW.RunDate AS 'Date of Run',
OISW.ImpExpInd AS 'Import Export Indicator',
OISW.Status AS 'Status',
OISW.MsgType AS 'Message Type',
OISW.TtlDocVal AS 'Total Document Value',
OISW.DocCount AS 'Total Number of Documents',
OISW.CompName AS 'Company Name',
OISW.CompDeclID AS 'Company Declaration ID',
OISW.CompStreet AS 'Company Street',
OISW.CompCity AS 'Company City',
OISW.CompZip AS 'Company Zip Code',
OISW.CompCntry AS 'Company Country',
OISW.DeclCntry AS 'Declaration Country',
OISW.CntPersID AS 'Contact Person ID',
OISW.CntPerson AS 'Contact Person',
OISW.CntEmail AS 'Contact E-Mail',
OISW.CntPhone AS 'Contact Phone',
OISW.CntFax AS 'Contact Fax',
OISW.VATRegNo AS 'VAT Reg. No. of Trader',
OISW.VATRegEx AS 'VAT Reg. No. Extension',
OISW.DeclNum AS 'Sequential Declaration Number',
OISW.DeclNoEx AS 'No. of Declaration in Period',
OISW.HeaderId AS 'Header ID',
OISW.DeclStat AS 'Declaration Status',
OISW.DeclDept AS 'Declaring Department',
OISW.DeclCurr AS 'Declaration Currency',
OISW.ObligLvl AS 'Degree of Obligation',
OISW.TaxState AS 'Federal State of Tax Office',
OISW.CustOffc AS 'Customs Registration Office',
OISW.CustOffID AS 'Customs Registration Office ID',
OISW.DeclSerNo AS 'Declaration Sequence Number',
OISW.IntCtrlRef AS 'Interchange Control Reference',
OISW.Addr1_3p AS 'Third-Party Address Part 1',
OISW.Addr2_3p AS 'Third-Party Address Part 2',
OISW.Addr3_3p AS 'Third-Party Address Part 3',
OISW.Addr4_3p AS 'Third-Party Address Part 4',
OISW.CntPers_3p AS 'Third-Party Contact Person',
OISW.CntPhon_3p AS 'Third-Party Contact Phone',
OISW.CntFax_3p AS 'Third-Party Contact Fax',
OISW.FreeTxt1 AS 'Free Text Line 1',
OISW.FreeTxt2 AS 'Free Text Line 2',
OISW.FreeTxt3 AS 'Free Text Line 3',
OISW.FreeTxt4 AS 'Free Text Line 4',
OISW.FreeTxt5 AS 'Free Text Line 5',
OISW.ValidKey AS 'Validation Key Identification',
OISW.ISDeclOffc AS 'Intrastat Declaration Office',
OISW.ReleaseVer AS 'Release Version',
OISW.UserSign AS 'Created by User',
OISW.PosCredVal AS 'Positive Credit Memo Values',
OISW.IncPrevDoc AS 'Include Previous Documents',
OISW.DeclPeriod AS 'Declaration Period',
OISW.Box1 AS 'Box 1: Periodicity',
OISW.Box2 AS 'Box 2: Company Activity',
OISW.GroupData AS 'Group Display Data',
OISW.CstRecSt AS 'Custom Section',
OISW.TaxCodeExt AS 'Tax Code Extension',
OISW.ExportPath AS 'Export Path',
OISW.LLEFMAbs AS 'EFM Template ID',
OISW.SimpProc AS 'Simplified Procedure',
OISW.DspNMass AS 'Require All Data',
OISW.ExlDocQt AS 'Exclude Docs W/ Qty Less Than',
OISW.DocQtLm AS 'Document Quantity Limit',
OISW.ExlDocAm AS 'Exclude Docs W/ Amt Less Than',
OISW.DocAmLm AS 'Document Amount Limit',
OISW.RunTime AS 'Time of Run',
OISW.AddonRun AS 'Upgraded Add-On Run',
OISW.BaseDecl AS 'Base Declaration',
OISW.GroupTrans AS 'Group Transactions'
FROM OISW AS OISW
Related information
OISW SQL Table
Intrastat Configuration ODCI SQL Table
Employees OHEM SQL Table
Countries OCRY SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
