Contract

A collection of Contract items.

Columns


Name	Type	ReadOnly	Description
Recordno [KEY]	Long	True	Record Number
Parentkey	Long	False	Parent key
Parentid	String	True	Original contract
Description	String	False	Description
Contractid	String	False	Unique ID of Contract
State	String	True	State
Begindate	Date	False	Start date
Enddate	Date	False	End date
Canceldate	Date	True	Cancel date
Name	String	False	Contract name
Customerkey	Long	False	Customer key
Customerid	String	False	Customer ID
Customername	String	False	Customer name
Displaycontact_email1	String	False	Primary email address
Displaycontact_email2	String	False	Secondary Email Address
Billtokey	Long	False	Bill-to contact key
Billtocontactname	String	False	Bill to
Billto_email1	String	False	Primary email address
Billto_email2	String	False	Secondary Email Address
Shiptokey	Long	False	Ship-to contact key
Shiptocontactname	String	False	Ship to
Shipto_email1	String	False	Primary email address
Shipto_email2	String	False	Secondary Email Address
Billingfrequency	String	False	Billing frequency
Termkey	Long	False	Term key
Termname	String	False	Term
Renewal	Bool	False	Renew
Renewalmacrokey	Long	False	Renewal template key
Renewedcontractkey	Long	False	Renewed contract key
Renewedcontractid	String	True	Renewal source
Renewalmacro	String	False	Renewal template
Renewcontract_schopkey	Long	False	Renewal scheduled operation key
Renewemailalert_schopkey	Long	False	Renewal alert scheduled operation key
Nonrenewcontract_schopkey	Long	False	Non-renewal contract cancelation scheduled operation key
Renewcustomeralert_schopkey	Long	False	Renewal customer alert scheduled operation key
Renewtermlength	Long	False	Renewal term length
Renewtermperiod	String	False	Renewal term period
Prclstkey	Long	False	Price list key
Prclist	String	False	Billing price list
Meaprclist	String	False	Fair value price list
Meaprclstkey	Long	False	Fair value price list key
Billinghold	Bool	False	Billing hold
Revenuehold	Bool	False	Revenue hold
Crhold	Bool	False	Hold for cash receipt
Expensehold	Bool	False	Expense hold
Basecurr	String	True	Base currency
Currency	String	False	Transaction currency
Exchratetype	String	False	Exchange rate type
Exch_rate_type_id	Long	False	Exchange rate type Id
Locationkey	String	False	Location key
Locationid	String	False	Location ID
Locationname	String	False	Location name
Deptkey	String	False	Department key
Departmentid	String	False	Department ID
Departmentname	String	False	Department name
Advbillby	Long	False	Bill in advance
Advbillbytype	String	False	Bill in advance type
Renewaladvbillby	Long	False	Bill in advance for Renewal
Renewaladvbillbytype	String	False	Bill in advance type for Renewal
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.
Supdocid	String	False	Attachment
Status	String	False	Active/Inactive
Contracttypekey	Long	False	Contract type key
Contracttype	String	False	Contract type
Timesheetaggregation	String	False	Defer estimated time-based revenue by
Postmemo	String	True	Post memo
Megaentitykey	Long	True	Created at - Entity key
Megaentityid	String	True	Created at - Entity ID
Megaentityname	String	True	Created at - Entity name
Test_specialcharacters	String	False	test field with special characters
Test_specialcharacters2	String	False	testing with special chars
Projectdimkey	Long	False	Projectdimkey
Projectid	String	False	Project
Projectname	String	False	Project Name
Vendordimkey	Long	False	Vendordimkey
Vendorid	String	False	Vendor
Vendorname	String	False	Vendor Name
Employeedimkey	Long	False	Employeedimkey
Employeeid	String	False	Employee
Employeename	String	False	Employee Name
Classdimkey	Long	False	Classdimkey
Classid	String	False	Class
Classname	String	False	Class Name
Warehousedimkey	Long	False	Warehousedimkey
Warehouseid	String	False	Warehouse
Warehousename	String	False	Warehouse Name
Record_url	String	True	A portable, user-independent, deep-link URL for viewing this record
Gldimtestegi1	String	False

JDBC Driver for Sage Intacct

Contract

Columns