CREATE PROCEDURE [dbo].[XLedgerImportBranchObjectValues]
    @items XLedgerObjectValueImportItems readonly
as

begin
    set nocount on

    declare @now datetimeoffset = sysdatetimeoffset()

    ;with ImportData as
    (
        select
            Item.XLedgerDbId,
            Item.CanPost,
            Item.Code,
            Item.Description,
            XLedgerCompany.XLedgerCompanyId
        from @items Item
        inner join XLedgerCompany on Item.XLedgerOwnerDbId = XLedgerCompany.XLedgerDbId
    )
    merge XLedgerBranchObjectValue with(tablock) using ImportData on
        ImportData.XLedgerDbId = XLedgerBranchObjectValue.XLedgerDbId
    when not matched then
        insert(
            Code,
            [Description],
            XLedgerDbId,
            [Hidden],
            XLedgerCompanyFid,
            CanPost,
            CreatedOn,
            LastImportedOn )
        values(
            ImportData.Code,
            ImportData.[Description],
            ImportData.XLedgerDbId,
            0, -- Hidden
            ImportData.XLedgerCompanyId,
            ImportData.CanPost,
            @now, -- CreatedOn
            @now ) -- LastImportedOn
    when matched then update set
        Code = ImportData.Code,
        [Description] = ImportData.[Description],
        XLedgerCompanyFid = ImportData.XLedgerCompanyId,
        [CanPost] = ImportData.CanPost,
        [Hidden] = 0, -- the presence of the item means it's not hidden.
        LastImportedOn = @now
    when not matched by source and XLedgerBranchObjectValue.Hidden = 0 then update set
        [Hidden] = 1,
        [LastImportedOn] = @now
    ;
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerImportBranchObjectValues] TO [MssExec]
GO