Result Set 16 - Production Setup
The following table lists the parameters used in a Production Setup Result Set.
|
Order |
Field Name |
Req |
Values/Table Reference |
|
0 |
Result Set Type |
X |
16 |
|
1 |
Update Type |
X |
0 - Post-Update. Data already in db and sent to clients only. 1 - Pre-Update. Database Manager writes to db and sends to client. |
|
2 |
Transaction Type |
X |
1 = Add 2 = Update 3 = Delete |
|
3 |
Transaction Number |
X |
Transaction Numbers 00 - Coalesce 01 - Comment Update 02 - No Coalesce 91 - Return To Parent Sequence 92 - Create Child Sequence 97 - Status Transition 98 - Move Sequence Back 99 - Move Sequence Forward |
|
4 |
PathId |
X |
|
|
5 |
PPSetupId |
|
|
|
6 |
PPId |
X |
|
|
7 |
ImpliedSequence |
|
|
|
8 |
PPStatusId |
|
|
|
9 |
PatternRepititions |
|
|
|
10 |
CommentId |
|
|
|
11 |
ForecastQuantity |
|
|
|
12 |
BaseDimensionX |
|
|
|
13 |
BaseDimensionY |
|
|
|
14 |
BaseDimensionZ |
|
|
|
15 |
BaseDimensionA |
|
|
|
16 |
BaseGeneral1 |
|
|
|
17 |
BaseGeneral2 |
|
|
|
18 |
BaseGeneral3 |
|
|
|
19 |
BaseGeneral4 |
|
|
|
20 |
Shrinkage |
|
|
|
21 |
PatternCode |
|
|
|
22 |
UserId |
X |
|
|
23 |
EntryOn |
|
|
|
24 |
TransactionTime |
|
|
|
25 |
ParentPPSetupId |
|
|