KT.SETUPNETCHG

Syntax

KT.SETUPNETCHG

Description

This program can be used to assure that the Kourier Integrator Net Change software is properly setup in an account. It may be necessary to run this command for a number of reasons:

On some systems, the software author provides a command, usually run at month-end, that may delete and re-create the indexes on a file. Since the software author is not aware of the Kourier software, Kourier's Net Change index will not be re-created.
A file or its indexes have become corrupted.

If either of these situations occur and you are exporting information from U2 to SQL it may be necessary to perform a full-refresh of the data to ensure that the target SQL tables contain the correct information.

Example

This example shows the typical output of the KT.SETUPNETCHG command.

>KT.SETUPNETCHG
KT.SETUPNETCHG - 09/01/06

This program will setup net change tracking for all exports
where net change has been enabled and the export data file is
local to this account.

KT.SETUPNETCHG started at 17:50:54 26 AUG 2009


KS_ATP
  Skipped. Export is not net change enabled.
KS_BASE_PRICES
  Skipped. Export is not net change enabled.
KS_BOMS
  Skipped. Export is not net change enabled.
KS_CONTACTS
  Skipped. Export is not net change enabled.
KS_CURRENCY
  Skipped. Export is not net change enabled.
KS_CUSTOMERS
  Skipped. Export is not net change enabled.
KS_CUST_PARTS
  Skipped. Export is not net change enabled.
KS_EXCHG_RATES
  Skipped. Export is not net change enabled.
KS_FREIGHT
  Skipped. Export is not net change enabled.
KS_INVENTORY
  Skipped. Export is not net change enabled.
KS_INVOICES
  Skipped. Export is not net change enabled.
KS_MFG_ITEMS
  Skipped. Export is not net change enabled.
KS_ORDERS
  Skipped. Export is not net change enabled.
KS_PRICE_ADJS
  Skipped. Export is not net change enabled.
KS_RMAS
  Skipped. Export is not net change enabled.
KS_RMA_RECEIPTS
  Skipped. Export is not net change enabled.
KS_SALES_TAX
  Skipped. Export is not net change enabled.
KS_SERIALHIST
  Skipped. Export is not net change enabled.
KS_SHIPMENTS
  Skipped. Export is not net change enabled.
KS_SHIP_ADDRS
  Skipped. Export is not net change enabled.
SQL_ARINVOICE
  Change log enabled for application "SQL_ARINVOICE" on file AR-INVOICE.
  Change log enabled for application "SQL_ARINVOICE" on file AR-INVOICE,HIST.
SQL_ARINVOICE_SALESREP
  Change log enabled for application "SQL_ARINVOICE_SALESREP" on file AR-INVOICE.
  Change log enabled for application "SQL_ARINVOICE_SALESREP" on file AR-INVOICE,HIST.
SQL_ARLI
  Change log enabled for application "SQL_ARLI" on file ARLI.
  Change log enabled for application "SQL_ARLI" on file ARLI,HIST.
SQL_CUSTOMER
  Change log enabled for application "SQL_CUSTOMER" on file CUSTOMER.
SQL_CUSTOMER_CLASS
  Change log enabled for application "SQL_CUSTOMER_CLASS" on file CUSTOMER-CLASS.
SQL_CUSTOMER_SALESREP
  Change log enabled for application "SQL_CUSTOMER_SALESREP" on file CUSTOMER.
SQL_PARTS
  Change log enabled for application "SQL_PARTS" on file PARTS.
SQL_PART_CLASS
  Change log enabled for application "SQL_PART_CLASS" on file PRODUCT-CODES.
SQL_SALESREP
  Change log enabled for application "SQL_SALESREP" on file SALESREP.
SQL_TERRITORY
  Change log enabled for application "SQL_TERRITORY" on file TERRITORY.

KT.SETUPNETCHG complete at 17:50:56 26 AUG 2009