Skip to content Skip to main navigation Skip to footer

Customer Address Maintenance

Purpose: To update Customer Address details from external sources, e.g. Framework.

Process:
In \Automation\Pending\, Prelude Desktop will scan for CSV files named.
“YYYYMMDDHHMMSSMMM-CC-TTT.CSV” where –

  • CC – Company Number the two-alphanumeric code
  • TTT – “SLA” Customer Address
  • YYYYMMDDHHMMSSMMM – Date/Time – date/time stamp
  • CODE – Char(8) – Customer code in Prelude Desktop (validated)
  • ADDCODE – Char(8) – Customer Address code (validated)
  • ADD1 – Char(60) – Address line 1
  • ADD2 – Char(60) – Address line 2
  • ADD3 – Char(60) – Address line 3
  • ADD4 – Char(60) – Address line 4
  • ADD5 – Char(60) – Address line 5
  • ADD6 – Char(60) – Address line 6
  • REPCODE – Char(4) – Sales Rep code (validated)
  • REF1 – Char(5) – Reference/Tag 1
  • REF2 – Char(5) – Reference/Tag 2
  • EMAIL– Char(128) – Email address

Validation:
If CODE doesn’t exist in CUSTOMER.DBF, fail.
If REPCODE doesn’t exist in SPNAME.DBF, fail.
For multiple records
If all validation is passed for all records, process all records.
If at least one validation test fails for at least one record, process no records.


Processing:
If CODE|ADDCODE record exists in SLDELADD.DBF.
If ADD1 = [DELETE], delete the SLDELADD.DBF record
Else, update the record with these details.
If there is no CODE|ADDCODE record in SLDELADD.DBF
If ADD1 = [DELETE], do nothing;
Else, add a new record with these details.