Dynamics Community Forum Thread Details

Adding a new Benifit through SQL script and am getting the message that a posting account is not set up for this benifit.

Adding a new Benifit through SQL script and am getting the message that a posting account is not set up for this benifit. My users have set up the posting account. I am updating tables BE010130 and UPR00600 with a straight insert into script.

INSERT INTO [dbo].[UPR00600]
([EMPLOYID], [BENEFIT],[INACTIVE],[BNFBEGDT],[BNFENDDT],[VARBENFT],[BNFTFREQ],[TAXABLE],[SBJTFDTX],[SBJTSSEC],[SBJTMCAR],[SBJTSTTX],[SBJTLTAX],[SBJTFUTA],[SBJTSUTA],[FFEDTXRT],[FLSTTXRT],[BORCDTYP],[BSDORCDS]
,[BNFTMTHD],[BNFFRMLA],[BNFPRCNT_1],[BNFPRCNT_2],[BNFPRCNT_3],[BNFPRCNT_4],[BNFPRCNT_5],[BNFITAMT_1],[BNFITAMT_2],[BNFITAMT_3],[BNFITAMT_4],[BNFITAMT_5],[BNFTRMAX_1],[BNFTRMAX_2],[BNFTRMAX_3],[BNFTRMAX_4]
,[BNFTRMAX_5],[BNTRMXUN_1],[BNTRMXUN_2],[BNTRMXUN_3],[BNTRMXUN_4],[BNTRMXUN_5],[BNPAYPMX],[BNFYRMAX],[BNFLFMAX],[W2BXNMBR],[W2BXLABL],[NOTEINDX],[LTDBNFIT],[DATAENTDFLT],[EMPLRMAXMAT],[W2BXNMBR2]
,[W2BXNMBR3],[W2BXNMBR4],[Benefit_Fiscal_Max])
VALUES
('002500692'
, 'UEPO-F', 0, '2015-07-01 00:00:00.000', '1900-01-01 00:00:00.000', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 0, 0, 0, 0, 0, 0, 779.55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 'DD', 32003, 0, 0, 0, 0, 0, 0, 0)
GO

Here is the other script

INSERT INTO [dbo].[BE010130]

([EMPID_I],[BENEFIT],[BENEFITTYPE_I],[IINDEX_I],[BENEFITKIND_I],[COMPLETIONSTATUS_I],[BENEFITSTATUS_I],[INACTIVE],[OVERRIDE_I],[CHECK1_I],[CHECK2_I],[CHECK3_I],[CHECK4_I],[CHECK5_I]

,[DATEDUE_I],[DSCRIPTN],[IBENEFITAMOUNT_I],[LIFEAMTEMPL_I],[LIFEAMTSPOUSE_I],[LIFEAMTCHILDREN_I],[BENELIGIBILEDATE_I],[BNFBEGDT],[BNFENDDT],[VARBENFT],[BNFTFREQ],[COSTEMPLOYEE_I]

,[COSTEMPLOYER_I],[COSTOTHER1_I],[COSTOTHER2_I],[I1_I],[I2_I],[I3_I],[I4_I],[NUMBEROFCHILDREN_I],[COSTTOTAL_I],[COSTCOBRA_I],[BENEFITDEDUCTIBLE_I],[BNPAYPMX],[BNFYRMAX],[BNFLFMAX],[BENEFICIARYINDEX_I]

,[CHANGEBY_I],[CHANGEDATE_I],[NOTESINDEX_I],[CONTRIBPRETAX_I],[CONTPRETAXDLR_I],[CONTRIBAFTERTAX_I],[CONTAFTERTAXDLR_I],[CONTRIBBONUS_I],[CONTRIBBONUSDOLLAR_I],[HIGHLYCOMPENSATED_I],[LOANACTIVE_I]

,[TYPEOFCODE_I],[TIERSUSED_I],[MAJMEDCOVERAGE_I],[MAXOUTOFPOCKET_I],[ELIGIBILITYDATE_I],[BNFTMTHD],[BNFFRMLA],[BNFPRCNT_1],[BNFPRCNT_2],[BNFPRCNT_3],[BNFPRCNT_4]

,[BNFPRCNT_5],[DEDNMTHD],[DEDFRMLA],[DEDNPRCT_1],[DEDNPRCT_2],[DEDNPRCT_3],[DEDNPRCT_4],[DEDNPRCT_5],[DEPYPRMX],[DEDYRMAX],[DEDLTMAX],[DEDINITBAL],[INACTBENEMPLOYEE],[INACTBENEMPLR],[Benefit_Fiscal_Max]

,[Deduction_Fiscal_Yr_Max])

VALUES

('002500692', 'UEPO-F', 'DEFLT', 2, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0,

'2015-06-24 00:00:00.000', 'UMR-EPO Family', 0, 0, 0, 0, '1900-01-01 00:00:00.000', '2015-07-01 00:00:00.000','1900-01-01 00:00:00.000', 0, 3, 24.11,

779.55, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,

'kovacevichm', '2015-06-24 00:00:00.000', 0, 0, 0, 0, 0, 0, 0, 0, 0,

3, 0, 0, 0, '1900-01-01 00:00:00.000', 0, 0, 0, 0, 0, 0,

0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,

0, 0)

Quick Links

Leaderboard