| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Key | int | 11 | 0 | | | | Allow NULL? |
| 2 | DeclDescr | Description | nvarchar | 200 | 0 | | | | Allow NULL? |
| 3 | DateFrom | Starting Date of Declaration | date | 8 | 0 | | | | |
| 4 | DateTo | Ending Date of Declaration | date | 8 | 0 | | | | |
| 5 | RunDate | Date of Run | date | 8 | 0 | | | | |
| 6 | ImpExpInd | Import Export Indicator | char | 1 | 0 | | I | E=Export, I=Import | Allow NULL? |
| 7 | Status | Status | char | 1 | 0 | | | A=Archived, C=Closed, D=Deleted, O=Open | Allow NULL? |
| 8 | MsgType | Message Type | int | 11 | 0 | | 0 | 0=New Declaration, 3=Correction Declaration, 9=Nil Declaration | Allow NULL? |
| 9 | TtlDocVal | Total Document Value | num | 19 | 6 | | | | Allow NULL? |
| 10 | DocCount | Total Number of Documents | int | 11 | 0 | | | | Allow NULL? |
| 11 | CompName | Company Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 12 | CompDeclID | Company Declaration ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 13 | CompStreet | Company Street | nvarchar | 100 | 0 | | | | Allow NULL? |
| 14 | CompCity | Company City | nvarchar | 100 | 0 | | | | Allow NULL? |
| 15 | CompZip | Company Zip Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | CompCntry | Company Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 17 | DeclCntry | Declaration Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 18 | CntPersID | Contact Person ID | int | 11 | 0 | OHEM | | | Allow NULL? |
| 19 | CntPerson | Contact Person | nvarchar | 250 | 0 | | | | Allow NULL? |
| 20 | CntEmail | Contact E-Mail | nvarchar | 100 | 0 | | | | Allow NULL? |
| 21 | CntPhone | Contact Phone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | CntFax | Contact Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | VATRegNo | VAT Reg. No. of Trader | nvarchar | 100 | 0 | | | | Allow NULL? |
| 24 | VATRegEx | VAT Reg. No. Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | DeclNum | Sequential Declaration Number | nvarchar | 14 | 0 | | | | Allow NULL? |
| 26 | DeclNoEx | No. of Declaration in Period | int | 11 | 0 | | | | Allow NULL? |
| 27 | HeaderId | Header ID | int | 11 | 0 | | | | Allow NULL? |
| 28 | DeclStat | Declaration Status | char | 1 | 0 | | | | Allow NULL? |
| 29 | DeclDept | Declaring Department | int | 6 | 0 | | | | Allow NULL? |
| 30 | DeclCurr | Declaration Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | ObligLvl | Degree of Obligation | char | 1 | 0 | | | | Allow NULL? |
| 32 | TaxState | Federal State of Tax Office | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | CustOffc | Customs Registration Office | nvarchar | 100 | 0 | | | | Allow NULL? |
| 34 | CustOffID | Customs Registration Office ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | DeclSerNo | Declaration Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | IntCtrlRef | Interchange Control Reference | nvarchar | 99 | 0 | | | | Allow NULL? |
| 37 | Addr1_3p | Third-Party Address Part 1 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 38 | Addr2_3p | Third-Party Address Part 2 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 39 | Addr3_3p | Third-Party Address Part 3 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 40 | Addr4_3p | Third-Party Address Part 4 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 41 | CntPers_3p | Third-Party Contact Person | nvarchar | 250 | 0 | | | | Allow NULL? |
| 42 | CntPhon_3p | Third-Party Contact Phone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 43 | CntFax_3p | Third-Party Contact Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 44 | FreeTxt1 | Free Text Line 1 | nvarchar | 70 | 0 | | | | Allow NULL? |
| 45 | FreeTxt2 | Free Text Line 2 | nvarchar | 70 | 0 | | | | Allow NULL? |
| 46 | FreeTxt3 | Free Text Line 3 | nvarchar | 70 | 0 | | | | Allow NULL? |
| 47 | FreeTxt4 | Free Text Line 4 | nvarchar | 70 | 0 | | | | Allow NULL? |
| 48 | FreeTxt5 | Free Text Line 5 | nvarchar | 70 | 0 | | | | Allow NULL? |
| 49 | ValidKey | Validation Key Identification | nvarchar | 35 | 0 | | | | Allow NULL? |
| 50 | ISDeclOffc | Intrastat Declaration Office | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | ReleaseVer | Release Version | nvarchar | 11 | 0 | | | | Allow NULL? |
| 52 | UserSign | Created by User | int | 6 | 0 | | | | Allow NULL? |
| 53 | PosCredVal | Positive Credit Memo Values | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 54 | IncPrevDoc | Include Previous Documents | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 55 | DeclPeriod | Declaration Period | char | 1 | 0 | | M | M=Monthly, Q=Quarterly | Allow NULL? |
| 56 | Box1 | Box 1: Periodicity | int | 6 | 0 | | 0 | 0=None of the Other Cases, 8=First Month of Quarter, 9=First and Second Months of Quarter | Allow NULL? |
| 57 | Box2 | Box 2: Company Activity | int | 6 | 0 | | 0 | 0=None of the Other Cases, 7=First Declaration, 8=Stop Activity/Change of Federal Tax ID, 9=First Declaration After Federal Tax ID Change | Allow NULL? |
| 58 | GroupData | Group Display Data | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 59 | CstRecSt | Custom Section | nvarchar | 6 | 0 | | | | Allow NULL? |
| 60 | TaxCodeExt | Tax Code Extension | nvarchar | 99 | 0 | | | | Allow NULL? |
| 61 | ExportPath | Export Path | text | 16 | 0 | | | | |
| 62 | LLEFMAbs | EFM Template ID | int | 11 | 0 | | | | Allow NULL? |
| 63 | SimpProc | Simplified Procedure | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 64 | DspNMass | Require All Data | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 65 | ExlDocQt | Exclude Docs W/ Qty Less Than | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 66 | DocQtLm | Document Quantity Limit | num | 19 | 6 | | | | Allow NULL? |
| 67 | ExlDocAm | Exclude Docs W/ Amt Less Than | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 68 | DocAmLm | Document Amount Limit | num | 19 | 6 | | | | Allow NULL? |
| 69 | RunTime | Time of Run | int | 6 | 0 | | | | Allow NULL? |
| 70 | AddonRun | Upgraded Add-On Run | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 71 | BaseDecl | Base Declaration | int | 11 | 0 | ODCI | | | Allow NULL? |
| 72 | GroupTrans | Group Transactions | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
