Vendor file read

Hi Sim,

I am assuming this is a one time use?

I am a power user who uses either the Excel Add-In (KnowledgeBase Article 5164650 on how to install) or I write a Crystal Report. Both can be saved as csv files.

The file name is APVENMAST. I would check for Active Status and also the VEN_CLASS field for EMP (employee) type since it will have the social security number as the vendor id. You may also want to inquire if they want to exclude any other classes.

If you need it as a constant feed, then I am assuming a COBOL 4GL needs to be written. Perhaps someone else can assist with that as I do not have access in my current position.

Hope this helps!

Georgette

What will you be using to read the file? Cobol, Perl, Shell Scripting, Add-Ins, others?

Here is a "sample" sql you could run.
[CODE] select trim(ven.vendor) vendor, trim(ven.vendor_vname) vname, trim(ven.vendor)||'-'|| trim(ven.vendor_vname) vname1, trim(ven.tax_id) taxid, trim(ven.vend_acct) vend_acct from apvenmast ven where ven.vendor_group = 1 and ven.ven_class = 'SUP' and ven.vendor_status = 'A' order by ven.vendor [CODE][

Cobol

Hi Georgette,
This will be an ongoing pull of vendors, so I am writing it in cobol and will schedule the job.

Sorry sim4, it has been a while since I've used cobol. My present position does not require for me to have access. All I know is the files are defined in workdef.

That's okay, thanks anyway.