Description |
*Steps:*
1. Energy Trac > Export XML > Select Item Messages and Item Messages Cross Reference > Click Export
*Issue:*
Invalid vyu for Inventory Item Messages and Item Messages Cross Reference(Obsolete as of 9/18/17)
!pastedImage_d81116_0.png!
*Acceptance:*
Should be able to export Inventory Item Messages and Item Messages Cross Reference
Should have vyuICETExportItemMessages and vyuICETExportItemMessagesXRef(Obsolete as of 9/18/17)
*Note:*
Below are the ET table schema for item message.
CREATE TABLE [dbo].[tblMstItemMessages](
*[imsgno] [numeric](6, 0) NULL,*
* [imsg1] [char](60) NULL,*
* [imsg2] [char](60) NULL,*
* [imsg3] [char](60) NULL,*
* [iamsgno] [numeric](6, 0) NULL*
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
and here is for item message Xref
CREATE TABLE [dbo].[tblMstItemMessageXRef](
*[min_item] [char](15) NULL,*
* [max_item] [char](15) NULL,*
* [mssg_no] [numeric](6, 0) NULL*
) ON [PRIMARY]
GO
Specs Page [http://inet.irelyserver.com/display/ET/Energy+Trac+Item+Messages]
|