| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ExpnsCode | Internal Number | Int | 11 | - | |||
| ExpnsName | Name | nVarChar | 20 | - | |||
| RevAcct | Revenue Account | nVarChar | 15 | OACT | |||
| ExpnsAcct | Expense Account | nVarChar | 15 | OACT | |||
| TaxLiable | Tax Liable | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| RevFixSum | Fixed Amount - Revenues | Num | 19.6 | - | |||
| ExpFixSum | Fixed Amount - Expenses | Num | 19.6 | - | |||
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| I | Interface | ||||||
| U | Upgrade | ||||||
| M | Import | ||||||
| O | DI API | ||||||
| S | Service Layer | ||||||
| W | Web Client | ||||||
| A | Auto Incr. | ||||||
| D | Restore Wizard | ||||||
| P | Partner Implementation | ||||||
| T | Year Transfer | ||||||
| UserSign | User Signature | Int | 6 | OUSR | |||
| VatGroupI | Output Tax Group | nVarChar | 8 | OVTG | |||
| VatGroupO | Input Tax Group | nVarChar | 8 | OVTG | |||
| DistrbMthd | Distribution Method | VarChar | 1 | - | N | N | None |
| Q | Quantity | ||||||
| V | Volume | ||||||
| W | Weight | ||||||
| E | Equally | ||||||
| T | Row Total | ||||||
| In1099 | Include in 1099 | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| ExpOfstAct | Freight Clearing Account | nVarChar | 15 | OACT | |||
| WTLiable | WTax Liable | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| BaseMethod | Drawing Method | VarChar | 1 | - | T | N | None |
| Q | Quantity | ||||||
| T | Total | ||||||
| A | All | ||||||
| Stock | Stock | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| LstPchPrce | Last Purchase Price | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| SalseRpt | Sales Analysis Report | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| PchRpt | Purchase Analysis Report | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| RevExmAcct | Revenues Exempted Account | nVarChar | 15 | OACT | |||
| ExpnsExAct | Expense Exempted Account | nVarChar | 15 | OACT | |||
| RevRetAct | Revenue Returns Account | nVarChar | 15 | - | |||
| ExpnsType | Freight Type | VarChar | 1 | - | 1 | 1 | Shipping |
| 2 | Insurance | ||||||
| 3 | Other | ||||||
| 4 | Special | ||||||
| OcrCode | Distr. Rule | nVarChar | 8 | OOCR | |||
| TaxDisMthd | Tax Distribution Method | VarChar | 1 | - | N | N | None |
| Q | Quantity | ||||||
| V | Volume | ||||||
| W | Weight | ||||||
| E | Equally | ||||||
| T | Row Total | ||||||
| OcrCode2 | Distr. Rule2 | nVarChar | 8 | OOCR | |||
| OcrCode3 | Distr. Rule3 | nVarChar | 8 | OOCR | |||
| OcrCode4 | Distr. Rule4 | nVarChar | 8 | OOCR | |||
| OcrCode5 | Distr. Rule5 | nVarChar | 8 | OOCR | |||
| OcrCodeX | Distr. Rule | nVarChar | 100 | OOCR | |||
| LogInstanc | Log Instance | Int | 11 | - | 0 | ||
| UpdateDate | Date of Update | Date | 8 | - | |||
| UserSign2 | Updating User | Int | 6 | OUSR | |||
| Project | Project | nVarChar | 20 | OPRJ | |||
| Intrastat | Intrastat Relevant | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| GrsFreight | Gross Freight | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| SacCode | SAC Code | nVarChar | 8 | - | |||
| FreighType | Freight Type | VarChar | 1 | - | S | S | Standard |
| B | Bollo | ||||||
| DataVers | Data Version | Int | 11 | - | 1 | ||
| DocFreight | Document Operation Freight | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| ProdctType | SAF-T Product Type | VarChar | 1 | - | S | P | Products |
| S | Services | ||||||
| O | Other | ||||||
| I | Taxes | ||||||
| ProdTypeEx | SAF-T Product Type | nVarChar | 10 | OSPT | S | ||
| Key | Unique | Field |
| PRIMARY | Yes | ExpnsCode |
| NAME | Yes | ExpnsName |