ALTER TABLE PermanentSettings	ADD ZatcaPhases  int NOT NULL default 1
GO
CREATE OR ALTER PROC spPermanentSettings
(
@custcode nvarchar(5) = NULL,
@suppcode nvarchar(5) = NULL,
@ItemCode nvarchar(5) = NULL,
@focuson nvarchar(500) = NULL,
@DiscFocusOn nvarchar(200) = NULL,
@ConnectOn nvarchar(250) = NULL,
@QuotBfrItem nvarchar(50) = NULL,
@AllsysIntegration nvarchar(50) = NULL,
@invbilltype nvarchar(500) = NULL,
@PurBilltype nvarchar(500) = NULL,
@ProInvBilltype nvarchar(500) = NULL,
@ItemSelection nvarchar(5) = NULL,
@CrDaysBlock nvarchar(10) = NULL,
@StoreEnable nvarchar(10) = NULL,
@InvWL nvarchar(10) = NULL,
@InvRetWL nvarchar(10) = NULL,
@InvDNWL nvarchar(10) = NULL,
@ProInvWL nvarchar(10) = NULL,
@QuotWL nvarchar(10) = NULL,
@DNWL nvarchar(10) = NULL,
@POWL nvarchar(10) = NULL,
@InvTaxType nvarchar(10) = NULL,
@InvRetTaxType nvarchar(10) = NULL,
@InvDNTaxType nvarchar(10) = NULL,
@InvFocusStartFrom nvarchar(500) = NULL,
@PurFocusStartFrom nvarchar(500) = NULL,
@InvNoString nvarchar(5) = NULL,
@DeliveryFocusStartFrom nvarchar(500) = NULL,
@Replacement nvarchar(5) = NULL,
@QuotFocusStartFrom nvarchar(500) = NULL,
@InvPP nvarchar(10) = NULL,
@InvRetPP nvarchar(10) = NULL,
@InvDNPP nvarchar(10) = NULL,
@ProInvPP nvarchar(10) = NULL,
@QuotPP nvarchar(10) = NULL,
@DNPP nvarchar(10) = NULL,
@POPP nvarchar(10) = NULL,
@POFocusStartFrom nvarchar(500) = NULL,
@DeliveryEffect nvarchar(5) = NULL,
@DNItemSlno nvarchar(5) = NULL,
@InvItemSlno nvarchar(5) = NULL,
@QuotItemSlno nvarchar(5) = NULL,
@PRInvItemSlno nvarchar(5) = NULL,
@ItemPrefix nvarchar(5) = NULL,
@ItemPrefixvalue nvarchar(50) = NULL,
@ItemSearchCount decimal(18,4) = NULL,
@ExpDfltVat decimal(18,4) = NULL,
@JrnlDfltVat decimal(18,4) = NULL,
@Itmsrhfilt nvarchar(5) = NULL,
@Fcsaftitmto nvarchar(50) = NULL,
@ShowStdCost nvarchar(500) = NULL,
@ItCodeColWidth decimal(18,4) = NULL,
@ItNameColWidth decimal(18,4) = NULL,
@ArItNameColWidth decimal(18,4) = NULL,
@UnitColWidth decimal(18,4) = NULL,
@StkColWidth decimal(18,4) = NULL,
@RateColWidth decimal(18,4) = NULL,
@CostColWidth decimal(18,4) = NULL,
@ModelColWidth decimal(18,4) = NULL,
@LocColWidth decimal(18,4) = NULL,
@TrnsSrchCnt decimal(18,4) = NULL,
@DfltCshCode nvarchar(500) = NULL,
@DfltCshName nvarchar(500) = NULL,
@DfltBnkCode nvarchar(500) = NULL,
@DfltBnkName nvarchar(500) = NULL,
@Apptype nvarchar(500) = NULL,
@UnitSelection nvarchar(50) = NULL,
@UIType nvarchar(50) = NULL,
@CustNameBlank nvarchar(5) = NULL,
@ZatcaPhases int = null
, @TransactionType NVARCHAR(20) = 'get'
)
AS
BEGIN
IF @TransactionType = 'update'
BEGIN
    UPDATE PermanentSettings SET
        custcode = @custcode,
        suppcode = @suppcode,
        ItemCode = @ItemCode,
        focuson = @focuson,
        DiscFocusOn = @DiscFocusOn,
        ConnectOn = @ConnectOn,
        QuotBfrItem = @QuotBfrItem,
        AllsysIntegration = @AllsysIntegration,
        invbilltype = @invbilltype,
        PurBilltype = @PurBilltype,
        ProInvBilltype = @ProInvBilltype,
        ItemSelection = @ItemSelection,
        CrDaysBlock = @CrDaysBlock,
        StoreEnable = @StoreEnable,
        InvWL = @InvWL,
        InvRetWL = @InvRetWL,
        InvDNWL = @InvDNWL,
        ProInvWL = @ProInvWL,
        QuotWL = @QuotWL,
        DNWL = @DNWL,
        POWL = @POWL,
        InvTaxType = @InvTaxType,
        InvRetTaxType = @InvRetTaxType,
        InvDNTaxType = @InvDNTaxType,
        InvFocusStartFrom = @InvFocusStartFrom,
        PurFocusStartFrom = @PurFocusStartFrom,
        InvNoString = @InvNoString,
        DeliveryFocusStartFrom = @DeliveryFocusStartFrom,
        Replacement = @Replacement,
        QuotFocusStartFrom = @QuotFocusStartFrom,
        InvPP = @InvPP,
        InvRetPP = @InvRetPP,
        InvDNPP = @InvDNPP,
        ProInvPP = @ProInvPP,
        QuotPP = @QuotPP,
        DNPP = @DNPP,
        POPP = @POPP,
        POFocusStartFrom = @POFocusStartFrom,
        DeliveryEffect = @DeliveryEffect,
        DNItemSlno = @DNItemSlno,
        InvItemSlno = @InvItemSlno,
        QuotItemSlno = @QuotItemSlno,
        PRInvItemSlno = @PRInvItemSlno,
        ItemPrefix = @ItemPrefix,
        ItemPrefixvalue = @ItemPrefixvalue,
        ItemSearchCount = @ItemSearchCount,
        ExpDfltVat = @ExpDfltVat,
        JrnlDfltVat = @JrnlDfltVat,
        Itmsrhfilt = @Itmsrhfilt,
        Fcsaftitmto = @Fcsaftitmto,
        ShowStdCost = @ShowStdCost,
        ItCodeColWidth = @ItCodeColWidth,
        ItNameColWidth = @ItNameColWidth,
        ArItNameColWidth = @ArItNameColWidth,
        UnitColWidth = @UnitColWidth,
        StkColWidth = @StkColWidth,
        RateColWidth = @RateColWidth,
        CostColWidth = @CostColWidth,
        ModelColWidth = @ModelColWidth,
        LocColWidth = @LocColWidth,
        TrnsSrchCnt = @TrnsSrchCnt,
        DfltCshCode = @DfltCshCode,
        DfltCshName = @DfltCshName,
        DfltBnkCode = @DfltBnkCode,
        DfltBnkName = @DfltBnkName,
        Apptype = @Apptype,
        UnitSelection = @UnitSelection,
        UIType = @UIType,
        CustNameBlank = @CustNameBlank,
		ZatcaPhases = @ZatcaPhases
   
