ComplianceRecord

A compliance record applies a compliance type to a specified vendor or primary document so that you can track dates, amounts, and documents that show compliance.

Columns


Name	Type	ReadOnly	Description
Recordno [KEY]	Long	True	Record number
Compliancerecordid	String	True	Compliance record ID
Name	String	False	Compliance record name
Description	String	False	Description
Status	String	False	Status
Compliancetypekey	Long	True	Compliance type key
Compliancetypeid	String	False	Compliance type ID
Compliancedefinitionkey	Long	True	Compliance definition key
Compliancedefinitionid	String	True	Compliance definition ID
Category	String	True	Compliance category
Vendorkey	Long	True	Supplier key
Vendorid	String	False	Supplier ID
Vendorname	String	True	Supplier name
Projectkey	Long	True	Project key
Projectid	String	False	Project ID
Projectname	String	True	Project name
Dochdrkey	Long	True	Dochdr Key
Dochdrid	String	True	DOCHDRID
Contactname	String	False	Contact name
Contactkey	Long	True	Contact key
Policynumber	String	False	Policy or document number
Referencenumber	String	False	Reference number
Effectivedate	Date	False	Effective date
Expirationdate	Date	False	Expiration date
Amount	Decimal	False	Amount
Additionalinsured	Bool	False	Additional insured
Subrogationwaiver	Bool	False	Subrogation waiver
Docparid	String	True	Transaction definition
Primarydockey	Long	True	Primary doc key
Primarydocid	String	True	Primary document ID
Apbillkey	Long	True	AP purchase invoice key
Apbillno	String	True	AP purchase invoice
Appaymentkey	Long	True	AP payment
Compliancetemplate	String	True	Compliance template
Finalcompliancetemplate	String	True	Final compliance template
Secvendcompliancetemplate	String	True	Secondary supplier compliance template
Voided	String	True	Voided
Finalcompliance	String	False	Final compliance
Sendtocontactkey	Long	True	Send-to contact key
Sendtocontactname	String	False	Send document to contact
Validationrule	String	True	Validate against
Documentreceived	Bool	False	Document received
Receiveddate	Date	False	Received date
Receivedbykey	Long	True	Received by key
Receivedbyid	String	False	Received by ID
Receivedbyname	String	True	Received by name
Paymentnotification	String	True	When not compliant in AP payments
Postnotification	String	True	Post notification
Notificationoverride	String	False	Override compliance notification
Systemgenerated	String	True	System generated
Supdocid	String	False	Attachment
Notes	String	False	Notes
Secondaryvendorname	String	False	Secondary supplier name
Secondaryvendor	Bool	False	Secondary supplier
Compliancesendto_email1	String	False	Primary email address
Compliancesendto_email2	String	False	Secondary email address
Compliancesendto_firstname	String	False	First name
Compliancesendto_lastname	String	False	Last name
Compliancesendto_prefix	String	False	Prefix
Compliancesendto_initial	String	False	Middle name
Compliancesendto_companyname	String	False	Full name of the company
Compliancesendto_printas	String	False	Name as appears on official documents
Compliancesendto_phone1	String	False	Primary phone
Compliancesendto_phone2	String	False	Secondary phone
Compliancesendto_cellphone	String	False	Mobile phone number
Compliancesendto_pager	String	False	Pager
Compliancesendto_fax	String	False	Fax
Compliancesendto_url1	String	False	Primary URL
Compliancesendto_url2	String	False	Secondary URL
Whencreated	Datetime	True	Timestamp marking last time this was created.
Whenmodified	Datetime	True	Timestamp marking last time this was changed.
Createdby	Long	True	User who created this.
Modifiedby	Long	True	User who modified this.
Megaentitykey	Long	True	Created at - Entity key
Megaentityid	String	True	Created at - Entity ID
Megaentityname	String	True	Created at - Entity name
Record_url	String	True	A portable, user-independent, deep-link URL for viewing this record

ADO.NET Provider for Sage Intacct

ComplianceRecord

Columns