|
|
IC840 - Cart Par Location Conversion
**Form Purpose
Run Cart Par Location Conversion (IC840) to import the cart/par location CSV
conversion file.
**Processing Effect
The process will take the input CSV file and edit it as if it were going
through the IC81 edit screen in Inventory Control before then updating the
following tables: RQLOC, ICLOCATION, BINGROUP, ITEMLOC, ICBIN, and
BINGRPDTL.
ICCATEGORY, ICLOCATION, ITEMMAST are tables that will need to be populated
with data prior to running the conversion job. The GL and AP applications also
need to be set up.
ITEMLOC must exist for replenishment locations. If the ITEMLOC record exists
for the location already the record will be updated with information from the
input CSV file no matter what.
As discussed, the ICLOCATION conversion will include the cart and par
locations which will than allow the GL category conversion to execute properly
and this conversion job will just update the ICLOCATION.
Updated Files
APAPPROVAL -
APAUDIT -
APCOMMENTS -
APCPYVND -
APHLDINV -
APVENADDR -
APVENBAL -
APVENGROUP -
APVENLOC -
APVENMAST -
APVENPAY -
BINGROUP -
BINGRPDTL -
CBBANKINST -
CBCASHCODE -
CKPOINT -
CUSTDESC -
ICBIN -
ICCOMPANY -
ICLOCATION -
ITEMLOC -
ITEMSRC -
POVENDLOC -
POVENDOR -
RQLOC -
TXCODEMAST -
TXCOMPANY -
TXTAXCODE -
TXTAXTABLE -
Referenced Files
APACCRCODE -
APAPPROVAL -
APAUTHOR -
APCOMMENTS -
APCOMPANY -
APCPYVND -
APDISCCODE -
APDISTHDR -
APHLDINV -
APHOLDCODE -
APINCCODE -
APINVOICE -
APPAYMENT -
APPROCGRP -
APUSRFLDEF -
APVENBAL -
APVENCLASS -
APVENLOC -
ARCUSTGRP -
CBCHECK -
CBUSER -
CBUSRCLASS -
CUCONV -
CURELAT -
EEADVANCE -
EEAPPROVAL -
EEEXPENSE -
GLCODES -
GLSYSTEM -
ICCATEGORY -
INSTCTRYCD -
INSTREGN -
ITEMMAST -
MAINVHAND -
MAMATCHTBL -
MAMTCHRULE -
MAPOOLCNT -
POAOCDTL -
POVAGRMTHD -
POVENDLOC -
PROCUREGRP -
PURCHORDER -
TXTAXRATE -
INVOKED Programs
ACAC
ACCL
API4
IFAC
IFCU
IFSG
SLSE
SLSU
API3
|
