Tax Codes
Tim Trinka
Can anyone tell me what table stores the tax code information for each customer?
Thank you,
Partners. Expertise. Teamwork. Solutions.
Randall Blinn
Hi Tim;
In PSI it is a VIEW – SSARTAX
In Macola it is a TABLE – TAXDETL_SQL
This is the VIEW in PSI (SSARTAX):
SELECT
CAST(ISNULL(TAX_CD,'') AS char(3)) as [CODE],
CAST(ISNULL(TAX_CD_DESC,'') AS varchar(30)) as [DESCRIPT],
CAST(ISNULL(TAX_PCT,0) AS numeric(6,4)) as [TAXPCT],
CAST(ISNULL(MN_NO,'') AS char(8)) as [TAXMAIN],
CAST(ISNULL(SB_NO,'') AS char(8)) as [TAXSUB],
CAST(ISNULL(DP_NO,'') AS char(8)) as [TAXDP],
CAST(ISNULL(FRT_FG,'') AS char(1)) as [TAXFRT],
CAST(ISNULL(MISC_CHG_FG,'') AS char(1)) as [TAXMISC],
CAST(ISNULL(TAX_METH,'') AS char(1)) as [METHOD]
FROM [PSI-DB].[DATA].[DBO].TAXDETL_SQL
I know that the Customer Invoice asks for a TAX CODE (three levels). I’m not sure if SSCUSTOM has a default tax code in the Customer table or not.
Hope this helps!!
Randall G Blinn
GRAPHIC COMPUTER CONSULTANTS, INC.
--
You received this message because you are subscribed to the Google Groups "PSIUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
psiusers+u...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/psiusers/IA0PPF78AC829332B0A0DC1E5D9145E1C2AC92BA%40IA0PPF78AC82933.namprd19.prod.outlook.com.
Andy van Staveren
Hi Tim,
That tax code for each customer is in the Macola table: arcusfil. Header is tax_cd.
Andy
From: psiu...@googlegroups.com <psiu...@googlegroups.com> On Behalf Of Tim Trinka
Sent: Tuesday, August 12, 2025 12:52 PM
To: psiu...@googlegroups.com
Subject: [SPF ERROR] Tax Codes
Can anyone tell me what table stores the tax code information for each customer? Thank you, Partners. Expertise. Teamwork. Solutions. www.ulitho.com -- You received this message because you are subscr
|
--