| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BaseEntry | Base Document Internal ID | Int | 11 | - | |||
| LineNum | Row Number | Int | 11 | - | |||
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| DocType | Document Type | VarChar | 1 | - | I | I | Invoice |
| P | Payment | ||||||
| J | Journal Entry | ||||||
| C | Correction Invoice | ||||||
| R | Payment Request | ||||||
| L | Landed Cost | ||||||
| RefEntry1 | Ref.1 Document Key | Int | 11 | - | |||
| RefEntry2 | Ref. 2 Document Key | Int | 11 | - | |||
| ObjType | Object Type | Int | 6 | ADP1 | |||
| LogInstanc | Log Instance | Int | 11 | - | 0 | ||
| RefType | Ref. Object Type | Int | 11 | - | -1 | -1 | |
| 13 | A/R Invoice | ||||||
| 18 | A/P Invoice | ||||||
| 30 | Journal Entry | ||||||
| 24 | Incoming Payment | ||||||
| 204 | A/P Down Payment | ||||||
| 165 | A/R Correction Invoice | ||||||
| 163 | A/P Correction Invoice | ||||||
| 69 | Landed Cost | ||||||
| EncryptIV | Encrypt IV | nVarChar | 100 | - | |||
| Key | Unique | Field |
| PRIMARY | Yes | BaseEntry |
| LineNum |