| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | TreeID | Tree ID | int | 11 | 0 | | 0 | | Allow NULL? |
| 2 | ParentID | Parent ID | int | 11 | 0 | | -1 | | Allow NULL? |
| 3 | LocType | Location Type | int | 6 | 0 | | | | Allow NULL? |
| 4 | LocCode | Location Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | TransSeq | Transaction Sequence No. | int | 11 | 0 | OIVL | | | Allow NULL? |
| 6 | LayerID | Layer ID | int | 11 | 0 | | | | Allow NULL? |
| 7 | OpenQty | Open Quantity | num | 19 | 6 | | | | Allow NULL? |
| 8 | OpenValue | Open Value | num | 19 | 6 | | | | Allow NULL? |
| 9 | ItemCode | Item Code | nvarchar | 50 | 0 | OITM | | | Allow NULL? |
| 10 | AbsEntry | Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 11 | StockActio | Stock Action Type | int | 11 | 0 | | -1 | -1=All Transactions, -2=Opening Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 58=Inventory Update, 59=Goods Receipt, 60=Goods Issue, 67=Inventory Transfer, 68=Work Instructions, 69=Landed Costs | Allow NULL? |
| 12 | RemMethod | Quantity Removal Method | char | 1 | 0 | | U | I=Issue, R=Revaluation, U=Unspecified | Allow NULL? |
