StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER019-081 }} {{ERTableHeader}} {{ERTableRow |AT_SCH_ORD_333194.sql ..."

2016-05-24T15:10:56Z

Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER019-081 }} {{ERTableHeader}} {{ERTableRow |AT_SCH_ORD_333194.sql ..."

New page

{{#vardefine:System|CTMS}}
{{ERHeader
|SystemVersion=CTMS 11.0
|ERNumber=ER019-081
}}

{{ERTableHeader}}
{{ERTableRow
|AT_SCH_ORD_333194.sql
|Alter Table Script
|1.1
|333194
|KH-A6QRC4
|3
|A new decode name of 'MODULO_43' will need to be setup for the 'REFERENCE' decode type with mapped values.

A new import type called 'PROCESS_ITEMS' will need to be setup to process manually the Toyota order files.

A new EDI process will need to be setup to process automatically the Toyota order files.

The new import type and 'Interface Errors' tab page will need to be authorised for use by the appropriate user groups.

The following directory structure will need to be setup to process the files:

Delivery Folder: '/webint/{DATABASE}/interface/TOY/IN'

Archive Folder: '/webint/{DATABASE}/interface/TOY/IN/archive'

Failures Folder: '/webint/{DATABASE}/interface/TOY/IN/failures'

New import decodes will need to be setup:

TOY_PACK_TYPE for REFERENCE
TOY_ASSET_TYPE for DU_TYPE
TOY_DEALERSHIP for LOCATION

A new EDI process will need to be setup with the following parameters and values:

Parameter:
DEFAULT_PROD_TYPE_ID as AMBIENT.

Report Values:
Package Name/PROCESS as DP_TOY_EDI_IN.P_PROCESS_FILES.
Process Name/pi_proc_name as TOYOTA_ORDER_ITEMS.

The EDI process will be called TOYOTA_ORDER_ITEMS with Customer, Cost Centre Code and Location set as required. Direction will be Inbound and Flow Type will be PROCESS.

A new system parameter called INT_ADD_MOD43_CD will need to be setup for the Toyota customer with a value of Y.

The import process will be called TOYOTA_ORDER_ITEMS to match the EDI process.
|Kate Hunter
}}
{{ERTableRow
|CT_INT_ORD_ITEMS_CSV_333194.sql
|Create Table Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|CT_SEQ_INT_ORD_ITEMS_CSV_333194.sql
|Create Table Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_1_IMP_IMPORT_TYPE_333194.sql
|Data Script
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_2_IMP_FIELD_333194.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_FORM_TAB_333194.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_LOG_PROG_NAME_333194.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_333194.sql
|Data Script
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_CONFIG_333194.sql
|Data Script
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_INT_ORD_ITEMS_CSV_BIU.sql
|Trigger
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|IMP.sql
|Imports database package
|5.126
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DP_TOY_EDI_IN.sql
|Inbound EDI database package
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|INT_ERR.fmx
|Interface errors oracle form
|1.87
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}

{{ERTableHeader}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_333199.sql
|Data Script
|1.1
|333199
|KH-A6QRJX
|3
|A new system parameter called 'WCS_CALC_ITEM_WGT_VOL' should be set to 'Y' for the customer to calculate the weight and volume from the DU type in the 804 scanning message.
|Kate Hunter
}}
{{ERTableRow
|DATA_ADM_SYSTEM_PARAM_CONFIG_333199.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DP_RDT_AUTO.sql
|RDT Database package
|5.39
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}

{{ERTableHeader}}
{{ERTableRow
|DATA_1_REP_REPORT_333204.sql
|Data Script
|1.1
|333204
|KH-A6QRQK
|3
|New interface audit extract showing interface records by date/status alongside that according to scanning and delivery.
|Kate Hunter
}}
{{ERTableRow
|DATA_2_REP_REPORT_PARAM_333204.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_3_REP_PARAM_VALUE_333204.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DP_CSV6.sql
|Extract Package
|1.27
|"
|"
|"
|"
|"
}}
{{ERTableFooter}}

<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>

<tr>
<td>INT_ERR/PROCESS_ITEMS</td>
<td>Process Items</td>
<td>The items that are provided in the CSV order file will be displayed in this tab page in the Interface Errors screen</td>
</tr>

</table>

<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>

<tr>
<td>INT_ADD_MOD43_CD</td>
<td>CUSTOMER</td>
<td>Y </td>
<td>The non-asset item will be given a suffix for the check digit based on the Modulo 43 mapping.</td>
</tr>

<tr>
<td>INT_ADD_MOD43_CD</td>
<td>CUSTOMER</td>
<td>N</td>
<td>The asset item will not be given a suffix as at present.</td>
</tr>

<tr>
<td>WCS_CALC_ITEM_WGT_VOL</td>
<td>CUSTOMER</td>
<td>Y</td>
<td>The weight and volume will be calculated for the new asset item based on the values for the DU type</td>
</tr>

<tr>
<td>WCS_CALC_ITEM_WGT_VOL</td>
<td>CUSTOMER</td>
<td>N</td>
<td>The weight and volume will not be calculated as at present.</td>
</tr>

</table>

<noinclude>
[[Category:{{#var:System}} ER]]
</noinclude>

CTMS 11.0 ER019-081 - Revision history

StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER019-081 }} {{ERTableHeader}} {{ERTableRow |AT_SCH_ORD_333194.sql ..."