vendor_raw

Pipelined Data Sets > Symitar > vendor_raw

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
eventtime	Internal use only	NULLABLE	INTEGER
sourcetype	Internal use only; SSDB field	NULLABLE	STRING
operation	Internal use only; SSDB field	NULLABLE	STRING
extractdate	Internal use only	NULLABLE	DATE
processdatetime	Internal use only; SSDB field	NULLABLE	TIMESTAMP
vendoruuid	This field stores a JH Platform unique identifier for a vendor	NULLABLE	STRING
vendorkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	NULLABLE	INTEGER
number	This field stores the unique ID you enter at the AP Vendor Number prompt when you create a Vendor record	NULLABLE	STRING
name	This field stores the vendor name (up to 40 characters) that you want to appear on the payee section of a check	NULLABLE	STRING
extraaddress	This field stores an additional line of address information, if necessary	NULLABLE	STRING
street	This field stores the street address of the vendor as you want it to appear on the payee address section of a check	NULLABLE	STRING
city	This field stores the city of the vendor's address as you want it to appear on the payee address section of a check	NULLABLE	STRING
state	This field stores the state of the vendor's address as you want it to appear on the payee address section of a check	NULLABLE	STRING
zipcode	This field stores the ZIP code or postal code of the vendor's address	NULLABLE	STRING
phone	This field stores the vendor's telephone number, either domestic or foreign	NULLABLE	STRING
contact	This field stores the name of your contact at the vendor as you want it to appear in inquiries	NULLABLE	STRING
creditytd	This field stores the amount paid when you use the (1) Process Invoice Payments option in the GL Posting batch program	NULLABLE	NUMERIC
debitytd	This field stores the amount expensed when you use the (0) Process Invoice Expenses option in the GL Posting batch program	NULLABLE	NUMERIC
lastpaymentamount	This field stores the amount of the most recent invoice payment made to this vendor	NULLABLE	NUMERIC
lastpaymentdate	This field stores the date of the most recent invoice payment made to this vendor	NULLABLE	DATE
glexpense	This field stores the complete GL account number of the GL account the system should normally debit when expensing an invoice for this vendor	NULLABLE	STRING
glacctspay	This field stores the complete GL account number of the GL account the system should normally debit when paying an invoice for this vendor	NULLABLE	STRING
gldiscount	This field stores the complete GL account number of the GL account the system should normally credit when you take a discount for this vendor	NULLABLE	STRING
lastfmdate	This field stores the date of the last file maintenance of the Vendor record	NULLABLE	DATE
customerid	This field stores optional information for various purposes	NULLABLE	STRING
addresstype	This field stores a code that indicates if the vendor's address is domestic or, if foreign, how to use it	NULLABLE	INTEGER
creditlastyear	This field stores the total amount paid when you use the (1) Process Invoice Payments option in the GL Posting batch program	NULLABLE	NUMERIC
debitlastyear	This field stores the total amount expensed when you use the (0) Process Invoice Expenses option in the GL Posting batch program	NULLABLE	NUMERIC
irsreporting	This field stores a code that determines whether the system produces a 1099-MISC or 1099-NEC form for the vendor	NULLABLE	INTEGER
irscorrection	This field stores a code that determines whether the system produces corrected 1099-MISC and 1099-NEC forms and a corrected IRS reporting tape	NULLABLE	INTEGER
irsamountcode	This field stores a code that determines the category of income to report on the 1099-MISC and 1099-NEC forms for this vendor	NULLABLE	INTEGER
ssntype	This field stores a code that identifies the type of SSN or TIN the vendor has provided	NULLABLE	INTEGER
ssn	This field stores the vendor's organization EIN (Employer Identification Number), TIN (individual Taxpayer Identification Number), or individual SSN	NULLABLE	STRING
irsnamecontrol	This field stores the first four characters of the vendor's last name or business name	NULLABLE	STRING
restrictionlevel	This field stores a code that can specify restricted access to this Vendor record	NULLABLE	INTEGER
comment1	This field stores optional information (up to 40 characters) you want to store about this Vendor record or this vendor	NULLABLE	STRING
payee	This field stores the optional payee ID (up to 10 characters) used for payments paid through ACH origination	NULLABLE	STRING
email	This field stores the e-mail address of the contact person identified in this Vendor record	NULLABLE	STRING
phoneextension	This field stores the business telephone extension for the contact person identified in the Vendor record	NULLABLE	STRING
achgroupnumber	This field stores the credit union-defined number of the invoice ACH group	NULLABLE	STRING
companydisc	This field stores optional discretionary data for the batch header in the ACH file	NULLABLE	STRING
companyentrydesc	This field stores the description of the purpose of the entry	NULLABLE	STRING
dfiaccount	This field stores the processor's account number at the receiving institution. It is required for the ACH item	NULLABLE	STRING
rdfirt	This field stores the unique routing and transit number (nine alphanumeric characters, including a check digit) of the financial institution receiving the transaction (RDFI)	NULLABLE	STRING
receivingcomp	For a Standard Entry Class (SEC) code of CCD, this required field stores the receiving company name	NULLABLE	STRING
altemail	This field stores an alternate e-mail address for the vendor identified in this record	NULLABLE	STRING
contactdesc	This field stores the job title of the person used as your credit union's contact at the vendor	NULLABLE	STRING
contact2	This field stores the name of a second contact at the vendor (up to 40 characters)	NULLABLE	STRING
contact2desc	This field stores the job title of a second person (up to 20 characters) used as your credit union's contact at the vendor (for example, contact manager, assistant manager, or salesperson)	NULLABLE	STRING
contact2phone	This field stores the phone number for the second contact	NULLABLE	STRING
contact2ext	This field stores the telephone extension (up to 6 characters) of the second contact for the vendor	NULLABLE	STRING
fax	This field stores the fax telephone extension for the vendor	NULLABLE	STRING
fmlastpurgedate	This field stores the date through which you last purged file maintenance history for Accounts Payable records with the Purge Transaction Processing batch program	NULLABLE	DATE
recordchangedate	The system stores the system date in this field when you create, change, or save the Accounts Payable Vendor record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record	NULLABLE	DATE
irsreportingname	This field stores the legal name of the vendor for reporting to the IRS	NULLABLE	STRING

Have a Question?

Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026