| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Document Internal Number | int | 11 | 0 | OWOR | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | ItemCode | Item No. | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | BaseQty | Base Quantity | num | 19 | 6 | | | | Allow NULL? |
| 5 | PlannedQty | Planned Quantity - Rows | num | 19 | 6 | | | | Allow NULL? |
| 6 | IssuedQty | Issued Quantity | num | 19 | 6 | | | | Allow NULL? |
| 7 | IssueType | Production Order Issue Type | char | 1 | 0 | | | B=Backflush, M=Manual | Allow NULL? |
| 8 | wareHouse | Warehouse | nvarchar | 8 | 0 | OWHS | | | Allow NULL? |
| 9 | VisOrder | Visual Order | int | 11 | 0 | | | | Allow NULL? |
| 10 | WipActCode | WIP Account Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 11 | CompTotal | Total Completed Sum | num | 19 | 6 | | | | Allow NULL? |
| 12 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 13 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 14 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 15 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 16 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 17 | LocCode | Location Code | int | 11 | 0 | OLCT | | | Allow NULL? |
| 18 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 19 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 20 | UomEntry | UoM Entry | int | 11 | 0 | OUOM | 0 | | Allow NULL? |
| 21 | UomCode | UoM Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | ItemType | Item Type | int | 11 | 0 | | 4 | -18=Text, 290=Resource, 4=Item | Allow NULL? |
| 23 | AdditQty | Additional Quantity | num | 19 | 6 | | | | Allow NULL? |
| 24 | LineText | Row Text | text | 16 | 0 | | | | |
| 25 | PickStatus | Pick Status | char | 1 | 0 | | N | N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked | Allow NULL? |
| 26 | PickQty | Pick Quantity | num | 19 | 6 | | | | Allow NULL? |
| 27 | PickIdNo | Pick List ID Number | int | 11 | 0 | | | | Allow NULL? |
| 28 | ReleaseQty | Released Quantity | num | 19 | 6 | | | | Allow NULL? |
| 29 | ResAlloc | Resource Allocation | char | 1 | 0 | | | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date | Allow NULL? |
| 30 | StartDate | Start Date | date | 8 | 0 | | | | |
| 31 | EndDate | End Date | date | 8 | 0 | | | | |
| 32 | StageId | Stage ID | int | 11 | 0 | | | | Allow NULL? |
| 33 | BaseQtyNum | Base Quantity Numerator | num | 19 | 6 | | | | Allow NULL? |
| 34 | BaseQtyDen | Base Quantity Denominator | num | 19 | 6 | | | | Allow NULL? |
| 35 | ReqDays | Required Days | num | 19 | 6 | | 0 | | Allow NULL? |
| 36 | RtCalcProp | Routing Calculation Proportion | num | 19 | 6 | | 100 | | Allow NULL? |
| 37 | Status | Stage Status | char | 1 | 0 | | P | C=Complete, I=In Progress, P=Planned | Allow NULL? |
