Description
The command writes in the database temporary table DBW_PARENT_CHILD_REVISION the parent-child structure of a specific document at revision
Syntax
call DBWShell("PopulateParentChildRevisionTable unique_id revision")
Parameters
unique_id |
unique id of the document to write the table of |
|---|---|
revision |
revision of the document |
Remarks
The table DBW_PARENT_CHILD_REVISION must have the following structure:
Where the name of each field must be in the same language of the main PARENT_CHILD table
(e.g. with a German Language database, PARENT_UNIQUE_ID must be replaced by ELTERN_EINDEUTIGE_NR)
DBW_PARENT_CHILD_REVISION |
|||
|---|---|---|---|
PK |
Field Name |
Data Type |
Allow Nulls |
PARENT_UNIQUE_ID |
int |
|
|
CHILD_UNIQUE_ID |
int |
|
|
PARENT_CHILD_INDEX |
int |
|
|
PARENT_CHILD_QTY |
float |
|
|
PARENT_CHILD_UM |
varchar(20) |
|
|
PARENT_CHILD_MAKE_BUY |
varchar(20) |
|
|
PARENT_CHILD_BOM_POS |
varchar(20) |
|
|
PARENT_CHILD_REVISION |
varchar(20) |
|
|
