| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ExpnsCode | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | ExpnsName | Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | RevAcct | Revenue Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 4 | ExpnsAcct | Expense Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 5 | TaxLiable | Tax Liable | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | RevFixSum | Fixed Amount - Revenues | num | 19 | 6 | | | | Allow NULL? |
| 7 | ExpFixSum | Fixed Amount - Expenses | num | 19 | 6 | | | | Allow NULL? |
| 8 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Incr., D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | VatGroupI | Output Tax Group | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 11 | VatGroupO | Input Tax Group | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 12 | DistrbMthd | Distribution Method | char | 1 | 0 | | N | E=Equally, N=None, Q=Quantity, T=Row Total, V=Volume, W=Weight | Allow NULL? |
| 13 | In1099 | Include in 1099 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | ExpOfstAct | Freight Clearing Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 15 | WTLiable | WTax Liable | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | BaseMethod | Drawing Method | char | 1 | 0 | | T | A=All, N=None, Q=Quantity, T=Total | Allow NULL? |
| 17 | Stock | Stock | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | LstPchPrce | Last Purchase Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 19 | SalseRpt | Sales Analysis Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | PchRpt | Purchase Analysis Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | RevExmAcct | Revenues Exempted Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 22 | ExpnsExAct | Expense Exempted Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 23 | RevRetAct | Revenue Returns Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | ExpnsType | Freight Type | char | 1 | 0 | | | 1=Shipping, 2=Insurance, 3=Other | Allow NULL? |
| 25 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 26 | TaxDisMthd | Tax Distribution Method | char | 1 | 0 | | N | E=Equally, N=None, Q=Quantity, T=Row Total, V=Volume, W=Weight | Allow NULL? |
| 27 | OcrCode2 | Distribution Rule 2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 28 | OcrCode3 | Distribution Rule 3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 29 | OcrCode4 | Distribution Rule 4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 30 | OcrCode5 | Distribution Rule 5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 31 | OcrCodeX | Distribution Rule X | nvarchar | 100 | 0 | OOCR | | | Allow NULL? |
| 32 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 33 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 34 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 35 | Project | Project | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 36 | Intrastat | Intrastat Relevant | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | GrsFreight | Gross Freight | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 38 | SacCode | SAC Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | FreighType | Freight Type | char | 1 | 0 | | S | B=Bollo, S=Standard | Allow NULL? |
