IC840
IC840 - Cart Par Location Conversion

Run Cart Par Location Conversion (IC840) to import the cart/par location CSV conversion file. **Processing Effect For UNIX/Windows platforms: The process will take the input CSV file and edit it as if it were going through the IC81 edit form 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. For System i platform: The process will take the input CSV file and edit it as if it were going through the IC81 edit form in Inventory Control before then updating the following tables: DBRQRQL, DBICICL, DBICBGR, DBICITL, DBICICB, and DBICBGD. DBICICA, DBICICL, DBICITE 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. DBICITL must exist for replenishment locations. If the DBICITL record exists for the location already the record will be updated with information from the input CSV file no matter what. As discussed, the DBICICL 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 DBICICL.

Updated Files
APAPPROVAL - No Description Available.
APAUDIT - No Description Available.
APCOMMENTS - No Description Available.
APCONTACT - No Description Available.
APCPYVND - No Description Available.
APHLDINV - No Description Available.
APVENADDR - No Description Available.
APVENBAL - No Description Available.
APVENCERT - No Description Available.
APVENGROUP - No Description Available.
APVENLOC - No Description Available.
APVENMAST - No Description Available.
APVENPAY - No Description Available.
BINGROUP - No Description Available.
BINGRPDTL - No Description Available.
CBBANKINST - No Description Available.
CBCASHCODE - No Description Available.
CBCHECK - No Description Available.
CKPOINT - No Description Available.
CUSTDESC - No Description Available.
ICAUDIT - No Description Available.
ICBIN - No Description Available.
ICCOMPANY - No Description Available.
ICICLAUDIT - No Description Available.
ICLOCATION - No Description Available.
ICLOCGRP - No Description Available.
IFBCIQUEUE - No Description Available.
ITEMLOC - No Description Available.
ITEMSRC - No Description Available.
MXLISTHDR - No Description Available.
MXLISTMBR - No Description Available.
POPOVUF - No Description Available.
POVENDLOC - No Description Available.
POVENDOR - No Description Available.
RQLOC - No Description Available.
RQRQLAUDIT - No Description Available.
TXCODEMAST - No Description Available.
TXCOMPANY - No Description Available.
TXTAXCODE - No Description Available.
TXTAXTABLE - No Description Available.



Referenced Files
APACCRCODE - No Description Available.
APAPIHIST - No Description Available.
APAPPROVAL - No Description Available.
APAUTHOR - No Description Available.
APCOMMENTS - No Description Available.
APCOMPANY - No Description Available.
APCONTACT - No Description Available.
APCPYVND - No Description Available.
APDISCCODE - No Description Available.
APDISTHDR - No Description Available.
APHLDINV - No Description Available.
APHOLDCODE - No Description Available.
APINCCODE - No Description Available.
APINVOICE - No Description Available.
APPAYMENT - No Description Available.
APPROCGRP - No Description Available.
APUSRFLDEF - No Description Available.
APVENBAL - No Description Available.
APVENCERT - No Description Available.
APVENCLASS - No Description Available.
APVENLOC - No Description Available.
APVNMXVAL - No Description Available.
ARCUSTGRP - No Description Available.
CBCHECK - No Description Available.
CBUSER - No Description Available.
CBUSRCLASS - No Description Available.
COMPONENT - No Description Available.
CUCODES - No Description Available.
CUCONV - No Description Available.
CURELAT - No Description Available.
EEADVANCE - No Description Available.
EEAPPROVAL - No Description Available.
EEEXPENSE - No Description Available.
GLCODES - No Description Available.
GLNLOC - No Description Available.
GLNLOCDTL - No Description Available.
GLSYSTEM - No Description Available.
ICACTIVITY - No Description Available.
ICCATEGORY - No Description Available.
ICLBOD - No Description Available.
ICLOCGRP - No Description Available.
ICTBOD - No Description Available.
ICTRANS - No Description Available.
INSTCTRYCD - No Description Available.
INSTREGN - No Description Available.
ITEBOD - No Description Available.
ITEMGROUP - No Description Available.
ITEMMAST - No Description Available.
ITLBOD - No Description Available.
KITBOD - No Description Available.
KITITEM - No Description Available.
MAINVHAND - No Description Available.
MAMATCHTBL - No Description Available.
MAMSGTOL - No Description Available.
MAMTCHRULE - No Description Available.
MXCATDEF - No Description Available.
MXELEMENT - No Description Available.
MXLISTDTL - No Description Available.
MXOBJCAT - No Description Available.
POAOCDTL - No Description Available.
POCOMPANY - No Description Available.
POITEMVEN - No Description Available.
POMXVAL - No Description Available.
POVAGRMTHD - No Description Available.
POVENDLOC - No Description Available.
PROCUREGRP - No Description Available.
PURCHORDER - No Description Available.
RQLMXVAL - No Description Available.
SYSTEMCODE - No Description Available.
TXTAXRATE - No Description Available.
WFSETUP - No Description Available.



INVOKED Programs
ACAC
ACTA
API4
IFAC
IFCU
IFOB
IFSG
SLSE
SLSU
IFLU
IFUP
API3
ICLM
RQBL




File created: Thu Jun 09 02:20:13 2016

Nogalis, inc.
Contact Us

All trademarks and registered trademarks are the property of their respective owners.