Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

Overview

This section contains instructions how to update mapping for activity codes and quantity.

Quantity Mapping

Add New Quantity Mapping
declare @date datetime = GetDate();

INSERT INTO MappingQuantities (Code, CustomerQuantity, Quantity, UpdateDate, CreationDate) VALUES ('1111-1111-111', 10, 1, @date, @date)
Update Existing Quantity Mapping
UPDATE MappingQuantities SET CustomerQuantity = 10, Quantity = 2, UpdateDate = GetDate() WHERE Code = '1111-1111-111'
Delete Quantity Mapping
declare @date datetime = GetDate();

UPDATE MappingQuantities SET UpdateDate = @date, DeleteDate = @date, IsDeleted = 1 WHERE Code = '1111-1111-111'

Code Mapping

Add New Code Mapping
declare @date datetime = GetDate();

INSERT INTO MappingCodes (CustomerCode, Code, CustomerQuantity, Quantity, UpdateDate, CreationDate) VALUES ('9999-9999-999', '1111-1111-111', 10, 1, @date, @date)
Update Existing Code Mapping
UPDATE MappingCodes SET CustomerCode = '9999-9999-111', Code = '1111-1111-222', CustomerQuantity = 8, Quantity = 2, UpdateDate = GetDate() WHERE CustomerCode = '9999-9999-999'
Delete Code Mapping
declare @date datetime = GetDate();

UPDATE MappingCodes SET UpdateDate = @date, DeleteDate = @date, IsDeleted = 1 WHERE CustomerCode = '9999-9999-999'

HCPCS Code Mapping

Add New HCPCS Code Mapping
declare @date datetime = GetDate();

INSERT INTO MappingCustomHcpcsCodes (CustomerCode, HcpcsCode, LawsonNo, CustomerQuantity, Quantity, PackagePrice, UpdateDate, CreationDate) 
VALUES ('9999-9999-999', 'A1111', '11111', 10, 1, 25.73, @date, @date)
Update Existing HCPCS Code Mapping
UPDATE MappingCustomHcpcsCodes SET HcpcsCode = 'A1112', LawsonNo = '11112', CustomerQuantity = 8, Quantity = 2, PackagePrice = 25.52, UpdateDate = GetDate() 
WHERE CustomerCode = '9999-9999-999'
Delete HCPCS Code Mapping
declare @date datetime = GetDate();

UPDATE MappingCustomHcpcsCodes SET UpdateDate = @date, DeleteDate = @date, IsDeleted = 1 WHERE CustomerCode = '9999-9999-999'



  • No labels