| 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 | 50 | 0 | ORSC | | | Allow NULL? |
| 3 | WhsCode | Warehouse Code | nvarchar | 8 | 0 | OWHS | | | Allow NULL? |
| 4 | CapDate | Capacity Date | date | 8 | 0 | | | | |
| 5 | CapType | Type of Capacity Entry | char | 1 | 0 | | I | 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 | | -1 | -1, -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 202=Production Order, 20=Goods Receipt PO, 2 | 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 | | -1 | -1, 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 | -1, 10=Sales Order - Close, 11=Sales Order - Cancel, 12=Sales Order - Add Line, 13=Sales Order - Delete Line, 14=Sales Order - Update Line, 15=Delivery - Create, 16=Delivery - Close, 17=Delivery - Cancel, 18=A/R Invoice - Create, 19=A/R Invoice - Cancel, 1=Production Order - Create, 20=A/R Credit Memo - Create, 21=A/R Credit Memo - Cancel, | Allow NULL? |
| 14 | OwnObjTyp | Owning Doc. Object Type | int | 11 | 0 | | -1 | -1, -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 202=Production Order, 20=Goods Receipt PO, 2 | 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 | | -1 | -1, 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 | | | | |
| 22 | SngRunCap | Single Run Capacity | num | 19 | 6 | | | | Allow NULL? |
| 23 | MemoSrcSng | Memo Source of Single Run Capacity | char | 1 | 0 | | - | -, C=Resource Capacity Form, S=Set Daily Internal Capacities Form | Allow NULL? |
| 24 | MemoSng | Memo of Single Run Capacity | text | 16 | 0 | | | | |
