| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Id |
Primary Key |
Int |
11 |
- |
|
|
|
| ResCode |
Internal Resource ID |
nVarChar |
50 |
ORSC |
|
|
|
| WhsCode |
Warehouse Code |
nVarChar |
8 |
OWHS |
|
|
|
| CapDate |
Capacity Date |
Date |
8 |
- |
|
|
|
| CapType |
Type of Capacity Entry |
VarChar |
1 |
- |
I |
I |
Internal |
| |
|
|
|
|
|
O |
Ordered |
| |
|
|
|
|
|
C |
Committed |
| |
|
|
|
|
|
U |
Consumed |
| Capacity |
Capacity |
Num |
19.6 |
- |
|
|
|
| SrcObjType |
Source Object Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
202 |
Production Order |
| |
|
|
|
|
|
60 |
Issue for Production |
| |
|
|
|
|
|
59 |
Receipt from Production |
| |
|
|
|
|
|
17 |
Sales Order |
| |
|
|
|
|
|
15 |
Delivery |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
-13 |
A/R Reserve Invoice |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
16 |
Returns |
| |
|
|
|
|
|
22 |
Purchase Order |
| |
|
|
|
|
|
20 |
Goods Receipt PO |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
-18 |
A/P Reserve Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
21 |
Goods Return |
| SrcAbsEnt |
Source Absolute Entry |
Int |
11 |
- |
|
|
|
| SrcLine |
Source Line Number |
Int |
11 |
- |
|
|
|
| BaseObjTyp |
Base Object Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
202 |
Production Order |
| BaseAbsEnt |
Base Absolute Entry |
Int |
11 |
- |
|
|
|
| BaseLine |
Base Line Number |
Int |
11 |
- |
|
|
|
| ActionType |
Action Type |
Int |
6 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
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 |
| |
|
|
|
|
|
9 |
Sales Order - Create |
| |
|
|
|
|
|
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 |
| |
|
|
|
|
|
20 |
A/R Credit Memo - Create |
| |
|
|
|
|
|
21 |
A/R Credit Memo - Cancel |
| |
|
|
|
|
|
22 |
Correction A/R Invoice - Create |
| |
|
|
|
|
|
23 |
Correction A/R Invoice Reversal - Create |
| |
|
|
|
|
|
24 |
Returns - Create |
| |
|
|
|
|
|
25 |
Returns - Cancel |
| |
|
|
|
|
|
26 |
Returns - Close |
| |
|
|
|
|
|
27 |
Purchase Order - Create |
| |
|
|
|
|
|
28 |
Purchase Order - Close |
| |
|
|
|
|
|
29 |
Purchase Order - Cancel |
| |
|
|
|
|
|
30 |
Purchase Order - Add Line |
| |
|
|
|
|
|
31 |
Purchase Order - Delete Line |
| |
|
|
|
|
|
32 |
Purchase Order - Update Line |
| |
|
|
|
|
|
33 |
Goods Receipt PO - Create |
| |
|
|
|
|
|
34 |
Goods Receipt PO - Close |
| |
|
|
|
|
|
35 |
Goods Receipt PO - Cancel |
| |
|
|
|
|
|
36 |
A/P Invoice - Create |
| |
|
|
|
|
|
37 |
A/P Invoice - Cancel |
| |
|
|
|
|
|
38 |
A/P Credit Memo - Create |
| |
|
|
|
|
|
39 |
A/P Credit Memo - Cancel |
| |
|
|
|
|
|
40 |
Correction A/P Invoice - Create |
| |
|
|
|
|
|
41 |
Correction A/P Invoice Reversal - Create |
| |
|
|
|
|
|
42 |
Goods Return - Create |
| |
|
|
|
|
|
43 |
Goods Return - Cancel |
| |
|
|
|
|
|
44 |
Goods Return - Close |
| |
|
|
|
|
|
45 |
A/R Invoice - Update |
| |
|
|
|
|
|
46 |
A/P Invoice - Update |
| |
|
|
|
|
|
47 |
A/R Reserve Invoice - Create |
| |
|
|
|
|
|
48 |
A/R Reserve Invoice - Update |
| |
|
|
|
|
|
49 |
A/R Reserve Invoice - Cancel |
| |
|
|
|
|
|
50 |
A/P Reserve Invoice - Create |
| |
|
|
|
|
|
51 |
A/P Reserve Invoice - Update |
| |
|
|
|
|
|
52 |
A/P Reserve Invoice - Cancel |
| OwnObjTyp |
Owning Doc. Object Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
202 |
Production Order |
| |
|
|
|
|
|
60 |
Issue for Production |
| |
|
|
|
|
|
59 |
Receipt from Production |
| |
|
|
|
|
|
17 |
Sales Order |
| |
|
|
|
|
|
15 |
Delivery |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
-13 |
A/R Reserve Invoice |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
16 |
Returns |
| |
|
|
|
|
|
22 |
Purchase Order |
| |
|
|
|
|
|
20 |
Goods Receipt PO |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
-18 |
A/P Reserve Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
21 |
Goods Return |
| OwnAbsEnt |
Owning Doc. Absolute Entry |
Int |
11 |
- |
|
|
|
| OwnLine |
Owning Doc. Line Number |
Int |
11 |
- |
|
|
|
| RevdObjTyp |
Reverted Object Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
60 |
Issue for Production |
| RevdAbsEnt |
Reverted Absolute Entry |
Int |
11 |
- |
|
|
|
| RevdLine |
Reverted Line Number |
Int |
11 |
- |
|
|
|
| MemoSrc |
Memo Source |
VarChar |
1 |
- |
- |
- |
|
| |
|
|
|
|
|
C |
Resource Capacity Form |
| |
|
|
|
|
|
S |
Set Daily Internal Capacities Form |
| Memo |
Memo |
Text |
16 |
- |
|
|
|
| SngRunCap |
Single Run Capacity |
Num |
19.6 |
- |
|
|
|
| MemoSrcSng |
Memo Source of Single Run Capacity |
VarChar |
1 |
- |
- |
- |
|
| |
|
|
|
|
|
C |
Resource Capacity Form |
| |
|
|
|
|
|
S |
Set Daily Internal Capacities Form |
| MemoSng |
Memo of Single Run Capacity |
Text |
16 |
- |
|
|
|