END
ELSE
BEGIN
    SELECT
       
        custcode,
        suppcode,
        ItemCode,
        focuson,
        DiscFocusOn,
        ConnectOn,
        QuotBfrItem,
        AllsysIntegration,
        invbilltype,
        PurBilltype,
        ProInvBilltype,
        ItemSelection,
        CrDaysBlock,
        StoreEnable,
        InvWL,
        InvRetWL,
        InvDNWL,
        ProInvWL,
        QuotWL,
        DNWL,
        POWL,
        InvTaxType,
        InvRetTaxType,
        InvDNTaxType,
        InvFocusStartFrom,
        PurFocusStartFrom,
        InvNoString,
        DeliveryFocusStartFrom,
        Replacement,
        QuotFocusStartFrom,
        InvPP,
        InvRetPP,
        InvDNPP,
        ProInvPP,
        QuotPP,
        DNPP,
        POPP,
        POFocusStartFrom,
        DeliveryEffect,
        DNItemSlno,
        InvItemSlno,
        QuotItemSlno,
        PRInvItemSlno,
        ItemPrefix,
        ItemPrefixvalue,
        ItemSearchCount,
        ExpDfltVat,
        JrnlDfltVat,
        Itmsrhfilt,
        Fcsaftitmto,
        ShowStdCost,
        ItCodeColWidth,
        ItNameColWidth,
        ArItNameColWidth,
        UnitColWidth,
        StkColWidth,
        RateColWidth,
        CostColWidth,
        ModelColWidth,
        LocColWidth,
        TrnsSrchCnt,
        DfltCshCode,
        DfltCshName,
        DfltBnkCode,
        DfltBnkName,
        Apptype,
        UnitSelection,
        UIType,
        CustNameBlank,
		ZatcaPhases
    FROM PermanentSettings 
END
END