Notes
Notes - notes.io |
DROP PROCEDURE CreateReceivableTaxEntitiesForVertex;
GO
IF TYPE_ID('ReceivableTaxParameter') IS NOT NULL
DROP TYPE ReceivableTaxParameter;
GO
IF TYPE_ID('ReceivableTaxDetailParameter') IS NOT NULL
DROP TYPE ReceivableTaxDetailParameter;
GO
IF TYPE_ID('ReceivableTaxImpositionParameter') IS NOT NULL
DROP TYPE ReceivableTaxImpositionParameter;
GO
IF TYPE_ID('ReceivableTaxSKUImpositionParameter') IS NOT NULL
DROP TYPE ReceivableTaxSKUImpositionParameter;
GO
IF TYPE_ID('ReceivableTaxReversalDetailParameter') IS NOT NULL
DROP TYPE ReceivableTaxReversalDetailParameter;
GO
IF TYPE_ID('ReceivableSKUTaxReversalDetailParameter') IS NOT NULL
DROP TYPE ReceivableSKUTaxReversalDetailParameter;
GO
IF TYPE_ID('ReceivableSKUTaxReversalDetailParameter') IS NOT NULL
DROP TYPE ReceivableSKUTaxReversalDetailParameter;
GO
CREATE TYPE ReceivableTaxParameter AS TABLE
(
[Amount_Amount] [DECIMAL](16, 2) NOT NULL,
[Amount_Currency] [NVARCHAR](3) NOT NULL,
[Balance_Amount] [DECIMAL](16, 2) NOT NULL,
[Balance_Currency] [NVARCHAR](3) NOT NULL,
[EffectiveBalance_Amount] [DECIMAL](16, 2) NOT NULL,
[EffectiveBalance_Currency] [NVARCHAR](3) NOT NULL,
[GlTemplateId] [BIGINT] NOT NULL,
[ReceivableId] [BIGINT] NOT NULL,
[ReceivableTaxId] [BIGINT] NULL,
[IsCashBased] [BIT] NOT NULL
);
GO
CREATE TYPE ReceivableTaxDetailParameter AS TABLE
(
[TaxBasisType] [NVARCHAR](2) NOT NULL,
[Revenue_Amount] [DECIMAL](16, 2) NOT NULL,
[Revenue_Currency] [NVARCHAR](3) NOT NULL,
[FairMarketValue_Amount] [DECIMAL](16, 2) NOT NULL,
[FairMarketValue_Currency] [NVARCHAR](3) NOT NULL,
[Cost_Amount] [DECIMAL](16, 2) NOT NULL,
[Cost_Currency] [NVARCHAR](3) NOT NULL,
[TaxAreaId] [BIGINT] NULL,
[Amount_Amount] [DECIMAL](16, 2) NOT NULL,
[Amount_Currency] [NVARCHAR](3) NOT NULL,
[Balance_Amount] [DECIMAL](16, 2) NOT NULL,
[Balance_Currency] [NVARCHAR](3) NOT NULL,
[EffectiveBalance_Amount] [DECIMAL](16, 2) NOT NULL,
[EffectiveBalance_Currency] [NVARCHAR](3) NOT NULL,
[AssetLocationId] [BIGINT] NULL,
[LocationId] [BIGINT] NULL,
[AssetId] [BIGINT] NULL,
[ReceivableDetailId] [BIGINT] NOT NULL,
[ReceivableId] [BIGINT] NOT NULL,
UpfrontPayableFactor [DECIMAL](10, 6) NOT NULL,
[TaxCodeId] [BIGINT] NULL
);
GO
CREATE TYPE ReceivableTaxImpositionParameter AS TABLE
([ExemptionType] [NVARCHAR](100) NULL,
[ExemptionRate] [DECIMAL](10, 6) NOT NULL,
[ExemptionAmount_Amount] [DECIMAL](16, 2) NOT NULL,
[ExemptionAmount_Currency] [NVARCHAR](3) NOT NULL,
[TaxableBasisAmount_Amount] [DECIMAL](16, 2) NOT NULL,
[TaxableBasisAmount_Currency] [NVARCHAR](3) NOT NULL,
[AppliedTaxRate] [DECIMAL](10, 6) NOT NULL,
[OriginalTaxRate] [DECIMAL](10, 6) NULL,
[Amount_Amount] [DECIMAL](16, 2) NOT NULL,
[Amount_Currency] [NVARCHAR](3) NOT NULL,
[Balance_Amount] [DECIMAL](16, 2) NOT NULL,
[Balance_Currency] [NVARCHAR](3) NOT NULL,
[EffectiveBalance_Amount] [DECIMAL](16, 2) NOT NULL,
[EffectiveBalance_Currency] [NVARCHAR](3) NOT NULL,
[ExternalTaxImpositionType] [NVARCHAR](100) NULL,
[TaxTypeId] [BIGINT] NULL,
[ExternalJurisdictionLevelId] [BIGINT] NULL,
[ReceivableDetailId] [BIGINT] NOT NULL,
[AssetId] [BIGINT] NULL,
[TaxBasisType] [NVARCHAR](10) NOT NULL,
[TaxRuleId] [BIGINT] NULL
);
GO
CREATE TYPE ReceivableTaxSKUImpositionParameter AS TABLE
([ExemptionType] [NVARCHAR](100) NULL,
[ExemptionRate] [DECIMAL](10, 6) NOT NULL,
[ExemptionAmount_Amount] [DECIMAL](16, 2) NOT NULL,
[ExemptionAmount_Currency] [NVARCHAR](3) NOT NULL,
[TaxableBasisAmount_Amount] [DECIMAL](16, 2) NOT NULL,
[TaxableBasisAmount_Currency] [NVARCHAR](3) NOT NULL,
[AppliedTaxRate] [DECIMAL](10, 6) NOT NULL,
[OriginalTaxRate] [DECIMAL](10, 6) NULL,
[Amount_Amount] [DECIMAL](16, 2) NOT NULL,
[Amount_Currency] [NVARCHAR](3) NOT NULL,
[Balance_Amount] [DECIMAL](16, 2) NOT NULL,
[Balance_Currency] [NVARCHAR](3) NOT NULL,
[EffectiveBalance_Amount] [DECIMAL](16, 2) NOT NULL,
[EffectiveBalance_Currency] [NVARCHAR](3) NOT NULL,
[ExternalTaxImpositionType] [NVARCHAR](100) NULL,
[TaxTypeId] [BIGINT] NULL,
[ExternalJurisdictionLevelId] [BIGINT] NULL,
[ReceivableDetailId] [BIGINT] NOT NULL,
[AssetId] [BIGINT] NULL,
[AssetSKUId] [BIGINT] NULL,
[TaxBasisType] [NVARCHAR](10) NOT NULL,
[TaxRuleId] [BIGINT] NULL
);
GO
CREATE TYPE ReceivableTaxReversalDetailParameter AS TABLE
([IsExemptAtAsset] [BIT] NOT NULL,
[IsExemptAtLease] [BIT] NOT NULL,
[IsExemptAtSundry] [BIT] NOT NULL,
[Company] [NVARCHAR](100) NULL,
[Product] [NVARCHAR](100) NULL,
[ContractType] [NVARCHAR](40) NULL,
[AssetType] [NVARCHAR](100) NULL,
[LeaseType] [NVARCHAR](40) NULL,
[LeaseTerm] [DECIMAL](18, 8) NULL,
[TitleTransferCode] [NVARCHAR](40) NULL,
[TransactionCode] [NVARCHAR](4) NULL,
[AmountBilledToDate] [DECIMAL](16, 2) NULL,
[AssetId] [BIGINT] NULL,
[AssetLocationId] [BIGINT] NULL,
[ReceivableDetailId] [BIGINT] NULL,
[ToStateName] [NVARCHAR](40) NULL,
[FromStateName] [NVARCHAR](40) NULL,
[SalesTaxRemittanceResponsibility] [NVARCHAR] (8),
[IsCapitalizeUpfrontSalesTax] [BIT] NOT NULL,
[UpfrontTaxAssessedInLegacySystem] BIT NOT NULL,
[BusCode] [NVarChar](40) NULL,
[StringFlexField20] [NVARCHAR](40) NULL,
[IsCapitalizedSalesTaxAsset] BIT NOT NULL
)
GO
CREATE TYPE ReceivableSKUTaxReversalDetailParameter AS TABLE
(
[Revenue_Amount] [DECIMAL](16, 2) NOT NULL,
[Revenue_Currency] [NVARCHAR](3) NOT NULL,
[FairMarketValue_Amount] [DECIMAL](16, 2) NOT NULL,
[FairMarketValue_Currency] [NVARCHAR](3) NOT NULL,
[Cost_Amount] [DECIMAL](16, 2) NOT NULL,
[Cost_Currency] [NVARCHAR](3) NOT NULL,
[Amount_Amount] [DECIMAL](16, 2) NOT NULL,
[Amount_Currency] [NVARCHAR](3) NOT NULL,
[AssetSKUId] [BIGINT] NOT NULL,
[ReceivableSKUId] [BIGINT] NOT NULL,
[ReceivableDetailId] [BIGINT] NOT NULL,
[IsExemptAtAssetSKU] [BIT] NOT NULL,
[AmountBilledToDate_Amount] [DECIMAL](16, 2) NOT NULL,
[StringFlexField20] [NVARCHAR](40) NULL
);
GO
CREATE PROCEDURE CreateReceivableTaxEntitiesForVertex
(
@ReceivableTaxParameter ReceivableTaxParameter READONLY,
@ReceivableTaxDetailParameter ReceivableTaxDetailParameter READONLY,
@ReceivableTaxImpositionParameter ReceivableTaxImpositionParameter READONLY,
@ReceivableTaxSKUImpositionParameter ReceivableTaxSKUImpositionParameter READONLY,
@ReceivableTaxReversalDetailParameter ReceivableTaxReversalDetailParameter READONLY,
@ReceivableSKUTaxReversalDetailParameter ReceivableSKUTaxReversalDetailParameter READONLY,
@CreatedById BIGINT,
@CreatedTime DATETIMEOFFSET,
@JobStepInstanceId BIGINT,
@ReceivableIdsMessage NVARCHAR(100),
@IsManuallyAssessed BIT
)
AS
BEGIN
SET NOCOUNT ON
SELECT * INTO #ReceivableTaxParameter FROM @ReceivableTaxParameter
CREATE INDEX IX_1 ON #ReceivableTaxParameter(ReceivableId)
SELECT * INTO #ReceivableTaxDetailParameter FROM @ReceivableTaxDetailParameter
CREATE INDEX IX_1 ON #ReceivableTaxDetailParameter(ReceivableId)
SELECT * INTO #ReceivableTaxImpositionParameter FROM @ReceivableTaxImpositionParameter
Create Index IX_1 ON #ReceivableTaxImpositionParameter(ReceivableDetailId) Include (AssetId)
SELECT * INTO #ReceivableTaxReversalDetailParameter FROM @ReceivableTaxReversalDetailParameter
Create Index IX_1 ON #ReceivableTaxReversalDetailParameter(ReceivableDetailId) Include (AssetId)
SELECT * INTO #ReceivableTaxSKUImpositionParameter FROM @ReceivableTaxSKUImpositionParameter
Create Index IX_1 ON #ReceivableTaxSKUImpositionParameter(ReceivableDetailId) Include (AssetId)
SELECT * INTO #ReceivableSKUTaxReversalDetailParameter FROM @ReceivableSKUTaxReversalDetailParameter
Create Index IX_1 ON #ReceivableSKUTaxReversalDetailParameter(ReceivableDetailId)
CREATE TABLE #InsertedReceivableTaxes
(
ReceivableTaxId BIGINT,
ReceivableId BIGINT
);
CREATE TABLE #InsertedReceivableTaxDetails
(
ReceivableTaxDetailId BIGINT,
ReceivableDetailId BIGINT,
ReceivableDetailAssetId BIGINT NULL,
Action VARCHAR(400)
);
MERGE [ReceivableTaxes] With (ForceSeek) AS TargetReceivableTax
USING #ReceivableTaxParameter AS SourceReceivableTax
ON (TargetReceivableTax.ReceivableId = SourceReceivableTax.ReceivableId AND TargetReceivableTax.IsActive = 1)
WHEN NOT MATCHED THEN
INSERT
( [CreatedById],
[CreatedTime],
[ReceivableId],
[IsActive],
[IsGLPosted],
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
[IsDummy],
[GlTemplateId],
[IsCashBased]
)
VALUES(@CreatedById,
@CreatedTime,
[ReceivableId],
1,
0,
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
0,
[GlTemplateId],
[IsCashBased])
WHEN MATCHED THEN
UPDATE SET TargetReceivableTax.UpdatedById = @CreatedById, TargetReceivableTax.UpdatedTime = @CreatedTime,
TargetReceivableTax.Amount_Amount = TargetReceivableTax.Amount_Amount + SourceReceivableTax.Amount_Amount,
TargetReceivableTax.Balance_Amount = TargetReceivableTax.Balance_Amount + SourceReceivableTax.Balance_Amount,
TargetReceivableTax.EffectiveBalance_Amount = TargetReceivableTax.EffectiveBalance_Amount + SourceReceivableTax.EffectiveBalance_Amount
OUTPUT INSERTED.Id AS ReceivableTaxId, INSERTED.ReceivableId AS ReceivableId INTO #InsertedReceivableTaxes;
SELECT
TaxBasisType,
Revenue_Amount,
Revenue_Currency,
FairMarketValue_Amount,
FairMarketValue_Currency,
Cost_Amount,
Cost_Currency,
TaxAreaId ,
AssetLocationId,
LocationId,
AssetId,
ReceivableDetailId,
IRT.ReceivableTaxId,
Amount_Amount,
Amount_Currency,
Balance_Amount,
Balance_Currency,
EffectiveBalance_Amount,
EffectiveBalance_Currency,
UpfrontPayableFactor,
TaxCodeId
INTO #Temp_ReceivableTaxDetailsParameters
FROM #ReceivableTaxDetailParameter RTP
INNER JOIN #InsertedReceivableTaxes IRT ON RTP.ReceivableId = IRT.ReceivableId;
MERGE [ReceivableTaxDetails] With (ForceSeek) AS TargetReceivableTaxDetail
USING (SELECT * FROM #Temp_ReceivableTaxDetailsParameters WHERE AssetId IS NOT NULL) AS SourceReceivableTaxDetail
ON (TargetReceivableTaxDetail.ReceivableDetailId = SourceReceivableTaxDetail.ReceivableDetailId AND
TargetReceivableTaxDetail.AssetId = SourceReceivableTaxDetail.AssetId AND TargetReceivableTaxDetail.IsActive = 1 )
WHEN NOT MATCHED THEN
INSERT
([TaxBasisType],
[Revenue_Amount],
[Revenue_Currency],
[FairMarketValue_Amount],
[FairMarketValue_Currency],
[Cost_Amount],
[Cost_Currency],
[TaxAreaId],
[IsActive],
[ManuallyAssessed],
[CreatedById],
[CreatedTime],
[AssetLocationId],
[LocationId],
[AssetId],
[ReceivableDetailId],
[ReceivableTaxId],
[IsGLPosted],
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
[UpfrontTaxMode],
[UpfrontPayableFactor],
[TaxCodeId]
)
Values( TaxBasisType,
Revenue_Amount,
Revenue_Currency,
FairMarketValue_Amount,
FairMarketValue_Currency,
Cost_Amount,
Cost_Currency,
TaxAreaId,
1,
@IsManuallyAssessed,
@CreatedById,
@CreatedTime,
AssetLocationId,
LocationId,
AssetId,
ReceivableDetailId,
ReceivableTaxId,
0,
Amount_Amount,
Amount_Currency,
Balance_Amount,
Balance_Currency,
EffectiveBalance_Amount,
EffectiveBalance_Currency,
'_',
[UpfrontPayableFactor],
[TaxCodeId]
)WHEN MATCHED THEN
UPDATE SET TargetReceivableTaxDetail.UpdatedById = @CreatedById, TargetReceivableTaxDetail.UpdatedTime = @CreatedTime,
TargetReceivableTaxDetail.Amount_Amount = TargetReceivableTaxDetail.Amount_Amount + SourceReceivableTaxDetail.Amount_Amount,
TargetReceivableTaxDetail.Balance_Amount = TargetReceivableTaxDetail.Balance_Amount + SourceReceivableTaxDetail.Amount_Amount,
TargetReceivableTaxDetail.EffectiveBalance_Amount = TargetReceivableTaxDetail.EffectiveBalance_Amount + SourceReceivableTaxDetail.Amount_Amount
OUTPUT INSERTED.Id AS ReceivableTaxDetailId,
INSERTED.ReceivableDetailId AS ReceivableDetailId,
INSERTED.AssetId AS ReceivableDetailAssetId,
$Action AS Action
INTO #InsertedReceivableTaxDetails;
MERGE [ReceivableTaxDetails] With (ForceSeek) AS TargetReceivableTaxDetail
USING (SELECT * FROM #Temp_ReceivableTaxDetailsParameters WHERE AssetId IS NULL) AS SourceReceivableTaxDetail
ON (TargetReceivableTaxDetail.ReceivableDetailId = SourceReceivableTaxDetail.ReceivableDetailId AND
TargetReceivableTaxDetail.AssetId IS NULL AND TargetReceivableTaxDetail.IsActive = 1 )
WHEN NOT MATCHED THEN
INSERT
([TaxBasisType],
[Revenue_Amount],
[Revenue_Currency],
[FairMarketValue_Amount],
[FairMarketValue_Currency],
[Cost_Amount],
[Cost_Currency],
[TaxAreaId],
[IsActive],
[ManuallyAssessed],
[CreatedById],
[CreatedTime],
[AssetLocationId],
[LocationId],
[AssetId],
[ReceivableDetailId],
[ReceivableTaxId],
[IsGLPosted],
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
[UpfrontTaxMode],
[UpfrontPayableFactor],
[TaxCodeId]
)
Values( TaxBasisType,
Revenue_Amount,
Revenue_Currency,
FairMarketValue_Amount,
FairMarketValue_Currency,
Cost_Amount,
Cost_Currency,
TaxAreaId,
1,
@IsManuallyAssessed,
@CreatedById,
@CreatedTime,
AssetLocationId,
LocationId,
AssetId,
ReceivableDetailId,
ReceivableTaxId,
0,
Amount_Amount,
Amount_Currency,
Balance_Amount,
Balance_Currency,
EffectiveBalance_Amount,
EffectiveBalance_Currency,
'_',
[UpfrontPayableFactor],
[TaxCodeId]
)WHEN MATCHED THEN
UPDATE SET TargetReceivableTaxDetail.UpdatedById = @CreatedById, TargetReceivableTaxDetail.UpdatedTime = @CreatedTime,
TargetReceivableTaxDetail.Amount_Amount = TargetReceivableTaxDetail.Amount_Amount + SourceReceivableTaxDetail.Amount_Amount,
TargetReceivableTaxDetail.Balance_Amount = TargetReceivableTaxDetail.Balance_Amount + SourceReceivableTaxDetail.Amount_Amount,
TargetReceivableTaxDetail.EffectiveBalance_Amount = TargetReceivableTaxDetail.EffectiveBalance_Amount + SourceReceivableTaxDetail.Amount_Amount
OUTPUT INSERTED.Id AS ReceivableTaxDetailId,
INSERTED.ReceivableDetailId AS ReceivableDetailId,
INSERTED.AssetId AS ReceivableDetailAssetId,
$Action AS Action
INTO #InsertedReceivableTaxDetails;
INSERT INTO [dbo].[ReceivableTaxImpositions]
( [ExemptionType],
[ExemptionRate],
[ExemptionAmount_Amount],
[ExemptionAmount_Currency],
[TaxableBasisAmount_Amount],
[TaxableBasisAmount_Currency],
[AppliedTaxRate],
[OriginalTaxRate],
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
[ExternalTaxImpositionType],
[CreatedById],
[CreatedTime],
[TaxTypeId],
[ExternalJurisdictionLevelId],
[ReceivableTaxDetailId],
[IsActive],
[TaxBasisType],
[TaxRuleId]
)
SELECT [ExemptionType],
[ExemptionRate],
[ExemptionAmount_Amount],
[ExemptionAmount_Currency],
[TaxableBasisAmount_Amount],
[TaxableBasisAmount_Currency],
[AppliedTaxRate],
[OriginalTaxRate],
[Amount_Amount],
[Amount_Currency],
[Balance_Amount],
[Balance_Currency],
[EffectiveBalance_Amount],
[EffectiveBalance_Currency],
[ExternalTaxImpositionType],
@CreatedById,
@CreatedTime,
[TaxTypeId],
[ExternalJurisdictionLevelId],
[ReceivableTaxDetailId],
1,
TaxBasisType,
TaxRuleId
FROM #ReceivableTaxImpositionParameter RTIP
INNER JOIN #InsertedReceivableTaxDetails IRTD ON RTIP.ReceivableDetailId = IRTD.ReceivableDetailId AND IRTD.Action = 'INSERT'
WHERE IRTD.ReceivableDetailAssetId = RTIP.AssetId OR RTIP.AssetId IS NULL;
;
INSERT INTO [dbo].[ReceivableTaxSKUImpositions]
( [ExemptionType],
[ExemptionRate],
[ExemptionAmount_Amount],
[ExemptionAmount_Currency],
[TaxableBasisAmount_Amount],
[TaxableBasisAmount_Currency],
[AppliedTaxRate],
[OriginalTaxRate],
[Amount_Amount],
[Amount_Currency],
[ExternalTaxImpositionType],
[CreatedById],
[CreatedTime],
[TaxTypeId],
[ExternalJurisdictionLevelId],
[ReceivableTaxDetailId],
[IsActive],
[AssetSKUId],
[TaxBasisType],
[TaxRuleId]
)
SELECT [ExemptionType],
[ExemptionRate],
[ExemptionAmount_Amount],
[ExemptionAmount_Currency],
[TaxableBasisAmount_Amount],
[TaxableBasisAmount_Currency],
[AppliedTaxRate],
[OriginalTaxRate],
[Amount_Amount],
[Amount_Currency],
[ExternalTaxImpositionType],
@CreatedById,
@CreatedTime,
[TaxTypeId],
[ExternalJurisdictionLevelId],
ReceivableTaxDetailId,
1,
[AssetSKUId],
TaxBasisType,
TaxRuleId
FROM #ReceivableTaxSKUImpositionParameter RTSKUIP
INNER JOIN #InsertedReceivableTaxDetails IRTD ON RTSKUIP.ReceivableDetailId = IRTD.ReceivableDetailId AND IRTD.Action = 'INSERT'
WHERE IRTD.ReceivableDetailAssetId = RTSKUIP.AssetId OR RTSKUIP.AssetId IS NULL;
INSERT INTO [dbo].[ReceivableTaxReversalDetails]
( [Id],
[IsExemptAtAsset],
[IsExemptAtLease],
[IsExemptAtSundry],
[Company],
[Product],
[ContractType],
[AssetType],
[LeaseType],
[LeaseTerm],
[TitleTransferCode],
[TransactionCode],
[AmountBilledToDate],
[CreatedById],
[CreatedTime],
[AssetId],
[AssetLocationId],
[ToStateName],
[FromStateName] ,
[SalesTaxRemittanceResponsibility],
[IsCapitalizeUpfrontSalesTax],
[UpfrontTaxAssessedInLegacySystem],
[BusCode],
[StringFlexField20],
[IsCapitalizedSalesTaxAsset]
)
SELECT IRTD.ReceivableTaxDetailId,
[IsExemptAtAsset],
[IsExemptAtLease],
[IsExemptAtSundry],
[Company],
[Product],
[ContractType],
[AssetType],
[LeaseType],
[LeaseTerm],
[TitleTransferCode],
[TransactionCode],
[AmountBilledToDate],
@CreatedById,
@CreatedTime,
[AssetId],
[AssetLocationId],
[ToStateName],
[FromStateName] ,
[SalesTaxRemittanceResponsibility],
[IsCapitalizeUpfrontSalesTax],
[UpfrontTaxAssessedInLegacySystem],
[BusCode],
[StringFlexField20],
[IsCapitalizedSalesTaxAsset]
FROM #ReceivableTaxReversalDetailParameter RTRDP
INNER JOIN #InsertedReceivableTaxDetails IRTD ON RTRDP.ReceivableDetailId = IRTD.ReceivableDetailId AND IRTD.Action = 'INSERT'
WHERE (IRTD.ReceivableDetailAssetId = RTRDP.AssetId OR RTRDP.AssetId IS NULL);
INSERT INTO [dbo].[ReceivableSKUTaxReversalDetails]
(
[Revenue_Amount],
[Revenue_Currency],
[FairMarketValue_Amount],
[FairMarketValue_Currency],
[Cost_Amount],
[Cost_Currency],
[IsActive],
[CreatedById],
[CreatedTime],
[AssetSKUId],
[ReceivableSKUId],
[ReceivableTaxDetailId],
[Amount_Amount],
[Amount_Currency],
[IsExemptAtAssetSKU],
[AmountBilledToDate_Amount],
[AmountBilledToDate_Currency],
[StringFlexField20]
)
SELECT
[Revenue_Amount],
[Revenue_Currency],
[FairMarketValue_Amount],
[FairMarketValue_Currency],
[Cost_Amount],
[Cost_Currency],
1,
@CreatedById,
@CreatedTime,
[AssetSKUId],
[ReceivableSKUId],
IRTD.ReceivableTaxDetailId,
[Amount_Amount],
[Amount_Currency],
[IsExemptAtAssetSKU],
[AmountBilledToDate_Amount],
[Amount_Currency],
[StringFlexField20]
FROM #ReceivableSKUTaxReversalDetailParameter RSTP
INNER JOIN #InsertedReceivableTaxDetails IRTD ON RSTP.ReceivableDetailId = IRTD.ReceivableDetailId AND IRTD.Action = 'INSERT';
UPDATE ReceivableDetails
SET IsTaxAssessed = 1 , UpdatedById = @CreatedById, UpdatedTime = @CreatedTime
FROM ReceivableDetails
JOIN #InsertedReceivableTaxDetails InsertedReceivableTaxDetail
ON ReceivableDetails.Id = InsertedReceivableTaxDetail.ReceivableDetailId AND InsertedReceivableTaxDetail.Action = 'INSERT'
DROP TABLE #InsertedReceivableTaxDetails;
DROP TABLE #InsertedReceivableTaxes;
END;
GO
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
