[dbo].[XmlSystemPayrollAccountMap]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	8:50:10 AM Thursday, December 5, 2024
Last Modified	8:50:16 AM Thursday, December 5, 2024

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count (~)

Created

8:50:10 AM Thursday, December 5, 2024

Last Modified

8:50:16 AM Thursday, December 5, 2024

	Name	Data Type	Max Length (Bytes)	Identity
	XmlSystemPayrollAccountMapId	int	4	1 - 1
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType: XmlSystemFID\LaborTypeFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch: XmlSystemFID\LaborTypeFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser: XmlSystemFID\SysUserFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch: XmlSystemFID\SysUserFID\BranchFID$	XmlSystemFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	AuthorityTypesFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	ServTypeClassFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	CommTypeFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	MoveTypeGroupsFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser: XmlSystemFID\SysUserFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch: XmlSystemFID\SysUserFID\BranchFID$	SysUserFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	ServTypeFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	MoveTypeFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType: XmlSystemFID\LaborTypeFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch: XmlSystemFID\LaborTypeFID\BranchFID$	LaborTypeFID	int	4
$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch: XmlSystemFID\LaborTypeFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch: XmlSystemFID\SysUserFID\BranchFID$	BranchFID	int	4
	ExternalCode	varchar(50)	50
	SecondaryExternalCode	varchar(50)	50
	Rank	int	4
$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$	IsServiceLead	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

XmlSystemPayrollAccountMapId

int

1 - 1

$Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType: XmlSystemFID\LaborTypeFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch: XmlSystemFID\LaborTypeFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser: XmlSystemFID\SysUserFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch: XmlSystemFID\SysUserFID\BranchFID$

XmlSystemFID

int

$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$

AuthorityTypesFID

int

ServTypeClassFID

int

CommTypeFID

int

MoveTypeGroupsFID

int

SysUserFID

int

ServTypeFID

int

MoveTypeFID

int

LaborTypeFID

int

$Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch: AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_AllMappingFields: XmlSystemFID\AuthorityTypesFID\ServTypeClassFID\CommTypeFID\MoveTypeGroupsFID\SysUserFID\ServTypeFID\MoveTypeFID\LaborTypeFID\IsServiceLead\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch: XmlSystemFID\LaborTypeFID\BranchFID$ $Indexes IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch: XmlSystemFID\SysUserFID\BranchFID$

BranchFID

int

ExternalCode

varchar(50)

SecondaryExternalCode

varchar(50)

Rank

int

IsServiceLead

bit

	Name	Columns	Unique
	PK_XmlSystemPayrollAccountMap	XmlSystemPayrollAccountMapId
	IX_XmlSystemPayrollAccountMap_AllMappingFields	XmlSystemFID, AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID, SysUserFID, ServTypeFID, MoveTypeFID, LaborTypeFID, IsServiceLead, BranchFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups	AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch	AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID, BranchFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType	XmlSystemFID, LaborTypeFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch	XmlSystemFID, LaborTypeFID, BranchFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser	XmlSystemFID, SysUserFID
	IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch	XmlSystemFID, SysUserFID, BranchFID

Name

Columns

Unique

PK_XmlSystemPayrollAccountMap

XmlSystemPayrollAccountMapId

IX_XmlSystemPayrollAccountMap_AllMappingFields

XmlSystemFID, AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID, SysUserFID, ServTypeFID, MoveTypeFID, LaborTypeFID, IsServiceLead, BranchFID

IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups

AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID

IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch

AuthorityTypesFID, ServTypeClassFID, CommTypeFID, MoveTypeGroupsFID, BranchFID

IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType

XmlSystemFID, LaborTypeFID

IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch

XmlSystemFID, LaborTypeFID, BranchFID

IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser

XmlSystemFID, SysUserFID

IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch

XmlSystemFID, SysUserFID, BranchFID

Name	Delete	Columns
FK_XmlSystemPayrollAccountMap_AuthorityTypes		AuthorityTypesFID->[dbo].[AuthorityTypes].[AuthPriKey]
FK_XmlSystemPayrollAccountMap_Branch		BranchFID->[dbo].[Branch].[BranchPriKey]
FK_XmlSystemPayrollAccountMap_CommType		CommTypeFID->[dbo].[CommType].[PriKey]
FK_XmlSystemPayrollAccountMap_LaborType		LaborTypeFID->[dbo].[LaborType].[PriKey]
FK_XmlSystemPayrollAccountMap_MoveType		MoveTypeFID->[dbo].[MoveType].[PriKey]
FK_XmlSystemPayrollAccountMap_MoveTypeGroups		MoveTypeGroupsFID->[dbo].[MoveTypeGroups].[MTGroupPriKey]
FK_XmlSystemPayrollAccountMap_ServTypeClass		ServTypeClassFID->[dbo].[ServTypeClass].[ServTypeClassID]
FK_XmlSystemPayrollAccountMap_ServType		ServTypeFID->[dbo].[ServType].[ServiceID]
FK_XmlSystemPayrollAccountMap_SysUser		SysUserFID->[dbo].[Sysuser].[SysUserID]
FK_XmlSystemPayrollAccountMap_XmlSystem	Cascade	XmlSystemFID->[dbo].[XmlSystem].[XmlSystemID]

