| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Document Internal ID | int | 11 | 0 | OPCH | | | Allow NULL? |
| 2 | ExpnsCode | Freight Code | int | 11 | 0 | OEXD | | | Allow NULL? |
| 3 | TotalLC | Total | num | 19 | 6 | | | | Allow NULL? |
| 4 | TotalFC | Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 5 | TotalSC | Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 6 | DistribM | Distribution Method | char | 1 | 0 | | T | E=Equally, Q=Quantity, T=Row Total, V=Volume, W=Weight | Allow NULL? |
| 7 | DrawnLC | Drawn Total | num | 19 | 6 | | | | Allow NULL? |
| 8 | DrawnFC | Drawn Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 9 | DrawnSC | Drawn Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 10 | LineNum | Line Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 11 | BaseAbsEnt | Base Abs. Entry | int | 11 | 0 | | -1 | | Allow NULL? |
| 12 | BaseType | Base Document Type | int | 11 | 0 | | -1 | -1, 0, 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation | Allow NULL? |
| 13 | BaseRef | Base Document Reference | int | 11 | 0 | | | | Allow NULL? |
| 14 | BaseLnNum | Base Document Row No. | int | 11 | 0 | | -1 | | Allow NULL? |
| 15 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 16 | ObjectType | Object Type | nvarchar | 20 | 0 | ADP1 | 18 | | Allow NULL? |
| 17 | FixCurr | Fixation Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
