Re: Cust Orders Completed

[Mhamilton8685@xxxxxxx]

--
[ Picked text/plain from multipart/alternative ]
Mac,

Generally speaking, your statement is correct.  I have actually used the
AS/400 CPYF command to purge really old ECH/ECL records (by HEDTE and HID)
with no ill effects.  Check also the ESN and ECS files for corresponding
order data.  There are also three clean up programs (ORD990, INV971 and
SYS990) that I would run after such an action.  This same procedure could be
used for RMA and Quote members.  One concern would be to determine how much
history needs to be kept online for customer service reference.

Records with HID CZ and status 8 are complete and invoiced, status E orders
with HID CZ were deleted before any shipment.

Myron Hamilton


In a message dated 1/15/2002 7:20:54 PM Pacific Standard Time,
MacWheel99@aol.com writes:


> I am aware that BPCS 405 CD has no customer order purge program like ORD has
> in V6 & BIL had in BPCS/36.  I need to write our own purge program because
> for every one good open customer order now operational, there are approx 25
> that have delivered to the customers everything that we are going to be
> sending.
>
> There are files all over creation with soft deleted records that are not
> going away.
>
> Does ECH.HID = 'CZ' mean order is purgeable
> or does ECH.HSTAT or other field(s) also need some specific value to
> consider
> them purgeable?
>
> Of our approx 8,000 'CZ' in member ECH
> most are type 1 status 8
> we have about 600 with type 1 status E
> and 2-3 each of 1-4 7-E and 7-8
>
> We have 623 RMA 'CZ' (member RETURN) including 1-E 1-8 7-E 7-8 9-E 9-8
>
> We have 8 member QUOTE 'CZ' all 1-E
>