<>C ?3SMALLPARCELIMP - MANUAL ADDRESS IMPORT INTO SMALL PARCEL INTEG3 R$"$#JCUST)","#.tpl1"","# *#R$"$%"#JITEM,"#.tpl1"","# &%R$"$'"#JILOT,"#.tpl1"","# (&R$"$2"#JSLOT,"#.tpl1"","# <@@AK$' pagetitle2SMALL PARCAL IMPORT: /u/whp/webnew/clg/distrib.sqlB$!F[U#3456789:;<=>?@ABCDEFGHP#U#IJKLMNOPZU#QRSTU]A$9^>$6dU#VWXYZ[n?U #\]^_`abcdefghijsA$td class="td" <> < nowrap>x+U #klmnopqrsty(#uvwxyz{|}~z$   ($$'TRHILITE 
S$K !$  $+$< width="۩(">8] ! $ 8] ,$ $
8]2$$,"/u/whp/webnew/clg/distrib.sql1, 6$$$ө@@8E]T' өBULK^ph!#(3DISPLAY INQUIRY SCREENp'3---------------- DO THE REVIEW/UPDATESu->$ 1
Enter Parameters
 u$ i$@F$$,O_TRUNC,O_CREATE/u/whp/webnew/clg/distrib.sql8 LL$ 
ADDRESS Import
$ UPDATE Complete!$ u

Force update to SQL table Click HEREN#(C$'?PGM=JBB&WF=JBDEALERS&PGMFUNC=VIEW&SEQ=&POPUP=1#$ ViewV$ '$ 8$"8*U$I?PGM=JBB&WF=JBITEM&PGMFUNC=LOOKUP&DOSEARCHNUM=_JBITEM1&RETURNTO=MATCHRIC|4#$ Find6V$ >'$ H8L$"8@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE&$+,-@. $/@0SADJITEM+/+ ZSCRAP@1 QUICK RECEIPT 3input screen$transitinquiryL$ 
 $ \$ HContents of manual interface file: /u/whp/webnew/clg/distrib.sql

c$ jE$ /l$ ' - nI$ 1r!$ 
|$ Data can be copy/pasted from Excel. Place the columns next to each other, copy the cells you want updated, don't include any column headers.

8  $ ($ܨ8]D N# $ŞX( M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($/// @ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ]  J >$':8b]`;U 3 ------ RETURN STRING OF FORM TAGS IN formstart formende$j?$
~Y N$B<$&$' R F$+ $
$8TRTDDTRO ERRMESSAGEYYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRTEXTTDDHBRWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLDUMMYRKEY VIEWURLGVIEWURL VIEWURL1WFURL VIEWURL2 FORMNAMEFURL FINDURL1 FINDURLG FINDURL2SEARCHWARNINGFF TRHIGHLITEJITEMJITEMJILOTJILOTJCUSTJCUSTDOITEM WFCOCODEWFCUST PREL.ITEM_NOADATE CGI.RDATE CGI.RQTYJSLOTA4B4C4D4C4D4E4F4G4H4F4G4I4J4H4K4L4M4N4O4I4Q4A5A5B5C5D5E5B5F5KK1K2K3K9A3B3A3C3D3E3A7A7B7C7D7E7F7G7H7I7J7B7C7D7L7A10B10A10B10C10D10E10F10G10H10A18B18A18B18C18D18E18F18G18H18JSLOTTEXT1 FORMSTART NOSUBMITSUBFUNCFORMEND BACKBUTTONCLOSEGYYMDYMDY.YJMDYMDY.MMDY.DYYY1YYY2YYYDISTRIBDOSQL CGI.BULKCW1BREMPTYCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUB@ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ]  J >$':8b]`;U 3 ------ RETURN STRING OF FORM TAGS IN formstart formende$j?$
~Y N$B<$&$' R F$+ $
$8TRTDDTRO ERRMESSAGEYYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRTEXTTDDHBRWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLDUMMYRKEY VIEWURLGVIEWURL VIEWURL1WFURL VIEWURL2 FORMNAMEFURL FINDURL1 FINDURLG FINDURL2SEARCHWARNINGFF CGI.BULKBULKBULK1PRESULT1 TRHIGHLITEJITEMJITEMJILOTJILOTR R.CUST R.ITEM R.LOT R.QTY R.LOC R.TDATEJCUSTJCUSTDOITEM WFCOCODEWFCUST PREL.ITEM_NOADATE CGI.RDATE CGI.RQTYJSLOTA4B4C4D4C4D4E4F4G4H4F4G4I4J4H4K4L4M4N4O4I4Q4A5A5B5C5D5E5B5F5KK1K2K3K9A3B3A3C3D3E3A7A7B7C7D7E7F7G7H7I7J7B7C7D7L7A10B10A10B10C10D10E10F10G10H10A18B18A18B18C18D18E18F18G18H18JSLOT DOUPDATEEWARNLOTWARN JITEM.LOTTED_ITEMQTY JCUST.CUSTOMER_NAME JITEM.DESCRIPTION R.REFTEXT1 FORMSTART NOSUBMITSUBFUNCFORMEND BACKBUTTONCLOSEGDOWRITEYYMDYMDY.YJMDYMDY.MMDY.DYMDLOCLOTYYY1YYY2YYYDISTRIBDOSQLCW1BREMPTYCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUBfYTOMER_NAME JITEM.DESCRIPTION R.REFTEXT1 FORMSTART NOSUBMITSUBFUNCFORMEND BACKBUTTONCLOSEGDOWRITEYYMDYMDY.YJMDYMDY.MMDY.DYMDLOCLOTYYY1YYY2YYYCW1BREMPTYD1XLCSZCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUB