News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Time and Expense Setup...

Microsoft Dynamics SL (Archived)

Time and Expense Setup First Day of Week

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Which SQL table and fields holds the Entry for First Day of the Week? I looked in Customization and references a BTMSETUP table which doesn't seem to exist.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Ram Peru 2,830 on at

Like (0)

Report

RE: Time and Expense Setup First Day of Week

Hello Jim,

Thanks for your gratefulness.

kindly verify the earlier post as answer, this would be very helpful to our community SL user if you have verified the earlier post.

Thanks,

Perumalsamy R
Community Member Microsoft Employee on at

Like (0)

Report

RE: Time and Expense Setup First Day of Week

Thanks this is appreciated
Suggested answer

Ram Peru 2,830 on at

Like (0)

Report

RE: Time and Expense Setup First Day of Week

Hello Jim Hummer,

The PJCONTRL table holds the data of Time & Expense setup screen. Below is the Query used to view the First day of the Week.

Control_data field holds the value of First day of the week.

Select control_data,* from PJCONTRL Where control_type = 'TM' and control_code = 'SETUP'

Below Query is used to know about the entire Time & Expense Setup,

Select * from PJCONTRL Where control_type = 'TM'

Hope this will help you to know about the time & expense screen.

Thanks,

Perumalsamy R

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans