Table and Column Changes in Dynamics GP 2015

Views (29675)

Dan Peltier

Like(2)

Report

Hello everyone!

Microsoft Dynamics GP 2015 has recently released, and with it comes the usual back-end changes to columns and tables! There's a lot of them this time around, so be sure to follow the links to navigate around the page! If you have questions, refer first to the GP 2015 SDK documentation.

Please note that the table and column changes listed below are a comprehensive and cumulative listing of all changes that have occurred since GP 2013 RTM.

New Tables

All New Columns

Deleted Columns

New Tables in GP 2015 That Did Not Exist in GP 2013 RTM

Table Technical Name	Table Physical Name
Batch_Headers_HIST	SY30500
cmUnreconciledTrx	CM20502
coAttachEmail	CO00105
coAttachProperties	CO00103
coAttachStatus	CO00104
GL_Transaction_Paste_TEMP	TEMP
ivItemClassIncludeInCatalog	IV00120
ivItemIncludeInCatalog	IV00119
IV_Site_Item_Assignments_TEMP	TEMP
IV_Suggest_Sales_Analysis_Line_TEMP	TEMP
PM_Vendor_Combiner_Modifier_TEMP	TEMP
PM_Vendor_Validation_TEMP	TEMP
popFeaturedItems	POP40300
popRequisition	POP10200
popRequisitionHist	POP30200
popRequisitionInquiryTemp	TEMP
popRequisitionLine	POP10210
popRequisitionLineHist	POP30210
popRequisitionLineTemp	TEMP
popRequisitionTemp	TEMP
popRequisitionUserAccess	POP40200
popRequisitionUserAccessTemp	TEMP
POP_PORcptApplyTemp	TEMP
QueryDesigner_Conditions	CO00123
QueryDesigner_ConditionsTemp	TEMP
QueryDesigner_FieldLinkTemp	TEMP
QueryDesigner_FieldsList	CO00121
QueryDesigner_FieldsListTemp	TEMP
QueryDesigner_Relationships	CO00122
QueryDesigner_RelationshipsTemp	Temp
rmEmailStmtsHDRTemp	RM50105
RM_Customer_Combiner_Modifier_TEMP	TEMP
RM_Customer_Validation_TEMP	TEMP
syEmailCardAddress	SY04906
syEmailCardAddressTemp	TEMP
syEmailDocumentLines	SY04930
syOfflineCompanies	SY01800
syOfflineCompaniesHistory	SY01801
sySelectedUserMessage	TEMP
syUserMessages	SY30000
SY_BackupRestoreMSTR	SY01451
TimecardCurrentListTemp	TEMP
uprMstrTCAssignment	UPR00210
uprMstrTCAssignmentDetail	UPR00211
uprMstrTCAssignmentDetailTemp	TEMP
uprMstrTimeonBehalf	UPR00200
uprMstrTimeonBehalfClass	UPR00202
uprMstrTimeonBehalfDept	UPR00201
uprMstrTimeonBehalfEmp	UPR00203
uprMstrTimeonBehalfTEMP	TEMP
uprReportsToStructureForEmp	TEMP
uprSetupBatchPrefix	UPR42500
uprSetupBatchPrefixClass	UPR42504
uprSetupBatchPrefixDept	UPR42502
uprSetupBatchPrefixEmployee	UPR42505
uprSetupBatchPrefixLocation	UPR42501
uprSetupBatchPrefixPosition	UPR42503
uprSetupBatchPrefixTEMP	TEMP
uprSetupPayScheduleClass	UPR42105
uprSetupPayScheduleClassTEMP	TEMP
uprSetupPayScheduleDept	UPR42103
uprSetupPayScheduleDeptTEMP	TEMP
uprSetupPayScheduleDtl	UPR42101
uprSetupPayScheduleDtlTEMP	TEMP
uprSetupPayScheduleEmployee	UPR42106
uprSetupPayScheduleEmployeeTEMP	TEMP
uprSetupPayScheduleHdr	UPR42100
uprSetupPayScheduleLocation	UPR42102
uprSetupPayScheduleLocationTEMP	TEMP
uprSetupPaySchedulePosition	UPR42104
uprSetupPaySchedulePositionTEMP	TEMP
uprSetupScheduleSequence	UPR42110
uprSetupScheduleSequenceTEMP	TEMP
uprSetupScheduleUnSequenceTEMP	TEMP
uprSetupTCAssignment	UPR42300
uprSetupTCAssignmentDetail	UPR42301
uprSetupTCAssignmentDetailTemp	TEMP
uprSetupTimeCardRestrictions	UPR42400
uprSetupTimeCardRestrictionsClass	UPR42405
uprSetupTimeCardRestrictionsDept	UPR42403
uprSetupTimeCardRestrictionsDTL	UPR42401
uprSetupTimeCardRestrictionsEmployee	UPR42406
uprSetupTimeCardRestrictionsLocation	UPR42402
uprSetupTimeCardRestrictionsPosition	UPR42404
uprSetupTimeCardRestrictionsTEMP	TEMP
uprSetupTimeonBehalf	UPR42200
uprSetupTimeonBehalfClass	UPR42202
uprSetupTimeonBehalfDept	UPR42201
uprSetupTimeonBehalfEmp	UPR42203
uprSetupTimeonBehalfTEMP	TEMP
uprTimecardDtl	UPR10501
uprTimecardEntryTrxDtlTEMP	TEMP
uprTimecardEntryTrxStartStopTEMP	TEMP
uprTimecardEntryTrxTEMP	TEMP
uprTimecardHdr	UPR10500
uprTimecardHomepageTemp	TEMP
uprTimecardStartStopDtl	UPR10502
uprTimecardTemplateStartStop	UPR00222
uprTimecardTemplateTrx	UPR00220
uprTimecardTemplateTrxDtl	UPR00221
uprTimecardTemplTrxDtlTEMP	TEMP
uprTimecardTemplTrxStartStopTEMP	TEMP
uprTimecardTemplTrxTEMP	TEMP
uprTmcdDtlHIST	UPR30501
uprTmcdHdrHIST	UPR30500
uprTmcdStartStopHIST	UPR30502
UPR_SETP_Timecard_Options	UPR40202
Workflow_Calendar	WF40300
Workflow_Calendar_Down_Days	WF40310
Workflow_Document_Steps	TEMP
Workflow_Email_Notifications	WF40400
Workflow_History	WF30100
Workflow_History_Scroll_TEMP	TEMP
Workflow_History_TEMP	TEMP
Workflow_Instance	WFI10002
Workflow_Master	WF100002
Workflow_Roles	WF40201
Workflow_Setup	WF00100
Workflow_Step	WF100003
Workflow_Step_Instance	WFI10003
Workflow_Step_Instance_Users	WFI10005
Workflow_Tasks	WFI10004
Workflow_Tasks_Homepage_TEMP	TEMP
Workflow_Template_Fields	WF40202
Workflow_Template_Fields_TEMP	TEMP
Workflow_Type	WF100001
Workflow_Type_Conditions_TEMP	TEMP
Workflow_Type_TEMP	TEMP
Workflow_Users	WF40200
Workflow_User_Delegation_LINE	WF40510
Workflow_User_Delegation_MSTR	WF40500
Workflow_User_Security	WF00104

New Columns in GP 2015 That Did Not Exist in GP 2013 RTM

Table Technical Name	Table Physical Name	Field Technical Name	Field Physical Name
Batch_Headers	SY00500	Workflow Status	Workflow_Status
Batch_Headers_DUP	SY00500	Workflow Status	Workflow_Status
Batch_Headers_HIST	SY30500	Approval	APPROVL
		Approval Date	APPRVLDT
		Approval User ID	APRVLUSERID
		Batch Comment	BCHCOMNT
		Batch Date	BACHDATE
		Batch Number	BACHNUMB
		Batch Source	BCHSOURC
		Batch Total	BCHTOTAL
		Checkbook ID	CHEKBKID
		Control Total	CNTRLTOT
		Control TRX Count	CNTRLTRX
		Created Date	CREATDDT
		Currency ID	CURNCYID
		GL Posting Date	GLPOSTDT
		Modified Date	MODIFDT
		Number Of TRX	NUMOFTRX
		Origin	ORIGIN
		Recurring TRX Sequence	RCTRXSEQ
		Reverse Batch	RVRSBACH
		Series	SERIES
		Time	TIME1
		TRX Source	TRXSORCE
		User ID	USERID
		Workflow Status	Workflow_Status
cmUnreconciledTrx	CM20502	Audit Trail Code	AUDITTRAIL
		Checkbook ID	CHEKBKID
		Cleared Amount	ClrdAmt
		Cleared Date	clearedate
		CM Trx Number	CMTrxNum
		CM Trx Type	CMTrxType
		CMLinkID	CMLinkID
		Currency ID	CURNCYID
		Deposit Type	DEPTYPE
		Description	DSCRIPTN
		Paid ToRcvd From	paidtorcvdfrom
		Reconcile Number	RECONUM
		Record Number	CMRECNUM
		Source Doc Number	SRCDOCNUM
		Source Doc Type	SRCDOCTYP
		Source Document	SOURCDOC
		TRX Amount	TRXAMNT
		TRX Date	TRXDATE
		User ID	USERID
coAttachEmail	CO00105	Attachment ID	Attachment_ID
		BusObjKey	BusObjKey
		Created Date	CREATDDT
		Created Time	CREATETIME
		Delete	DELETE1
		Document Number	DOCNUMBR
		Email Allow Attachments	EmailAllowAttachments
		File Type	FileType
		fileName	fileName
		Ord	ORD
		Size	Size
		Start Description	STRTDSCR
coAttachmentTemp	temp	Allow Attachment Email	AllowAttachmentEmail
		Allow Attachment Flow	AllowAttachmentFlow
		Attachment Image	AttachmentImage
		Attachment Product Details	AttachmentProductDetails
		Delete	DELETE1
coAttachMSTR	CO00101	Attachment Image	AttachmentImage
		Attachment Product Details	AttachmentProductDetails
coAttachProperties	CO00103	Allow Attachments Email	AllowAttachmentsEmail
		Attachment Attribute Default	AttachAttributeDefault
		Attachment ID	Attachment_ID
		Attribute Short Name	AttributeShortName
		BusObjKey	BusObjKey
		Default Attach Type	DefaultAttachType
coAttachRef	CO00102	Allow Attachment Email	AllowAttachmentEmail
		Allow Attachment Flow	AllowAttachmentFlow
		Attachment Origin	AttachmentOrigin
		Delete	DELETE1
coAttachSetup	CO40100	Allow Attachments Email	AllowAttachmentsEmail
		Allow To Delete	AllowToDelete
		Attachment Attribute Default	AttachAttributeDefault
		Attribute	Attribute
		Customer Attachment Type	CustomerAttachmentType
		Delete Password	DeletePassword
		Item Attachment Type	ItemAttachmentType
		Vendor Attachment Type	VendorAttachmentType
coAttachStatus	CO00104	Attachment ID	Attachment_ID
		Attachment Status	AttachmentStatus
		BusObjKey	BusObjKey
		Created Date	CREATDDT
		Created Time	CREATETIME
		Created User ID	CRUSRID
ddACHCopy	DD10200	IndexLong	INDXLONG
ddACHCrossRef	DD10300	IndexLong	INDXLONG
ddACHFtrSetup	DD40400	IndexLong	INDXLONG
ddACHHdr	DD10400	IndexLong	INDXLONG
ddACHHdrSetup	DD40400	IndexLong	INDXLONG
ddACHItems	DD10500	IndexLong	INDXLONG
ddEmpAcctMstr	DD00200	IndexLong	INDXLONG
ddEmpAcctsTemp	temp	IndexLong	INDXLONG
ddEmpLineTemp	TEMP	IndexLong	INDXLONG
ddEmpMstr	DD00100	IndexLong	INDXLONG
ddExceptions	DD10700	IndexLong	INDXLONG
ddTrxHistDetail	DD30101	IndexLong	INDXLONG
ddTrxHistHdr	DD30100	IndexLong	INDXLONG
EmployeeListTemp	TEMP	User ID	USERID
GL_Reconcile_IV_WORK_TEMP	TEMP	Sequence Number	SEQNUMBR
GL_Transaction_Paste_TEMP	TEMP	Account Index	ACTINDX
		Account Number String	ACTNUMST
		Credit Amount	CRDTAMNT
		Debit Amount	DEBITAMT
		Description	DSCRIPTN
		Error Status	ErrorStatus
		IndexLong	INDXLONG
ivItemClassIncludeInCatalog	IV00120	Include In Catalog	INCLUDEINCATALOG
		Item Class Code	ITMCLSCD
ivItemIncludeInCatalog	IV00119	Include In Catalog	INCLUDEINCATALOG
		Item Number	ITEMNMBR
IV_Site_Item_Assignments_TEMP	TEMP	Inactive	INACTIVE
		Inactive Old	InactiveOld
		Item Number	ITEMNMBR
		Landed Cost Group ID	Landed_Cost_Group_ID
		Landed Cost Group ID Old	LandedCostGroupIDOld
		Location Code	LOCNCODE
		Marked	MARKED
		Picking Ticket Item Option	PICKTICKETITEMOPT
		Picking Ticket Item Option Old	PICKTICKETITEMOPTOLD
		Primary Vendor	PRIMVNDR
		Record Type	RCRDTYPE
		Selected To Save	SelectedToSave
		Vendor ID	VENDORID
		VS Inactive Site	VSInactiveSite
IV_Suggest_Sales_Analysis_Line_TEMP	TEMP	Decimal Places QTYS Suggest Items	DecimalPlacesQTYSSugItem
		Inactive	INACTIVE
		Item Type	ITEMTYPE
		Match Percent	MATCHPER
		Sales Script	SALESSCRIPT
		Suggest Item Order	SUGITEMORD
		Suggest_Item_Description	SUGITEMDEC
		Suggest_Item_Number	SUGITEMNMBR
		Suggest_Quantity	SUGQUANTITY
IV_Suggest_Sales_Setup_LINE	IV00401	Sales Script	SALESSCRIPT
IV_Suggest_Sales_Setup_LINE_TEMP	TEMP	Sales Script	SALESSCRIPT
MC_PM_Revaluation	MC020105	Settled Gain or Loss on Current Trx Amount	SettledGainLossCurTrxAmt
		Settled Gain or Loss on Disc Avail Amount	SettledGainLossDiscAvlAm
MUPR_DDNextIdx	DD40700	IndexLong	INDXLONG
PM_SETP	PM40100	PMDefaultCheckSort	PMDefaultCheckSort
PM_Vendor_Combiner_Modifier_TEMP	TEMP	IndexLong	INDXLONG
		Vendor ID From	VendorIDFrom
		Vendor ID To	VendorIDTo
		Vendor Name From	VendorNameFrom
		Vendor Name To	VendorNameTo
PM_Vendor_Validation_TEMP	TEMP	IndexLong	INDXLONG
		ValidationMessages	ValidationMessages
		Vendor ID From	VendorIDFrom
		Vendor ID To	VendorIDTo
popFeaturedItems	POP40300	Decimal Places Currency	DECPLCUR
		Item Description	ITEMDESC
		Item Number	ITEMNMBR
		Non IV	NONINVEN
		Ord	ORD
		U Of M	UOFM
		Unit Cost	UNITCOST
		Vendor ID	VENDORID
popRequisition	POP10200	Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Created Date	CREATDDT
		Document Amount	DOCAMNT
		Document Date	DOCDATE
		Domain User Name	DomainUserName
		Fax	FAX
		Flags	Flags
		Modified Date	MODIFDT
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Primary Shipto Address Code	PRSTADCD
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Description	RequisitionDescription
		Requisition Note Index	Requisition_Note_Index
		Requisition Status	RequisitionStatus
		State	STATE
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		User To Enter	USER2ENT
		Workflow Status	Workflow_Status
		Zip Code	ZIPCODE
popRequisitionHist	POP30200	Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Created Date	CREATDDT
		Document Amount	DOCAMNT
		Document Date	DOCDATE
		Domain User Name	DomainUserName
		Fax	FAX
		Flags	Flags
		Modified Date	MODIFDT
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Primary Shipto Address Code	PRSTADCD
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Description	RequisitionDescription
		Requisition Note Index	Requisition_Note_Index
		Requisition Status	RequisitionStatus
		State	STATE
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		User To Enter	USER2ENT
		Voided	VOIDED
		Workflow Status	Workflow_Status
		Zip Code	ZIPCODE
popRequisitionInquiryTemp	TEMP	Document Amount	DOCAMNT
		Document Date	DOCDATE
		History	HISTORY
		LineNumber	LineNumber
		Ord	ORD
		POP Requisition Number	POPRequisitionNumber
		Primary Shipto Address Code	PRSTADCD
		QTY To Purchase	QTYTOPURCH
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Description	RequisitionDescription
		Requisition Status	RequisitionStatus
		Vendor ID	VENDORID
		Workflow Status	Workflow_Status
popRequisitionLine	POP10210	Account Note Index	ACCNTNTINDX
		Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		Address Code	ADRSCODE
		Address Source	ADDRSOURCE
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Currency ID	CURNCYID
		Currency Index	CURRNIDX
		Currency Note Index	Currency_Note_Index
		Decimal Places Currency	DECPLCUR
		Decimal Places QTYS	DECPLQTY
		Denomination Exchange Rate	DENXRATE
		Exchange Date	EXCHDATE
		Exchange Rate	XCHGRATE
		Exchange Table ID	EXGTBLID
		Extended Cost	EXTDCOST
		Fax	FAX
		Flags	Flags
		Freight Amount	FRTAMNT
		Invalid Data Flag	InvalidDataFlag
		Inventory Index	INVINDX
		Item Description	ITEMDESC
		Item Number	ITEMNMBR
		Item Number Note Index	Item_Number_Note_Index
		Item Tracking Option	ITMTRKOP
		LineNumber	LineNumber
		Location Code	LOCNCODE
		Location Code Note Index	Location_Code_Note_Index
		MC Transaction State	MCTRXSTT
		Non IV	NONINVEN
		Ord	ORD
		Originating Decimal Places Currency	ODECPLCU
		Originating Extended Cost	OREXTCST
		Originating Freight Amount	ORFRTAMT
		Originating Tax Amount	ORTAXAMT
		Originating Unit Cost	ORUNTCST
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Print Phone Number GB	Print_Phone_NumberGB
		QTY Committed In Base	QTYCMTBASE
		QTY Ordered	QTYORDER
		QTY Uncommitted In Base	QTYUNCMTBASE
		Rate Calc Method	RATECALC
		Rate Type ID	RATETPID
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Line Status	RequisitionLineStatus
		Shipping Method	SHIPMTHD
		Shipping Method Note Index	ShippingMethodNoteIndex
		State	STATE
		Tax Amount	TAXAMNT
		Time	TIME1
		U Of M	UOFM
		U Of M QTY In Base	UMQTYINB
		Unit Cost	UNITCOST
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		Valuation Method	VCTNMTHD
		Vendor ID	VENDORID
		Vendor Note Index	Vendor_Note_Index
		Zip Code	ZIPCODE
popRequisitionLineHist	POP30210	Account Note Index	ACCNTNTINDX
		Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		Address Code	ADRSCODE
		Address Source	ADDRSOURCE
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Currency ID	CURNCYID
		Currency Index	CURRNIDX
		Currency Note Index	Currency_Note_Index
		Decimal Places Currency	DECPLCUR
		Decimal Places QTYS	DECPLQTY
		Denomination Exchange Rate	DENXRATE
		Exchange Date	EXCHDATE
		Exchange Rate	XCHGRATE
		Exchange Table ID	EXGTBLID
		Extended Cost	EXTDCOST
		Fax	FAX
		Flags	Flags
		Freight Amount	FRTAMNT
		Invalid Data Flag	InvalidDataFlag
		Inventory Index	INVINDX
		Item Description	ITEMDESC
		Item Number	ITEMNMBR
		Item Number Note Index	Item_Number_Note_Index
		Item Tracking Option	ITMTRKOP
		LineNumber	LineNumber
		Location Code	LOCNCODE
		Location Code Note Index	Location_Code_Note_Index
		MC Transaction State	MCTRXSTT
		Non IV	NONINVEN
		Ord	ORD
		Originating Decimal Places Currency	ODECPLCU
		Originating Extended Cost	OREXTCST
		Originating Freight Amount	ORFRTAMT
		Originating Tax Amount	ORTAXAMT
		Originating Unit Cost	ORUNTCST
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Print Phone Number GB	Print_Phone_NumberGB
		QTY Committed In Base	QTYCMTBASE
		QTY Ordered	QTYORDER
		QTY Uncommitted In Base	QTYUNCMTBASE
		Rate Calc Method	RATECALC
		Rate Type ID	RATETPID
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Line Status	RequisitionLineStatus
		Shipping Method	SHIPMTHD
		Shipping Method Note Index	ShippingMethodNoteIndex
		State	STATE
		Tax Amount	TAXAMNT
		Time	TIME1
		U Of M	UOFM
		U Of M QTY In Base	UMQTYINB
		Unit Cost	UNITCOST
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		Valuation Method	VCTNMTHD
		Vendor ID	VENDORID
		Vendor Note Index	Vendor_Note_Index
		Zip Code	ZIPCODE
popRequisitionLineTemp	TEMP	Account Note Index	ACCNTNTINDX
		Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		Address Code	ADRSCODE
		Address Source	ADDRSOURCE
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Currency ID	CURNCYID
		Currency Index	CURRNIDX
		Currency Note Index	Currency_Note_Index
		Decimal Places Currency	DECPLCUR
		Decimal Places QTYS	DECPLQTY
		Denomination Exchange Rate	DENXRATE
		Exchange Date	EXCHDATE
		Exchange Rate	XCHGRATE
		Exchange Table ID	EXGTBLID
		Extended Cost	EXTDCOST
		Fax	FAX
		Flags	Flags
		Freight Amount	FRTAMNT
		Invalid Data Flag	InvalidDataFlag
		Inventory Index	INVINDX
		Item Description	ITEMDESC
		Item Number	ITEMNMBR
		Item Number Note Index	Item_Number_Note_Index
		Item Tracking Option	ITMTRKOP
		LineNumber	LineNumber
		Location Code	LOCNCODE
		Location Code Note Index	Location_Code_Note_Index
		MC Transaction State	MCTRXSTT
		Non IV	NONINVEN
		Ord	ORD
		Originating Decimal Places Currency	ODECPLCU
		Originating Extended Cost	OREXTCST
		Originating Freight Amount	ORFRTAMT
		Originating Tax Amount	ORTAXAMT
		Originating Unit Cost	ORUNTCST
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Print Phone Number GB	Print_Phone_NumberGB
		QTY Committed In Base	QTYCMTBASE
		QTY Ordered	QTYORDER
		QTY Uncommitted In Base	QTYUNCMTBASE
		Rate Calc Method	RATECALC
		Rate Type ID	RATETPID
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Line Status	RequisitionLineStatus
		Shipping Method	SHIPMTHD
		Shipping Method Note Index	ShippingMethodNoteIndex
		State	STATE
		Tax Amount	TAXAMNT
		Time	TIME1
		U Of M	UOFM
		U Of M QTY In Base	UMQTYINB
		Unit Cost	UNITCOST
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		Valuation Method	VCTNMTHD
		Vendor ID	VENDORID
		Vendor Note Index	Vendor_Note_Index
		Zip Code	ZIPCODE
popRequisitionTemp	TEMP	Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		City	CITY
		Comment ID	COMMNTID
		Comment Note Index	Comment_Note_Index
		Company Name	CMPNYNAM
		Contact	CONTACT
		Country	COUNTRY
		Country Code	CCode
		Created Date	CREATDDT
		Document Amount	DOCAMNT
		Document Date	DOCDATE
		Domain User Name	DomainUserName
		Fax	FAX
		Flags	Flags
		Modified Date	MODIFDT
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		POP Requisition Number	POPRequisitionNumber
		Primary Shipto Address Code	PRSTADCD
		Requested By	REQSTDBY
		Required Date	REQDATE
		Requisition Description	RequisitionDescription
		Requisition Note Index	Requisition_Note_Index
		Requisition Status	RequisitionStatus
		State	STATE
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		User To Enter	USER2ENT
		Workflow Status	Workflow_Status
		Zip Code	ZIPCODE
popRequisitionUserAccess	POP40200	Edit Access All	EditAccessAll
		Edit Access Created By	EditAccessCreatedBy
		Index	INDEX1
		User ID	USERID
popRequisitionUserAccessTemp	TEMP	Changed	CHANGED
		Edit Access All	EditAccessAll
		Edit Access Created By	EditAccessCreatedBy
		Index	INDEX1
		Original Edit Access All	OriginalEditAccessAll
		Original Edit Access Created By	OrigEditAccessCreateBy
		User ID	USERID
popSelectPOItemsTemp	TEMP	Workflow Status	Workflow_Status
POP_PO	POP10100	Workflow Status	Workflow_Status
POP_POHist	POP30100	Workflow Status	Workflow_Status
POP_POLine	POP10110	QTY Committed In Base Orig	QTYCommittedInBaseOrig
POP_PORcptApplyTemp	TEMP	Accrued Purchases Index	ACPURIDX
		Apply Type	APPYTYPE
		Capital Item	Capital_Item
		Cost Code	COSTCODE
		Cost Code Type	COSTTYPE
		Currency ID	CURNCYID
		Currency Index	CURRNIDX
		Date Received	DATERECD
		Denomination Exchange Rate	DENXRATE
		Exchange Rate	XCHGRATE
		Exchange Table ID	EXGTBLID
		Inventory Index	INVINDX
		Item Number	ITEMNMBR
		Job Number	JOBNUMBR
		Note Index	NOTEINDX
		Old Current Cost	OLDCUCST
		Originating Extended Cost	OREXTCST
		Originating Receipt Cost	ORCPTCOST
		Originating Standard Cost	OSTDCOST
		PO Line Number	POLNENUM
		PO Number	PONUMBER
		POP Receipt Number	POPRCTNM
		POP Type	POPTYPE
		Posted LC PPV Amount	Posted_LC_PPV_Amount
		Product Indicator	Product_Indicator
		Purchase Receipt Cost	PCHRPTCT
		QTY Invoice Adjustment	QTYINVADJ
		QTY Invoice Reserve	QTYINVRESERVE
		QTY Invoiced	QTYINVCD
		QTY Matched	QTYMATCH
		QTY Rejected	QTYREJ
		QTY Replaced	QTYREPLACED
		QTY Reserved	QTYRESERVED
		QTY Shipped	QTYSHPPD
		QTY Type	QTYTYPE
		Rate Calc Method	RATECALC
		Rate Type ID	RATETPID
		Receipt Line Number	RCPTLNNM
		Receipt SEQ Number	RCTSEQNM
		Remaining UPPV Amount	RUPPVAMT
		Split Receipt Cost	SPRCPTCT
		Split Receipt SEQ Number	SPRCTSEQ
		Status	Status
		Total Landed Cost Amount	Total_Landed_Cost_Amount
		TRX Location	TRXLOCTN
		U Of M	UOFM
		U Of M QTY In Base	UMQTYINB
		Unrealized Purchase Price Variance Index	UPPVIDX
		Vendor ID	VENDORID
POP_PO_TEMP	TEMP	Workflow Status	Workflow_Status
POP_Setup	POP40100	POP Requisition Number	POPRequisitionNumber
		Req Hdr User Defined Prompt 1	Req_Hdr_UD_Prompt1
		Req Hdr User Defined Prompt 2	Req_Hdr_UD_Prompt2
		Req Line User Defined Prompt 1	Req_Line_UD_Prompt1
		Req Line User Defined Prompt 2	Req_Line_UD_Prompt2
		Requisition Code	RequisitionCode
		Requisition Cost Selection	RequisitionCostSelection
		Requisition Create One PO Per Address	ReqCreateOnePOPerAddress
		Requisition Default Doc Date	RequisitionDefDocDate
		Requisition Default Site Method	RequisitionDefSiteMethod
		Requisition Maintain History	RequisitionMaintainHist
		Requisition Transfer Line Comments	ReqTransferLineComments
		Requisition Vendor Selection	RequisitionVendorSelect
		SearchPOQtysFromRequisition	SearchPOQtysFromRequisit
POP_ShipIvcApply	POP10600	Backout Tax Amount	BCKTXAMT
		Inventory Index	INVINDX
		Originating Backout Tax Amount	OBTAXAMT
		Percent of Total	PRCNTOFTTL
PurchasingTrxTemp	TEMP	Comment ID	COMMNTID
		Requested By	REQSTDBY
		Requisition Description	RequisitionDescription
		Requisition Status	RequisitionStatus
		User Defined 1	USERDEF1
		User Defined 2	USERDEF2
		Workflow Due Time	Workflow_Due_Time
		Workflow Instance ID	WorkflowInstanceID
		Workflow Status	Workflow_Status
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Type	Workflow_Step_Type
		Workflow Type Name	Workflow_Type_Name
QueryDesigner_Conditions	CO00123	ConditionsGuid	ConditionsGuid
		DateFilter	DateFilter
		EnumFilter	EnumFilter
		FieldComparison	FieldComparison
		FieldDataType	FieldDataType
		FieldsListGuid	FieldsListGuid
		FromDictID	FromDictID
		FromField	FromField
		FromFieldListSequence	FromFieldListSequence
		FromTable	FromTable
		IntegerFilter	IntegerFilter
		NumericFilter	NumericFilter
		QueryConditon	QueryConditon
		QueryOperator	QueryOperator
		Sequence Number	SEQNUMBR
		StringFilter	StringFilter
		TimeFilter	TimeFilter
		ToDictID	ToDictID
		ToField	ToField
		ToFieldListSequence	ToFieldListSequence
		ToTable	ToTable
QueryDesigner_ConditionsTemp	TEMP	ConditionsGuid	ConditionsGuid
		DateFilter	DateFilter
		EnumFilter	EnumFilter
		FieldComparison	FieldComparison
		FieldDataType	FieldDataType
		FieldsListGuid	FieldsListGuid
		FromDictID	FromDictID
		FromField	FromField
		FromFieldListSequence	FromFieldListSequence
		FromTable	FromTable
		IntegerFilter	IntegerFilter
		NumericFilter	NumericFilter
		QueryConditon	QueryConditon
		QueryOperator	QueryOperator
		Sequence Number	SEQNUMBR
		StringFilter	StringFilter
		TimeFilter	TimeFilter
		ToDictID	ToDictID
		ToField	ToField
		ToFieldListSequence	ToFieldListSequence
		ToTable	ToTable
QueryDesigner_FieldLinkTemp	TEMP	FromDictID	FromDictID
		FromField	FromField
		FromFieldPhysicalName	FromFieldPhysicalName
		FromTable	FromTable
		FromTablePhysicalName	FromTablePhysicalName
		ToDictID	ToDictID
		ToField	ToField
		ToFieldPhysicalName	ToFieldPhysicalName
		ToTable	ToTable
		ToTablePhysicalName	ToTablePhysicalName
QueryDesigner_FieldsList	CO00121	Currency Symbol	CRNCYSYM
		Decimal Places Currency	DECPLCUR
		DecimalDigits	DecimalDigits
		DefaultField	DefaultField
		FieldDataType	FieldDataType
		FieldDisplayName	FieldDisplayName
		FieldPhysicalName	FieldPhysicalName
		FieldsListGuid	FieldsListGuid
		FieldSource	FieldSource
		RelativeDecimalPosition	RelativeDecimalPosition
		Sequence Number	SEQNUMBR
		ShowCurrencySymbol	ShowCurrencySymbol
		ShowPercentSign	ShowPercentSign
		TableDictID	TableDictID
		TableDisplayName	TableDisplayName
		TablePhysicalName	TablePhysicalName
		TableSeries	TableSeries
		TableTechnicalName	TableTechnicalName
QueryDesigner_FieldsListTemp	TEMP	Currency Symbol	CRNCYSYM
		Decimal Places Currency	DECPLCUR
		DecimalDigits	DecimalDigits
		DefaultField	DefaultField
		FieldDataType	FieldDataType
		FieldDisplayName	FieldDisplayName
		FieldPhysicalName	FieldPhysicalName
		FieldsListGuid	FieldsListGuid
		FieldSource	FieldSource
		RelativeDecimalPosition	RelativeDecimalPosition
		Sequence Number	SEQNUMBR
		ShowCurrencySymbol	ShowCurrencySymbol
		ShowPercentSign	ShowPercentSign
		TableDictID	TableDictID
		TableDisplayName	TableDisplayName
		TablePhysicalName	TablePhysicalName
		TableSeries	TableSeries
		TableTechnicalName	TableTechnicalName
QueryDesigner_Relationships	CO00122	FieldsListGuid	FieldsListGuid
		FromDictID	FromDictID
		FromField	FromField
		FromFieldPhysicalName	FromFieldPhysicalName
		FromTable	FromTable
		FromTablePhysicalName	FromTablePhysicalName
		Group ID	Group_ID
		JoinType	JoinType
		Sequence Number	SEQNUMBR
		ToDictID	ToDictID
		ToField	ToField
		ToFieldPhysicalName	ToFieldPhysicalName
		ToTable	ToTable
		ToTablePhysicalName	ToTablePhysicalName
QueryDesigner_RelationshipsTemp	Temp	FieldsListGuid	FieldsListGuid
		FromDictID	FromDictID
		FromField	FromField
		FromFieldPhysicalName	FromFieldPhysicalName
		FromTable	FromTable
		FromTablePhysicalName	FromTablePhysicalName
		Group ID	Group_ID
		JoinType	JoinType
		Sequence Number	SEQNUMBR
		ToDictID	ToDictID
		ToField	ToField
		ToFieldPhysicalName	ToFieldPhysicalName
		ToTable	ToTable
		ToTablePhysicalName	ToTablePhysicalName
rmEmailStmtsHDRTemp	RM50105	Address 1	ADDRESS1
		Address 2	ADDRESS2
		Address 3	ADDRESS3
		Aging Period Amounts	AGPERAMT
		Aging Periods Descriptions	AGPERDSC
		Amount Due	AMNTDUE
		City	CITY
		Company ID	CMPANYID
		Contact Person	CNTCPRSN
		Currency ID	CURNCYID
		Currency Index	CURRNIDX
		Customer Balance	CUSTBLNC
		Customer Messages	CUSTMSGS
		Customer Number	CUSTNMBR
		Date	DATE1
		Deposits Received	DEPRECV
		Description	DSCRIPTN
		Document Array Abbreviation	DOCARABR
		Document Array Description	DOCARDSC
		Location ID	LOCATNID
		Minimum Payment Due	MINPYDUE
		Payment Terms ID	PYMTRMID
		Phone 1	PHONE1
		Phone 2	PHONE2
		Phone 3	PHONE3
		Printing Status	PRNTSTUS
		Process Index	Process_Index
		Run Number	RNNMBR
		State	STATE
		Statement ID	STMNTID
		Statement Messages	STMTMSGS
		Statement Name	STMTNAME
		User ID	USERID
		Zip	ZIP
RM_Customer_Combiner_Modifier_TEMP	TEMP	Customer Name From	CustomerNameFrom
		Customer Name To	CustomerNameTo
		Customer Number From	Customer_Number_From
		Customer Number To	Customer_Number_To
		IndexLong	INDXLONG
RM_Customer_Validation_TEMP	TEMP	Customer Number From	Customer_Number_From
		Customer Number To	Customer_Number_To
		IndexLong	INDXLONG
		ValidationMessages	ValidationMessages
RM_Statements_ROPT	RM40501	Print Remaining Docs	PrintRemainingDocs
SOP_POGenItem	temp	Invalid Data Flag	InvalidDataFlag
		Inventory Index	INVINDX
		Requested By	REQSTDBY
		Shipping Method	SHIPMTHD
SOP_POGenPO	temp	Invalid Data Flag	InvalidDataFlag
SOP_POGenSOLine	temp	Address Source	ADDRSOURCE
		Break Field 2	BRKFLD2
		Currency ID	CURNCYID
		Freight Amount	FRTAMNT
		Inventory Index	INVINDX
		Item Number	ITEMNMBR
		Non IV	NONINVEN
		Originating Freight Amount	ORFRTAMT
		Requested By	REQSTDBY
		Requisition Date	REQTNDT
		Requisition Description	RequisitionDescription
		SOPO SOLINE Errors 2	SOPO_SOLINE_Errors_2
		Unit Cost In Base U Of M	UNITCOSTINBSUOFM
SOP_POGenVendor	temp	Invalid Data Flag	InvalidDataFlag
SOP_POPLink	SOP60100	Document Date	DOCDATE
		Item Description	ITEMDESC
		U Of M	UOFM
SOP_Suggest_Sales_Trx_TEMP	TEMP	QTY Available	QTYAVAIL
		Quantity to Add	QTYTOADD
		Sales Script	SALESSCRIPT
syCurrentResources	SY09400	Avail Limited Users	AvailLmtdUsrs
syEmailCardAddress	SY04906	Address Code	ADRSCODE
		Email Card Address	EmailCardAddress
		Email Card ID	EmailCardID
		Email Dictionary ID	EmailDictionaryID
		Email Document ID	EmailDocumentID
		Email Recipient Type Bcc	EmailRecipientTypeBcc
		Email Recipient Type Cc	EmailRecipientTypeCc
		Email Recipient Type To	EmailRecipientTypeTo
		Email Series ID	EmailSeriesID
		Module	MODULE1
syEmailCardAddressTemp	TEMP	Address Code	ADRSCODE
		Email Card Address	EmailCardAddress
		Email Recipient Type Bcc	EmailRecipientTypeBcc
		Email Recipient Type Cc	EmailRecipientTypeCc
		Email Recipient Type Sort	EmailRecipientTypeSort
		Email Recipient Type To	EmailRecipientTypeTo
syEmailCardSetup	SY04904	Email Address Option	EmailAddressOption
syEmailDocumentLines	SY04930	Email Message ID	EmailMessageID
		Email Message Type	Email_Message_Type
		FieldName	FieldName
		Ord Line	Ord Line
		Sequence Number	SEQNUMBR
		Workflow Type Name	Workflow_Type_Name
syEmailMessages	SY04901	Email Message Type	Email_Message_Type
		Workflow Type Name	Workflow_Type_Name
syEmailReportSetup	SY04950	Email File Format	EmailFileFormat
syListOptions	SY07200	ListOption2	ListOption2
syListViewOptions	SY07225	ListOption2	ListOption2
syOfflineCompanies	SY01800	Company ID	CMPANYID
		Offline Date	Offline_Date
		Offline Message	Offline_Message
		Offline Message Type	Offline_Message_Type
		Offline Time	Offline_Time
		Offline User	Offline_User
syOfflineCompaniesHistory	SY01801	Company ID	CMPANYID
		Offline Date	Offline_Date
		Offline Time	Offline_Time
		Offline User	Offline_User
		Online Date	Online_Date
		Online Time	Online_Time
		Online User	Online_User
		Sequence Number	SEQNUMBR
syReportProcessingStatusHdr	TEMP	Print to File	PRNTOFIL
syReportProcessingStatusLine	TEMP	Print to File	PRNTOFIL
syResourceExclusions	SY05200	Resource Technical Name	RESTECHNAME
sySelectedUserMessage	TEMP	Company ID	CMPANYID
		Company Name	CMPNYNAM
		IsOffline	IsOffline
		Selected User	SelectedUser
		User ID	USERID
syUserMessages	SY30000	Company ID	CMPANYID
		Offline Message	Offline_Message
		Sequence Number	SEQNUMBR
		User ID	USERID
SY_BackupRestoreMSTR	SY01451	Azure storage Account Name	AzureStorageAccName
		Azure URL	AzureURL
		Database Name	DBNAME
		fileName	fileName
		Storage Type	StorageType
		Use compression	Usecompression
SY_Company_MSTR	SY01500	Offline User	Offline_User
SY_Current_Activity	ACTIVITY	Client Type	ClientType
		IsOffline	IsOffline
SY_Security_Operations_Report_TEMP	TEMP	Limited Window	LimitedWindow
SY_Security_Operation_Access_TEMP	TEMP	UserType	UserType
SY_Users_MSTR	SY01400	ADObjectGuid	ADObjectGuid
		SQLLoginID	SQLLoginID
		Web Client User	WCUser
		Window Command Display	WindowCommandDisplay
taxHistoryPrintTemp	temp	Discount Taken Amount	DISTKNAM
		Document Number STR30	DOCNUM30
		GST Discount Amount	GSTDSAMT
TimecardCurrentListTemp	TEMP	Comment Text	CMMTTEXT
		Department	DEPRTMNT
		Division Code	DIVISIONCODE_I
		Employee ID	EMPLOYID
		Employee Name	EMPLNAME
		Employee Suffix	EMPLSUFF
		End Date	ENDDATE
		First Name	FRSTNAME
		Group ID	Group_ID
		InfoValue	InfoValue
		Job Title	JOBTITLE
		Last Name	LASTNAME
		LevelLabel	LVLLABEL
		Location ID	LOCATNID
		Marked To Process	MKTOPROC
		Middle Name	MIDLNAME
		Pay Period	PAYPEROD
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Period Name	PERNAME
		Phone 1	PHONE1
		Phone 2	PHONE2
		Start Date	STRTDATE
		Supervisor	SUPERVISOR
		Supervisor Code	SUPERVISORCODE_I
		Supervisor Employee ID	Supervisor_Employee_ID
		Units To Pay	UNTSTOPY
		User ID	USERID
		Workflow Approver	Workflow_Approver
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Originator	Workflow_Originator
		Workflow Status	Workflow_Status
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Type	Workflow_Step_Type
		Workflow Type Name	Workflow_Type_Name
		Year	YEAR1
uprCrossCompanySummRptsTemp	TEMP	FICA/Med Add Tax Rate	FICAMed_Add_Tax_Rate
		Medicare Tax Additional	Medicare_Tax_Additional
		Medicare Wages and Tips Additional	Med_Wages_and_Tips_Add
uprMstrTCAssignment	UPR00210	Assignment Code	ASSIGNMENTCODE
		Employee ID	EMPLOYID
		Inactive	INACTIVE
uprMstrTCAssignmentDetail	UPR00211	Assignment Code	ASSIGNMENTCODE
		Assignment Type	ASSIGNMENTTYPE
		Employee ID	EMPLOYID
		Time Card Code	TIMECARDCODE
uprMstrTCAssignmentDetailTemp	TEMP	Assignment Code	ASSIGNMENTCODE
		Assignment Type	ASSIGNMENTTYPE
		CB Selected	SELECTED
		Description	DSCRIPTN
		Employee ID	EMPLOYID
		Inactive	INACTIVE
		Time Card Code	TIMECARDCODE
uprMstrTimeonBehalf	UPR00200	Admin Code	Admin_Code
		Employee ID	EMPLOYID
		Inactive	INACTIVE
		Time on Behalf Code	Time_on_Behalf_Code
uprMstrTimeonBehalfClass	UPR00202	Employee Class	EMPLCLAS
		Employee ID	EMPLOYID
		Time on Behalf Code	Time_on_Behalf_Code
uprMstrTimeonBehalfDept	UPR00201	Department	DEPRTMNT
		Employee ID	EMPLOYID
		Time on Behalf Code	Time_on_Behalf_Code
uprMstrTimeonBehalfEmp	UPR00203	Employee ID	EMPLOYID
		Employee ID Assigned	Employee_ID_Assigned
		Time on Behalf Code	Time_on_Behalf_Code
uprMstrTimeonBehalfTEMP	TEMP	Description	DSCRIPTN
		Employee ID	EMPLOYID
		Inactive	INACTIVE
		Included	INCLUDED
		Payroll Code 15U	Payroll_Code_15U
		Time on Behalf Code	Time_on_Behalf_Code
		Time on Behalf Type	Time_on_Behalf_Type
uprReportsToStructureForEmp	TEMP	Employee ID	EMPLOYID
		Employee Suffix	EMPLSUFF
		First Name	FRSTNAME
		Group ID	Group_ID
		Last Name	LASTNAME
		LevelLabel	LVLLABEL
		Middle Name	MIDLNAME
		Phone 1	PHONE1
		Phone 2	PHONE2
		Supervisor	SUPERVISOR
		Supervisor Code	SUPERVISORCODE_I
		Supervisor Employee ID	Supervisor_Employee_ID
		Supervisor First Name	Supervisor_First_Name
		Supervisor Last Name	Supervisor_Last_Name
		Supervisor Middle Name	Supervisor_Middle_Name
		User ID	USERID
uprSetupBatchPrefix	UPR42500	Batch Prefix	Batch_Prefix
		Description	DSCRIPTN
uprSetupBatchPrefixClass	UPR42504	Batch Prefix	Batch_Prefix
		Employee Class	EMPLCLAS
uprSetupBatchPrefixDept	UPR42502	Batch Prefix	Batch_Prefix
		Department	DEPRTMNT
uprSetupBatchPrefixEmployee	UPR42505	Batch Prefix	Batch_Prefix
		Employee ID	EMPLOYID
uprSetupBatchPrefixLocation	UPR42501	Batch Prefix	Batch_Prefix
		Location ID	LOCATNID
uprSetupBatchPrefixPosition	UPR42503	Batch Prefix	Batch_Prefix
		Job Title	JOBTITLE
uprSetupBatchPrefixTEMP	TEMP	Batch Prefix	Batch_Prefix
		CB Selected	SELECTED
		Description	DSCRIPTN
		Inactive	INACTIVE
		Payroll Code 15U	Payroll_Code_15U
		Type ID	TYPEID
uprSetupPayScheduleClass	UPR42105	Employee Class	EMPLCLAS
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleClassTEMP	TEMP	CB Selected	SELECTED
		Description	DSCRIPTN
		Employee Class	EMPLCLAS
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleDept	UPR42103	Department	DEPRTMNT
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleDeptTEMP	TEMP	CB Selected	SELECTED
		Department	DEPRTMNT
		Description	DSCRIPTN
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleDtl	UPR42101	End Date	ENDDATE
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Period Name	PERNAME
		Start Date	STRTDATE
		Year	YEAR1
uprSetupPayScheduleDtlTEMP	TEMP	End Date	ENDDATE
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Period Name	PERNAME
		Start Date	STRTDATE
		Year	YEAR1
uprSetupPayScheduleEmployee	UPR42106	Employee ID	EMPLOYID
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleEmployeeTEMP	TEMP	CB Selected	SELECTED
		Description	DSCRIPTN
		Employee ID	EMPLOYID
		Inactive	INACTIVE
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleHdr	UPR42100	Current Pay Periods	Current_Pay_Periods
		Description	DSCRIPTN
		Past Pay Periods	Past_Pay_Periods
		Pay Period	PAYPEROD
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleLocation	UPR42102	Location ID	LOCATNID
		Pay Schedule	Pay_Schedule
uprSetupPayScheduleLocationTEMP	TEMP	CB Selected	SELECTED
		Location ID	LOCATNID
		Location Name	LOCATNNM
		Pay Schedule	Pay_Schedule
uprSetupPaySchedulePosition	UPR42104	Job Title	JOBTITLE
		Pay Schedule	Pay_Schedule
uprSetupPaySchedulePositionTEMP	TEMP	CB Selected	SELECTED
		Description	DSCRIPTN
		Job Title	JOBTITLE
		Pay Schedule	Pay_Schedule
uprSetupScheduleSequence	UPR42110	Pay Schedule	Pay_Schedule
		Sequence Number	SEQNUMBR
uprSetupScheduleSequenceTEMP	TEMP	Pay Schedule	Pay_Schedule
		Sequence Number	SEQNUMBR
uprSetupScheduleUnSequenceTEMP	TEMP	Pay Schedule	Pay_Schedule
		Sequence Number	SEQNUMBR
uprSetupTCAssignment	UPR42300	Assignment Code	ASSIGNMENTCODE
		Default CB	Default_CB
		Description	DSCRIPTN
		Inactive	INACTIVE
uprSetupTCAssignmentDetail	UPR42301	Assignment Code	ASSIGNMENTCODE
		Assignment Type	ASSIGNMENTTYPE
		Time Card Code	TIMECARDCODE
uprSetupTCAssignmentDetailTemp	TEMP	Assignment Code	ASSIGNMENTCODE
		Assignment Type	ASSIGNMENTTYPE
		CB Selected	SELECTED
		Description	DSCRIPTN
		Inactive	INACTIVE
		Time Card Code	TIMECARDCODE
uprSetupTimeCardRestrictions	UPR42400	Days Worked CB	Days_Worked_CB
		Department CB	Department_CB
		Description	DSCRIPTN
		Local Tax CB	Local_Tax_CB
		Notes CB	Notes_CB
		Per Day CB	Per_Day_CB
		Per Day Max	Per_Day_Max
		Per Pay Period CB	Per_Pay_Period_CB
		Per Period Max	Per_Period_Max
		Per Period Min	Per_Period_Min
		Position CB	Position_CB
		Require Electronic Signature	Require_Electronic_Signa
		Required Start/Stop CB	Required_StartStop_CB
		Restriction Code	Restriction_Code
		Shift CB	Shift_CB
		State Tax CB	State_Tax_CB
		Weeks Worked CB	Weeks_Worked_CB
uprSetupTimeCardRestrictionsClass	UPR42405	Employee Class	EMPLCLAS
		Restriction Code	Restriction_Code
uprSetupTimeCardRestrictionsDept	UPR42403	Department	DEPRTMNT
		Restriction Code	Restriction_Code
uprSetupTimeCardRestrictionsDTL	UPR42401	Days Worked CB	Days_Worked_CB
		Department CB	Department_CB
		Local Tax CB	Local_Tax_CB
		Notes CB	Notes_CB
		Per Day CB	Per_Day_CB
		Per Day Max	Per_Day_Max
		Per Pay Period CB	Per_Pay_Period_CB
		Per Period Max	Per_Period_Max
		Per Period Min	Per_Period_Min
		Position CB	Position_CB
		Require Electronic Signature	Require_Electronic_Signa
		Required Start/Stop CB	Required_StartStop_CB
		Restriction Code	Restriction_Code
		Restriction Type	Restriction_Type
		Shift CB	Shift_CB
		State Tax CB	State_Tax_CB
		Weeks Worked CB	Weeks_Worked_CB
uprSetupTimeCardRestrictionsEmployee	UPR42406	Employee ID	EMPLOYID
		Restriction Code	Restriction_Code
uprSetupTimeCardRestrictionsLocation	UPR42402	Location ID	LOCATNID
		Restriction Code	Restriction_Code
uprSetupTimeCardRestrictionsPosition	UPR42404	Job Title	JOBTITLE
		Restriction Code	Restriction_Code
uprSetupTimeCardRestrictionsTEMP	TEMP	CB Selected	SELECTED
		Description	DSCRIPTN
		Inactive	INACTIVE
		Payroll Code 15U	Payroll_Code_15U
		Restriction Code	Restriction_Code
		Type ID	TYPEID
uprSetupTimeonBehalf	UPR42200	Admin Code	Admin_Code
		Description	DSCRIPTN
		Inactive	INACTIVE
		Time on Behalf Code	Time_on_Behalf_Code
uprSetupTimeonBehalfClass	UPR42202	Employee Class	EMPLCLAS
		Time on Behalf Code	Time_on_Behalf_Code
uprSetupTimeonBehalfDept	UPR42201	Department	DEPRTMNT
		Time on Behalf Code	Time_on_Behalf_Code
uprSetupTimeonBehalfEmp	UPR42203	Employee ID Assigned	Employee_ID_Assigned
		Time on Behalf Code	Time_on_Behalf_Code
uprSetupTimeonBehalfTEMP	TEMP	Description	DSCRIPTN
		Inactive	INACTIVE
		Included	INCLUDED
		Payroll Code 15U	Payroll_Code_15U
		Time on Behalf Code	Time_on_Behalf_Code
		Time on Behalf Type	Time_on_Behalf_Type
uprTimecardDtl	UPR10501	Comment Text	CMMTTEXT
		Days Worked	DAYSWRDK
		Department	DEPRTMNT
		Employee ID	EMPLOYID
		Job Title	JOBTITLE
		Local Tax	LOCALTAX
		Pay Code	PayCode
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Sequence Number	SEQNUMBR
		Shift Code	SHFTCODE
		State Code	STATECD
		TRX Date	TRXDATE
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
		Weeks Worked	WKSWRKD
		Year	YEAR1
uprTimecardEntryTrxDtlTEMP	TEMP	Comment Text	CMMTTEXT
		Days Worked	DAYSWRDK
		Department	DEPRTMNT
		Job Title	JOBTITLE
		Local Tax	LOCALTAX
		Pay Code	PayCode
		Sequence Number	SEQNUMBR
		Shift Code	SHFTCODE
		State Code	STATECD
		TRX Date	TRXDATE
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
		Weeks Worked	WKSWRKD
uprTimecardEntryTrxStartStopTEMP	TEMP	End Time	ENDTIME
		Line SEQ Number	LNSEQNBR
		Start Time	STRTTIME
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
uprTimecardEntryTrxTEMP	TEMP	Daily Hours	Daily_Hours
		Daily TRX Numbers	Daily_TRX_Numbers
		Pay Code	PayCode
		Sequence Number	SEQNUMBR
uprTimecardHdr	UPR10500	Employee ID	EMPLOYID
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Workflow Status	Workflow_Status
		Year	YEAR1
uprTimecardHomepageTemp	TEMP	Pay Code	PayCode
		TRX Date	TRXDATE
		Units To Pay	UNTSTOPY
uprTimecardStartStopDtl	UPR10502	Employee ID	EMPLOYID
		End Time	ENDTIME
		Line SEQ Number	LNSEQNBR
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Start Time	STRTTIME
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
		Year	YEAR1
uprTimecardTemplateStartStop	UPR00222	DayOfWeek	DayOfWeek
		Employee ID	EMPLOYID
		End Time	ENDTIME
		Line SEQ Number	LNSEQNBR
		Sequence Number	SEQNUMBR
		Start Time	STRTTIME
		Units To Pay	UNTSTOPY
uprTimecardTemplateTrx	UPR00220	Daily Hours	Daily_Hours
		Employee ID	EMPLOYID
		Pay Code	PayCode
		Sequence Number	SEQNUMBR
uprTimecardTemplateTrxDtl	UPR00221	Comment Text	CMMTTEXT
		DayOfWeek	DayOfWeek
		Days Worked	DAYSWRDK
		Department	DEPRTMNT
		Employee ID	EMPLOYID
		Job Title	JOBTITLE
		Local Tax	LOCALTAX
		Sequence Number	SEQNUMBR
		Shift Code	SHFTCODE
		State Code	STATECD
		Weeks Worked	WKSWRKD
uprTimecardTemplTrxDtlTEMP	TEMP	Comment Text	CMMTTEXT
		DayOfWeek	DayOfWeek
		Days Worked	DAYSWRDK
		Department	DEPRTMNT
		Job Title	JOBTITLE
		Local Tax	LOCALTAX
		Sequence Number	SEQNUMBR
		Shift Code	SHFTCODE
		State Code	STATECD
		Units To Pay	UNTSTOPY
		Weeks Worked	WKSWRKD
uprTimecardTemplTrxStartStopTEMP	TEMP	DayOfWeek	DayOfWeek
		End Time	ENDTIME
		Line SEQ Number	LNSEQNBR
		Sequence Number	SEQNUMBR
		Start Time	STRTTIME
		Units To Pay	UNTSTOPY
uprTimecardTemplTrxTEMP	TEMP	Daily Hours	Daily_Hours
		Pay Code	PayCode
		Sequence Number	SEQNUMBR
uprTmcdDtlHIST	UPR30501	Comment Text	CMMTTEXT
		Days Worked	DAYSWRDK
		Department	DEPRTMNT
		Employee ID	EMPLOYID
		Job Title	JOBTITLE
		Local Tax	LOCALTAX
		Pay Code	PayCode
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Sequence Number	SEQNUMBR
		Shift Code	SHFTCODE
		State Code	STATECD
		TRX Date	TRXDATE
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
		Weeks Worked	WKSWRKD
		Year	YEAR1
uprTmcdHdrHIST	UPR30500	Employee ID	EMPLOYID
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Workflow Status	Workflow_Status
		Year	YEAR1
uprTmcdStartStopHIST	UPR30502	Employee ID	EMPLOYID
		End Time	ENDTIME
		Line SEQ Number	LNSEQNBR
		Pay Schedule	Pay_Schedule
		Period ID	PERIODID
		Start Time	STRTTIME
		TRX Number	TRXNUMBER
		Units To Pay	UNTSTOPY
		Year	YEAR1
UPR_MSTR	UPR00100	User ID	USERID
UPR_SETP_Class	UPR41200	Assignment Code	ASSIGNMENTCODE
		Time on Behalf Code	Time_on_Behalf_Code
UPR_SETP_Info	UPR40200	Include Inactive Employees	INCINEMP
		View Multiple Directs	VIEWMULTDIR
UPR_SETP_Timecard_Options	UPR40202	Assignment Priority	ASGMTPRTY
		Setup Key	SETUPKEY
UPR_TEMP_941_Totals	temp	FICA/Med Add Tax Rate	FICAMed_Add_Tax_Rate
		Medicare Tax Additional	Medicare_Tax_Additional
		Medicare Wages and Tips Additional	Med_Wages_and_Tips_Add
Workflow_Calendar	WF40300	DayOfWeek	DayOfWeek
		End Time	ENDTIME
		IsWorkDay	IsWorkDay
		Start Time	STRTTIME
Workflow_Calendar_Down_Days	WF40310	Date	DATE1
		DateDescription	DateDescription
		Year	YEAR1
Workflow_Document_Steps	TEMP	Workflow Business Object Key	WfBusObjKey
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Number Assigned	Workflow_Number_Assigned
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Sequence	Workflow_Step_Sequence
		Workflow Task Assigned	Workflow_Task_Assigned
		Workflow Task Assigned To	WorkflowTaskAssignedTo
		Workflow Type Name	Workflow_Type_Name
		Workflow User	Workflow_User
Workflow_Email_Notifications	WF40400	Email Message ID	EmailMessageID
		Workflow Name	Workflow_Name
		Workflow Notification Action	WF_Notification_Action
		Workflow Notification CC	Workflow_Notification_CC
		Workflow Notification Enabled	WF_Notification_Enabled
		Workflow Type Name	Workflow_Type_Name
Workflow_History	WF30100	Milliseconds	Milliseconds
		Workflow Action	Workflow_Action
		Workflow Comments	Workflow_Comments
		Workflow Completion Date	Workflow_Completion_Date
		Workflow Completion Time	Workflow_Completion_Time
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow History User	Workflow_History_User
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Step Assign To	Workflow_Step_Assign_To
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
Workflow_History_Scroll_TEMP	TEMP	Node ID	Node_ID
		Sequence Number	SEQNUMBR
		Workflow Action	Workflow_Action
		Workflow Comments	Workflow_Comments
		Workflow Completion Date	Workflow_Completion_Date
		Workflow Completion Time	Workflow_Completion_Time
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow History User	Workflow_History_User
		Workflow Step Assign To	Workflow_Step_Assign_To
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Sequence	Workflow_Step_Sequence
Workflow_History_TEMP	TEMP	Node ID	Node_ID
		Workflow Action	Workflow_Action
		Workflow Comments	Workflow_Comments
		Workflow Completion Date	Workflow_Completion_Date
		Workflow Completion Time	Workflow_Completion_Time
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow History User	Workflow_History_User
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Step Assign To	Workflow_Step_Assign_To
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Sequence	Workflow_Step_Sequence
		Workflow Step Status	Workflow_Step_Status
Workflow_Instance	WFI10002	BusObjKey	BusObjKey
		DictID	DICTID
		Document Drill Down	Document_Drill_Down
		FormID	FormID
		Note Index	NOTEINDX
		Table Physical Name	TBLPHYSNM
		Workflow Allow Originator to be an Approver	WF_AllowOrigApprover
		Workflow Alternate Final Approver	WF_Alt_FinalApprover
		Workflow Business Object Key	WfBusObjKey
		Workflow Delegate To	Workflow_Delegate_To
		Workflow Description	Workflow_Description
		Workflow Instance ID	WorkflowInstanceID
		Workflow Manually Delegate	Workflow_Manually_Delega
		Workflow Name	Workflow_Name
		Workflow Originator	Workflow_Originator
		Workflow Overdue Task Action	WF_Overdue_Task_Action
		Workflow Require One Approver	Workflow_Require_One_App
		Workflow Send Notifications for Completed Actions	WF_SendNotificatications
		Workflow Status	Workflow_Status
		Workflow Type Name	Workflow_Type_Name
		Workflow Use Alternate Final Approver	WF_Use_Alt_Final_Approv
		Workflow Version	Workflow_Version
		Workflow Where Clause	Workflow_Where_Clause
Workflow_Master	WF100002	Active	ACTIVE
		Note Index	NOTEINDX
		Workflow Allow Originator to be an Approver	WF_AllowOrigApprover
		Workflow Alternate Final Approver	WF_Alt_FinalApprover
		Workflow Delegate To	Workflow_Delegate_To
		Workflow Description	Workflow_Description
		Workflow Manually Delegate	Workflow_Manually_Delega
		Workflow Name	Workflow_Name
		Workflow Overdue Task Action	WF_Overdue_Task_Action
		Workflow Require One Approver	Workflow_Require_One_App
		Workflow Send Notifications for Completed Actions	WF_SendNotificatications
		Workflow Type Name	Workflow_Type_Name
		Workflow Use Alternate Final Approver	WF_Use_Alt_Final_Approv
		Workflow Version	Workflow_Version
Workflow_Roles	WF40201	FieldPhysicalName	FieldPhysicalName
		TableDictID	TableDictID
		TablePhysicalName	TablePhysicalName
		TableRelationship	TableRelationship
		Workflow Role Table	Workflow_Role_Table
		Workflow Type Name	Workflow_Type_Name
		WorkflowRole	WorkflowRole
		WorkflowRoleID	WorkflowRoleID
Workflow_Setup	WF00100	Display Name	DSPLNAME
		EMail	EMail
		Enable Workflow Email	Enable_Workflow_Email
		Enable Workflow Notification Service	EnableWFNotifService
		IsSSL	IsSSL
		Server ID	SERVERID
		Server Port	Server_Port
		Setup Key	SETUPKEY
		SMTP Authentication	SMTP_Authentication
		SMTP Password	SMTP_Password
		SMTP User	SMTP_User
		Web Service Server	Web_Service_Server
		Web Service Server Port	Web_Service_Server_Port
		Web Service Server SSL	Web_Service_Server_SSL
Workflow_Step	WF100003	Email Message ID	EmailMessageID
		Note Index	NOTEINDX
		Workflow Apply Workflow Calendar	WF_Apply_WF_Calendar
		Workflow Name	Workflow_Name
		Workflow Step Assign To	Workflow_Step_Assign_To
		Workflow Step Completion Policy	WF_Step_Completion_Polic
		Workflow Step Condition	Workflow_Step_Condition
		Workflow Step Conditions	Workflow_Step_Conditions
		Workflow Step Description	WF_Step_Description
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Order	Workflow_Step_Order
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Send Email	Workflow_Step_Send_Email
		Workflow Step Sequence	Workflow_Step_Sequence
		Workflow Step Time Limit	Workflow_Step_Time_Limit
		Workflow Step Time Limit UofM	WF_Step_Time_Limit_UofM
		Workflow Step Type	Workflow_Step_Type
		Workflow Version	Workflow_Version
Workflow_Step_Instance	WFI10003	Email Message ID	EmailMessageID
		Note Index	NOTEINDX
		Workflow Apply Workflow Calendar	WF_Apply_WF_Calendar
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Step Assign To	Workflow_Step_Assign_To
		Workflow Step Completion Policy	WF_Step_Completion_Polic
		Workflow Step Condition	Workflow_Step_Condition
		Workflow Step Conditions	Workflow_Step_Conditions
		Workflow Step Description	WF_Step_Description
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Order	Workflow_Step_Order
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Send Email	Workflow_Step_Send_Email
		Workflow Step Sequence	Workflow_Step_Sequence
		Workflow Step Status	Workflow_Step_Status
		Workflow Step Time Limit	Workflow_Step_Time_Limit
		Workflow Step Time Limit UofM	WF_Step_Time_Limit_UofM
		Workflow Step Type	Workflow_Step_Type
		Workflow Version	Workflow_Version
Workflow_Step_Instance_Users	WFI10005	ADDisplayName	ADDisplayName
		EMail	EMail
		UsersListGuid	UsersListGuid
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Task Assigned To	WorkflowTaskAssignedTo
		Workflow User	Workflow_User
Workflow_Tasks	WFI10004	Workflow Action Date	Workflow_Action_Date
		Workflow Action Time	Workflow_Action_Time
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow Instance ID	WorkflowInstanceID
		Workflow Name	Workflow_Name
		Workflow Step Completion Policy	WF_Step_Completion_Polic
		Workflow Step Description	WF_Step_Description
		Workflow Step Instance ID	WorkflowStepInstanceID
		Workflow Step Name	Workflow_Step_Name
		Workflow Step Order	Workflow_Step_Order
		Workflow Step Predecessor	WF_Step_Predecessor
		Workflow Step Sequence	Workflow_Step_Sequence
		Workflow Step Type	Workflow_Step_Type
		Workflow Task Assigned To	WorkflowTaskAssignedTo
		Workflow Task Escalated	Workflow_Task_Escalated
		Workflow Version	Workflow_Version
Workflow_Tasks_Homepage_TEMP	TEMP	DictID	DICTID
		FormID	FormID
		Window Name	WINNAME
		Workflow Business Object Key	WfBusObjKey
		Workflow Due Date	Workflow_Due_Date
		Workflow Due Time	Workflow_Due_Time
		Workflow Step Type	Workflow_Step_Type
		Workflow Task Assigned To	WorkflowTaskAssignedTo
		Workflow Type Name	Workflow_Type_Name
Workflow_Template_Fields	WF40202	Additional Fields	AdditionalFields
		Email Message Type	Email_Message_Type
		FieldDataType	FieldDataType
		FieldName	FieldName
		FieldPhysicalName	FieldPhysicalName
		Ord Line	Ord Line
		Resource ID	RSRCID
		Sequence Number	SEQNUMBR
		TableDictID	TableDictID
		TablePhysicalName	TablePhysicalName
		TableRelationship	TableRelationship
		TableSeries	TableSeries
		Workflow Template Field Type	WF_Template_Field_Type
		Workflow Type Name	Workflow_Type_Name
Workflow_Template_Fields_TEMP	TEMP	Additional Fields	AdditionalFields
		Email Message Type	Email_Message_Type
		FieldDataType	FieldDataType
		FieldName	FieldName
		FieldPhysicalName	FieldPhysicalName
		Ord Line	Ord Line
		Resource ID	RSRCID
		Sequence Number	SEQNUMBR
		TableDictID	TableDictID
		TablePhysicalName	TablePhysicalName
		TableRelationship	TableRelationship
		TableSeries	TableSeries
		Workflow Template Field Type	WF_Template_Field_Type
		Workflow Type Name	Workflow_Type_Name
Workflow_Type	WF100001	DictID	DICTID
		DocAttachBusObjKeyFunction	DocAttachBusObjKeyFuncti
		DocumentDrillDownFunction	DocumentDrillDownFunctio
		FieldsListGuid	FieldsListGuid
		FormID	FormID
		Note Index	NOTEINDX
		Series	SERIES
		Window Name	WINNAME
		Workflow Class	Workflow_Class
		Workflow Managers	Workflow_Managers
		Workflow Type Business Object Key	WfTypeBusObjKey
		Workflow Type Description	WF_Type_Description
		Workflow Type Hist Business Object Key	WfTypeHistBusObjKey
		Workflow Type Name	Workflow_Type_Name
Workflow_Type_Conditions_TEMP	TEMP	Cost Amount	COSTAMNT
		Count	Count1
		Field Data Type	Field_Data_Type
		Field Name	FIELDNAM
		Unit_Acct	Unit_Acct
		Workflow Type Name	Workflow_Type_Name
Payroll Check History	UPR30100	Payperiodbegindate	Payperiodbegindate
		Payperiodenddate	Payperiodenddate
Workflow_Users	WF40200	ADAlias	ADAlias
		ADDisplayName	ADDisplayName
		ADDistinguishedName	ADDistinguishedName
		ADDomain	ADDomain
		ADLogin	ADLogin
		ADObjectGuid	ADObjectGuid
		ADType	ADType
		EMail	EMail
		HierarchyLevel	HierarchyLevel
		Sequence	SEQUENCE1
		UsersListGuid	UsersListGuid
		WorkflowHierarchy	WorkflowHierarchy
		WorkflowHierarchyID	WorkflowHierarchyID
		WorkflowRole	WorkflowRole
		WorkflowRoleID	WorkflowRoleID
		WorkflowSelectionType	WorkflowSelectionType
Workflow_User_Delegation_LINE	WF40510	ADDisplayName	ADDisplayName
		Domain User Name	DomainUserName
		End Date	ENDDATE
		Start Date	STRTDATE
		UsersListGuid	UsersListGuid
		Workflow Type Name	Workflow_Type_Name
Workflow_User_Delegation_MSTR	WF40500	ADDisplayName	ADDisplayName
		Domain User Name	DomainUserName
		UsersListGuid	UsersListGuid
		Workflow Auto Delegate Tasks	WF_Auto_Delegate_Tasks
		Workflow Select Delegate	Workflow_Select_Delegate
Workflow_User_Security	WF00104	User ID	USERID
		Workflow Type Name	Workflow_Type_Name

Columns in GP 2013 that have been deleted in GP 2015 That Did Not Exist in GP 2013 RTM

Table Technical Name	Table Physical Name	Field Technical Name	Field Physical Name
ddACHCopy	DD10200	Index	INDEX1
ddACHCrossRef	DD10300	Index	INDEX1
ddACHFtrSetup	DD40400	Index	INDEX1
ddACHHdr	DD10400	Index	INDEX1
ddACHHdrSetup	DD40400	Index	INDEX1
ddACHItems	DD10500	Index	INDEX1
ddEmpAcctMstr	DD00200	Index	INDEX1
ddEmpAcctsTemp	temp	Index	INDEX1
ddEmpLineTemp	TEMP	Index	INDEX1
ddEmpMstr	DD00100	Index	INDEX1
ddExceptions	DD10700	Index	INDEX1
ddTrxHistDetail	DD30101	Index	INDEX1
ddTrxHistHdr	DD30100	Index	INDEX1
MUPR_DDNextIdx	DD40700	Index	INDEX1
SY_Current_Activity	ACTIVITY	IsWebClient	IsWebClient

Comments

*This post is locked for comments

Mitch.M 532
Posted at

Dan, is it possible to let us know what the InvalidDataFlag maps to? I can't seem to find any information on what those numbers mean. Thanks.

Like (0)

Report

Community site session details

Table and Column Changes in Dynamics GP 2015

Comments

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the December Top 10 Community Leaders!