KT.SETUPNETCHG

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:

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

 >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

KT.SETUPNETCHG

Syntax

Description

Example