Name

Delete

Columns

FK_XmlSystemPayrollAccountMap_AuthorityTypes

AuthorityTypesFID->[dbo].[AuthorityTypes].[AuthPriKey]

FK_XmlSystemPayrollAccountMap_Branch

BranchFID->[dbo].[Branch].[BranchPriKey]

FK_XmlSystemPayrollAccountMap_CommType

CommTypeFID->[dbo].[CommType].[PriKey]

FK_XmlSystemPayrollAccountMap_LaborType

LaborTypeFID->[dbo].[LaborType].[PriKey]

FK_XmlSystemPayrollAccountMap_MoveType

MoveTypeFID->[dbo].[MoveType].[PriKey]

FK_XmlSystemPayrollAccountMap_MoveTypeGroups

MoveTypeGroupsFID->[dbo].[MoveTypeGroups].[MTGroupPriKey]

FK_XmlSystemPayrollAccountMap_ServTypeClass

ServTypeClassFID->[dbo].[ServTypeClass].[ServTypeClassID]

FK_XmlSystemPayrollAccountMap_ServType

ServTypeFID->[dbo].[ServType].[ServiceID]

FK_XmlSystemPayrollAccountMap_SysUser

SysUserFID->[dbo].[Sysuser].[SysUserID]

FK_XmlSystemPayrollAccountMap_XmlSystem

Cascade

XmlSystemFID->[dbo].[XmlSystem].[XmlSystemID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

SQL Script

CREATE TABLE [dbo].[XmlSystemPayrollAccountMap]
(
[XmlSystemPayrollAccountMapId] [int] NOT NULL IDENTITY(1, 1),
[XmlSystemFID] [int] NOT NULL,
[AuthorityTypesFID] [int] NULL,
[ServTypeClassFID] [int] NULL,
[CommTypeFID] [int] NULL,
[MoveTypeGroupsFID] [int] NULL,
[SysUserFID] [int] NULL,
[ServTypeFID] [int] NULL,
[MoveTypeFID] [int] NULL,
[LaborTypeFID] [int] NULL,
[BranchFID] [int] NULL,
[ExternalCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SecondaryExternalCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Rank] [int] NULL,
[IsServiceLead] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [PK_XmlSystemPayrollAccountMap] PRIMARY KEY CLUSTERED  ([XmlSystemPayrollAccountMapId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [IX_XmlSystemPayrollAccountMap_AllMappingFields] UNIQUE NONCLUSTERED  ([XmlSystemFID], [AuthorityTypesFID], [ServTypeClassFID], [CommTypeFID], [MoveTypeGroupsFID], [SysUserFID], [ServTypeFID], [MoveTypeFID], [LaborTypeFID], [IsServiceLead], [BranchFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups] ON [dbo].[XmlSystemPayrollAccountMap] ([AuthorityTypesFID], [ServTypeClassFID], [CommTypeFID], [MoveTypeGroupsFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_AuthorityTypes_ServTypeClassGLCodeMap_CommType_MoveTypeGroups_Branch] ON [dbo].[XmlSystemPayrollAccountMap] ([AuthorityTypesFID], [ServTypeClassFID], [CommTypeFID], [MoveTypeGroupsFID], [BranchFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType] ON [dbo].[XmlSystemPayrollAccountMap] ([XmlSystemFID], [LaborTypeFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_LaborType_Branch] ON [dbo].[XmlSystemPayrollAccountMap] ([XmlSystemFID], [LaborTypeFID], [BranchFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser] ON [dbo].[XmlSystemPayrollAccountMap] ([XmlSystemFID], [SysUserFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XmlSystemPayrollAccountMap_XmlSystem_SysUser_Branch] ON [dbo].[XmlSystemPayrollAccountMap] ([XmlSystemFID], [SysUserFID], [BranchFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_AuthorityTypes] FOREIGN KEY ([AuthorityTypesFID]) REFERENCES [dbo].[AuthorityTypes] ([AuthPriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_Branch] FOREIGN KEY ([BranchFID]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_CommType] FOREIGN KEY ([CommTypeFID]) REFERENCES [dbo].[CommType] ([PriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_LaborType] FOREIGN KEY ([LaborTypeFID]) REFERENCES [dbo].[LaborType] ([PriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_MoveType] FOREIGN KEY ([MoveTypeFID]) REFERENCES [dbo].[MoveType] ([PriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_MoveTypeGroups] FOREIGN KEY ([MoveTypeGroupsFID]) REFERENCES [dbo].[MoveTypeGroups] ([MTGroupPriKey])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_ServTypeClass] FOREIGN KEY ([ServTypeClassFID]) REFERENCES [dbo].[ServTypeClass] ([ServTypeClassID])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_ServType] FOREIGN KEY ([ServTypeFID]) REFERENCES [dbo].[ServType] ([ServiceID])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_SysUser] FOREIGN KEY ([SysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[XmlSystemPayrollAccountMap] ADD CONSTRAINT [FK_XmlSystemPayrollAccountMap_XmlSystem] FOREIGN KEY ([XmlSystemFID]) REFERENCES [dbo].[XmlSystem] ([XmlSystemID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[XmlSystemPayrollAccountMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlSystemPayrollAccountMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlSystemPayrollAccountMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlSystemPayrollAccountMap] TO [MssExec]
GO