| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | ReportType | Report Type | int | 11 | 0 | | | 1=347, 2=349, 3=WT, 4=O & P, 5=Annual List, 6=Tax Report | Allow NULL? |
| 2 | DocType | Document Type | nvarchar | 20 | 0 | | | 13=Invoice, 14=Revert Invoice, 18=Purchase, 19=Revert purchase, 203=A/R Down Payment, 204=A/P Down Payment | Allow NULL? |
| 3 | DocEntry | Document Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 4 | LineNum | Row No. | int | 11 | 0 | | | | Allow NULL? |
| 5 | TaxCode | Tax Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | OrdinalNum | Ordinal Num (BTF & Cancelled) | int | 11 | 0 | | -1 | | Allow NULL? |