| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Abs Entry (Numerator) | int | 11 | 0 | | | | Allow NULL? |
| 2 | ReportName | Report Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 3 | RptLayout | Report Layout | char | 1 | 0 | | R | A, B, D, I, R | Allow NULL? |
| 4 | FirstPrint | First Printed No. | int | 11 | 0 | | | | Allow NULL? |
| 5 | FromDate | Date From | date | 8 | 0 | | | | |
| 6 | ToDate | Date To | date | 8 | 0 | | | | |
| 7 | TaxDate | Document Date | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 8 | RoundSum | Round Amounts | char | 1 | 0 | | N | , N, Y | Allow NULL? |
| 9 | Declration | Declaration Type | char | 1 | 0 | | O | C, O, S | Allow NULL? |
| 10 | FilterType | Selection Criteria Type | char | 1 | 0 | | N | A, B, C, E, F, N, O, R, S, T, U, V, W | Allow NULL? |
| 11 | ExcludeWT | Exclude Withholding Tax | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 12 | CustomerIn | Include Customers | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 13 | VendorIn | Include Vendors | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 14 | Period | Quarter, Year or Month | char | 1 | 0 | | Q | M, Q, S, Y | Allow NULL? |
| 15 | Quarter | Quarter | int | 11 | 0 | | | | Allow NULL? |
| 16 | Year | Year | int | 11 | 0 | | | | Allow NULL? |
| 17 | DocType | A/P or A/R | char | 1 | 0 | | P | P, R | Allow NULL? |
| 18 | CreditMemo | Credit Memos | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 19 | DocTypeIn | Include Document Type | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 20 | FirstReg | First Register Number | int | 11 | 0 | | | | Allow NULL? |
| 21 | AccountIn | Include G/L Accounts | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 22 | DeferTaxIn | Show Pmts with Deferred Tax | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 23 | ApndxOOrP | Appendix O or P Selection | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 24 | DispOBCB | Opening & Closing Balance | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 25 | FromSeries | From Tax Series Group | int | 11 | 0 | | | | Allow NULL? |
| 26 | ToSeries | To Tax Series Group | int | 11 | 0 | | | | Allow NULL? |
| 27 | canceltn | For EU Sales Report | char | 1 | 0 | | N | | Allow NULL? |
| 28 | HideNTrans | Hide Tax Codes with no Trans. | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 29 | SeriesIn | Include Series Filter | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 30 | UserCode | User Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | FromCardCo | BP Code From | nvarchar | 15 | 0 | | | | Allow NULL? |
| 32 | ToCardCo | BP Code To | nvarchar | 15 | 0 | | | | Allow NULL? |
| 33 | SizeOfStru | Size of Structure | int | 11 | 0 | | | | Allow NULL? |
| 34 | PostFrDate | Posting Date From | date | 8 | 0 | | | | |
| 35 | PostToDate | Posting Date To | date | 8 | 0 | | | | |
| 36 | DocFrDate | Document Date From | date | 8 | 0 | | | | |
| 37 | DocToDate | Document Date To | date | 8 | 0 | | | | |
| 38 | FromDoc1Nu | Document 1 - From | nvarchar | 11 | 0 | | | | Allow NULL? |
| 39 | ToDoc1Nu | Document 1 - To | nvarchar | 11 | 0 | | | | Allow NULL? |
| 40 | Serie1 | Invoice Numbering Series | nvarchar | 6 | 0 | | Y | N, Y | Allow NULL? |
| 41 | Serie1CB | Inv. Numbering Series Filter | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 42 | Doc1Type | Type of Document 1 | int | 11 | 0 | | | | Allow NULL? |
| 43 | FromDoc2Nu | Document 2 - From | nvarchar | 11 | 0 | | | | Allow NULL? |
| 44 | ToDoc2Nu | Document 2 - To | nvarchar | 11 | 0 | | | | Allow NULL? |
| 45 | Serie2 | Credit Memo Numbering Series | nvarchar | 6 | 0 | | Y | N, Y | Allow NULL? |
| 46 | Serie2CB | Corr. Inv. Rev. No. Series | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 47 | Doc2Type | Type of Document 2 | int | 11 | 0 | | | | Allow NULL? |
| 48 | FromDoc3Nu | Document 3 - From | nvarchar | 11 | 0 | | | | Allow NULL? |
| 49 | ToDoc3Nu | Document 3 - To | nvarchar | 11 | 0 | | | | Allow NULL? |
| 50 | Serie3 | Corr. Inv. Numbering Series | nvarchar | 6 | 0 | | Y | N, Y | Allow NULL? |
| 51 | Serie3CB | Corr. Inv. Num. Series Filter | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 52 | Doc3Type | Type of Document 3 | int | 11 | 0 | | | | Allow NULL? |
| 53 | FromDoc4Nu | Document 4 - From | nvarchar | 11 | 0 | | | | Allow NULL? |
| 54 | ToDoc4Nu | Document 4 - To | nvarchar | 11 | 0 | | | | Allow NULL? |
| 55 | Serie4 | Corr. Inv. Rev. No. Series | nvarchar | 6 | 0 | | Y | N, Y | Allow NULL? |
| 56 | Serie4CB | Corr. Inv. Reversal No. Series | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 57 | Doc4Type | Type of Document 4 | int | 11 | 0 | | | | Allow NULL? |
| 58 | FromDoc5Nu | Document 5 - From | nvarchar | 11 | 0 | | | | Allow NULL? |
| 59 | ToDoc5Nu | Document 5 - To | nvarchar | 11 | 0 | | | | Allow NULL? |
| 60 | Serie5 | Down Payment Numbering Series | nvarchar | 6 | 0 | | Y | N, Y | Allow NULL? |
| 61 | Serie5CB | Down Payment Numbering Series | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 62 | Doc5Type | Type of Document 5 | int | 11 | 0 | | | | Allow NULL? |
| 63 | DateRBtn | Report Period | char | 1 | 0 | | I | D, I | Allow NULL? |
| 64 | MarkDocsIn | Include Marketing Documents | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 65 | ExRate | Exchange Rate | char | 1 | 0 | | P | P, R | Allow NULL? |
| 66 | ExRateDate | Exchange Rate Date | char | 1 | 0 | | P | D, P, V | Allow NULL? |
| 67 | TrsPerioTp | Report Period Type | char | 1 | 0 | | | M, P, Q, Y | Allow NULL? |
| 68 | TrsPerioNu | Report Period Number | int | 11 | 0 | | | | Allow NULL? |
| 69 | TrsYear | Report Year | int | 6 | 0 | | | | Allow NULL? |
| 70 | TrsAdjtNum | Report Adjustment Number | int | 6 | 0 | | | | Allow NULL? |
| 71 | DateType | Date Type | char | 1 | 0 | | P | D, P, V | Allow NULL? |
| 72 | IncServDoc | Include Service Documents | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 73 | GrpBySCode | Group by Sales Code | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 74 | IncUnReDoc | Include Unreconciled Documents | char | 1 | 0 | | Y | N, Y | Allow NULL? |
