Dynamics GP Table Reference - COMPANY..JC01504 fields

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module JC tables JC01504

You are currently viewing the COMPANY database.
Change

COMPANY..JC01504 Table Definition

(COMPANY..JC_Vendor_Dates_MSTR)

Field Definitions:

	Column Name	Data Type Default Value		Source
	WS_Job_Number	char(17)

	VENDORID	char(15)	Vendor ID:...(more) Join Now	PM10000.VENDORID
join ... more text available
	PORDNMBR	char(21)	Purchase O...(more) Join Now

	Ins_Cert_on_File	tinyint

	Lien_Waiver_on_File	tinyint

	O_M_Manuals	tinyint

	Payment_Bond	tinyint

	Performance_Bond	tinyint

	JC_Required_CB_1	tinyint

	JC_Required_CB_2	tinyint

	JC_Required_CB_3	tinyint

	JC_Required_CB_4	tinyint

	JC_Required_CB_5	tinyint

	JC_Required_CB_6	tinyint

	JC_Required_CB_7	tinyint

	JC_Required_CB_8	tinyint

	JC_Required_CB_9	tinyint

	JC_Required_CB_10	tinyint

	JC_Required_CB_11	tinyint

	JC_Required_CB_12	tinyint

	JC_Required_CB_13	tinyint

	JC_Required_CB_14	tinyint

	JC_Required_CB_15	tinyint

	JC_Required_CB_16	tinyint

	JC_Required_CB_17	tinyint

	JC_Required_CB_18	tinyint

	JC_Required_CB_19	tinyint

	JC_Required_CB_20	tinyint

	Ins_Expiration_Date	datetime

	Lien_Waiver_Req_Date	datetime

	O_M_Manuals_Req_Date	datetime

	Payment_Bond_Req_Date	datetime

	Performance_Bond_Req_DT	datetime

	JC_Required_Date_1	datetime

	JC_Required_Date_2	datetime

	JC_Required_Date_3	datetime

	JC_Required_Date_4	datetime

	JC_Required_Date_5	datetime

	JC_Required_Date_6	datetime

	JC_Required_Date_7	datetime

	JC_Required_Date_8	datetime

	JC_Required_Date_9	datetime

	JC_Required_Date_10	datetime

	JC_Required_Date_11	datetime

	JC_Required_Date_12	datetime

	JC_Required_Date_13	datetime

	JC_Required_Date_14	datetime

	JC_Required_Date_15	datetime

	JC_Required_Date_16	datetime

	JC_Required_Date_17	datetime

	JC_Required_Date_18	datetime

	JC_Required_Date_19	datetime

	JC_Required_Date_20	datetime

	Ins_Cert_Date_Recd	datetime

	Lien_Waiver_Date_Recd	datetime

	O_M_Manuals_Date_Recd	datetime

	Payment_Bond_Date_Recd	datetime

	Performance_Bond_DT_Recd	datetime

	JC_Date_Received_1	datetime

	JC_Date_Received_2	datetime

	JC_Date_Received_3	datetime

	JC_Date_Received_4	datetime

	JC_Date_Received_5	datetime

	JC_Date_Received_6	datetime

	JC_Date_Received_7	datetime

	JC_Date_Received_8	datetime

	JC_Date_Received_9	datetime

	JC_Date_Received_10	datetime

	JC_Date_Received_11	datetime

	JC_Date_Received_12	datetime

	JC_Date_Received_13	datetime

	JC_Date_Received_14	datetime

	JC_Date_Received_15	datetime

	JC_Date_Received_16	datetime

	JC_Date_Received_17	datetime

	JC_Date_Received_18	datetime

	JC_Date_Received_19	datetime

	JC_Date_Received_20	datetime

	Ins_Cert_Received	tinyint

	Lien_Waiver_Received	tinyint

	O_M_Manuals_Received	tinyint

	Payment_Bond_Received	tinyint

	Performance_Bond_Receive	tinyint

	JC_Required_Received_1	tinyint

	JC_Required_Received_2	tinyint

	JC_Required_Received_3	tinyint

	JC_Required_Received_4	tinyint

	JC_Required_Received_5	tinyint

	JC_Required_Received_6	tinyint

	JC_Required_Received_7	tinyint

	JC_Required_Received_8	tinyint

	JC_Required_Received_9	tinyint

	JC_Required_Received_10	tinyint

	JC_Required_Received_11	tinyint

	JC_Required_Received_12	tinyint

	JC_Required_Received_13	tinyint

	JC_Required_Received_14	tinyint

	JC_Required_Received_15	tinyint

	JC_Required_Received_16	tinyint

	JC_Required_Received_17	tinyint

	JC_Required_Received_18	tinyint

	JC_Required_Received_19	tinyint

	JC_Required_Received_20	tinyint

	USERID	char(15)	The user t...(more) Join Now
join ... more text available
	User_Define_1	char(31)

	User_Define_2	char(31)

	USERDEF1	char(21)	UserDefine...(more) Join Now

	USERDEF2	char(21)	UserDefine...(more) Join Now

	User_Defined_CB_1	tinyint

	User_Defined_CB_2	tinyint

	User_Defined_CB_3	tinyint

	User_Defined_CB_4	tinyint

	USRDAT01	datetime

	USRDAT02	datetime

	User_Defined_Date_3	datetime

	User_Defined_Date_4	datetime

	User_Defined_Dollar_1	numeric(19,5)

	User_Defined_Dollar_2	numeric(19,5)

	User_Defined_Dollar_3	numeric(19,5)

	User_Defined_Dollar_4	numeric(19,5)

	User_Def_Integer_1	int

	User_Def_Integer_2	int

	User_Defined_Integer_3	int

	User_Defined_Integer_4	int

	MDFUSRID	char(15)	User that ...(more) Join Now
join ... more text available
	MODIFDT	datetime	Date the r...(more) Join Now

	Modified_Time	datetime

	SV_Language_ID	smallint

	Wennsoft_Affiliate	char(15)

	Wennsoft_Branch	char(15)

	Wennsoft_Region	char(15)

	WSReserved_CB1	tinyint

	WSReserved_CB2	tinyint

	WSReserved_CB3	tinyint

	WSReserved_CB4	tinyint

	WSReserved_CB5	tinyint

	WSReserved_STR1	char(11)

	WSReserved_STR2	char(11)

	DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

DynDeveloper.com

COMPANY..JC01504 Table Definition

Field Definitions: