| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | Id | Primary Key | int | 11 | 0 | | | | Allow NULL? |
| 2 | ResCode | Internal Resource ID | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | WhsCode | Warehouse Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | CapDate | Capacity Date | date | 8 | 0 | | | | |
| 5 | CapType | Type of Capacity Entry | char | 1 | 0 | | | C=Committed, I=Internal, O=Ordered, U=Consumed | Allow NULL? |
| 6 | Capacity | Capacity | num | 19 | 6 | | | | Allow NULL? |
| 7 | SrcObjType | Source Object Type | int | 11 | 0 | | | 202=Production Order, 59=Receipt from Production, 60=Issue for Production | Allow NULL? |
| 8 | SrcAbsEnt | Source Absolute Entry | int | 11 | 0 | | | | Allow NULL? |
| 9 | SrcLine | Source Line Number | int | 11 | 0 | | | | Allow NULL? |
| 10 | BaseObjTyp | Base Object Type | int | 11 | 0 | | | 202=Production Order | Allow NULL? |
| 11 | BaseAbsEnt | Base Absolute Entry | int | 11 | 0 | | | | Allow NULL? |
| 12 | BaseLine | Base Line Number | int | 11 | 0 | | | | Allow NULL? |
| 13 | ActionType | Action Type | int | 6 | 0 | | | 1=Production Order - Create, 2=Production Order - Close, 3=Production Order - Reschedule, 4=Production Order - Add Line, 5=Production Order - Delete Line, 6=Production Order - Update Line, 7=Issue for Production - Create, 8=Receipt from Production - Create | Allow NULL? |
| 14 | OwnObjTyp | Owning Doc. Object Type | int | 11 | 0 | | | 202=Production Order, 59=Receipt from Production, 60=Issue for Production | Allow NULL? |
| 15 | OwnAbsEnt | Owning Doc. Absolute Entry | int | 11 | 0 | | | | Allow NULL? |
| 16 | OwnLine | Owning Doc. Line Number | int | 11 | 0 | | | | Allow NULL? |
| 17 | RevdObjTyp | Reverted Object Type | int | 11 | 0 | | | 60=Issue for Production | Allow NULL? |
| 18 | RevdAbsEnt | Reverted Absolute Entry | int | 11 | 0 | | | | Allow NULL? |
| 19 | RevdLine | Reverted Line Number | int | 11 | 0 | | | | Allow NULL? |
| 20 | MemoSrc | Memo Source | char | 1 | 0 | | | C=Resource Capacity Form, S=Set Daily Internal Capacities Form | Allow NULL? |
| 21 | Memo | Memo | text | 16 | 0 | | | | |