Feature - Allow Mass Delete of Attribute Records

Feature - Allow Mass Delete of Attribute Records

Release date: 1/9/2019
Revised Date: 02/14/2024
Version: 8.5 & Up

This feature will allow mass deletion of attribute records. It is called from Util-Setup-> System File Maintenance-> Import-> Mass Delete Attribute. This application will delete the attribute data records (SYATTRIB). It will not delete the attribute definition (SYATRFIL).
 
It has three menu options - Pre-Interface, Interface, and Layout.

The Layout screen has the following fields:
  1. File Name - this is like ARCUSFIL, APVENFIL, IMITMFIL, SYCONTCT...etc.
  2. Attribute Code - the attribute code up to 15 digits.
  3. Reference ID - This is the primary key value of the file.  For example, for ARCUSFIL, it is the Customer Number; for IMITMFIL, it is the item number; and for SYCONTCT, it is the Contact ID.  You need to provide leading zeroes for some of the files if the primary key values are numeric.  For example, customer and vendor number must be exactly 6 digits in length;  contact id must be exactly 9 digits long.

The Pre-Interface and Interface screens have the following options:

1. CSV File Name:                         
           
2. Import File With Header Row ?     

CSV File Name - The filename is stored in the registry and used as a default.
Import File with Header Row - The Value is  stored in the registry.

When the pre-interface is run, the records will have a status of Deleted or an error message.  During pre-interface, records will not be deleted.


When the interface is run, the user will be prompted with the following question:


After the interface is completed the input file will be deleted and the following report will be created.  Note the "Total No. Deleted Records."



Field requirements:

File Name 
Valid values are: ARCUSFIL, APVENFIL, IMITMFIL, CPORDHDR, POORDHDR,        BMORDFIL, SFORDFIL, EMPFILE, ARSLMFIL, SYCONTCT, CPSHPFIL 
Field is converted to upper case
Field is required

Attribute Code
Field is required
Field is converted to upper case
Code must exist in SYATRFIL

Reference ID
Field is required
Field is converted to upper case

Error Conditions:
Invalid File Name
Attribute Code Not On File
SYATTRIB record not found

Modified programs: SYATTRIS, SYFILMNU, SYDELATS (new), SYDELATP (new)

DLM 



    • Related Articles

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 4/25/25 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

    • Feature - Add Serial Number to Mass Billing CSV Import

      Release Date - 6/18/18 This feature allows the user to specify serial numbers when using the Mass Billing application and choosing the CSV Import option. The serial number is supported in column E of the CSV file: The application will test for the ...

    • Feature - Auto Delete BOMP Product Structure When Item Obsolete

      Release Date - 3/21/16 This feature will allow the user the option to delete a parent product structure when marking the parent obsolete in Item Master File Maintenance, through the Change Item CSV Import, or through the Mass Obsolete Item ...

    • Feature - Control Deletion of Box Shipment Records

      Release date: 8/5/2021 Versions: 8.5 & Up Program changes have been made to control, at the Global Setup level, the ability to Delete Box Shipment records. In COP --> Processing --> Print Pick/Pack Ticket & Lbls --> Print --> Vics bill of lading, ...

    • Feature - Added ^TRANSFERBATCHS Attribute to Track Transfer Batches from Sales Orders

      Release date: 10/20/2020 Version 8.5 and Up This new feature adds an attribute "^TRANSFERBATCHS" to allow tracking of transfer batches from sales orders. Define the attribute in System Utilities -> System Files Setup -> Maintenance -> Attribute File ...