| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Document Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | ObjType | Object Type | nvarchar | 20 | 0 | | 202 | | Allow NULL? |
| 3 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 4 | LineNum | Line Number | int | 11 | 0 | | | | Allow NULL? |
| 5 | RefDocEntr | Referenced Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | RefDocNum | Referenced Document Number | int | 11 | 0 | | | | Allow NULL? |
| 7 | ExtDocNum | External Referenced Document Number | nvarchar | 100 | 0 | | | | Allow NULL? |
| 8 | RefObjType | Referenced Object Type | nvarchar | 20 | 0 | | | -1=External Document, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery Notes, 163=A/P Correction Invoice, 165=A/R Correction Invoice, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 202=Production Order, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 234000031=Re | Allow NULL? |
| 9 | IssueDate | Date of Issue | date | 8 | 0 | | | | |
| 10 | Remark | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
