F1303RetrieveExclusionDays

F1303 Retrieve Exclusion Days

Minor Business Rule

Object Name: B1300140

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of the F1303 Retrieve Include/Exclude Days is to retrieve any included or excluded days
for the Billing Days Calendar. When a day is normally billable, but there is a record in F1303 to
exclude the day, then the day becomes non-billable. When a day is normally non-billable, but there is a
record in F1303 to include the day, then the day becomes billable.

Setup Notes and Prerequisites

Special Logic

Technical Specification




Set selection for F1303 using Year, Month, Company, and Location equal to input.


While Fetch is successful


Fetch the include/exclude code from the Billing Exclusion Days table (F1303).


If Code found for the specified month


If day is equal to Calendar Location 01


If code equal to I


set Type of Day 01 = B


If code equal to E


set Type of Day 01 = N


If day is equal to Calendar Location 02


If code equal to I


set Type of Day 02 = B


If code equal to E


set Type of Day 02 = N


Etc.


End If


End While

Data Structure

D1300140 - F1303 Retrieve Exclusion Days

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnDateYr	DTEY	MATH_NUMERIC	NONE	NONE
A two-digit number that specifies the applicable year. If you leave this field blank, the program uses the system date.
mnDateMo	DTEM	MATH_NUMERIC	NONE	NONE
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date.
szCompany	CO	char	NONE	NONE
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szCostCenterLocation	LOC	char	NONE	NONE
The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table (F0006).
mnCalendarLocation01	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation02	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation03	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation04	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation05	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation06	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation07	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation08	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation09	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation10	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation11	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation12	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation13	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation14	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation15	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation16	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation17	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation18	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation19	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation20	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation21	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation22	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation23	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation24	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation25	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation26	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation27	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation28	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation29	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation30	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation31	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation32	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation33	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation34	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation35	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation36	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
mnCalendarLocation37	CAL01	MATH_NUMERIC	NONE	NONE
Current calendar date for this month and year.
cTypeOfDay	TDWF	char	NONE	NONE
Return 'N' if Excluded Return 'B' if Included Same for all cTypeOfDay ^
cTypeOfDay_2	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_3	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_4	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_5	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_6	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_7	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_8	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_9	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_10	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_11	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_12	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_13	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_14	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_15	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_16	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_17	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_18	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_19	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_20	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_21	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_22	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_23	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_24	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_25	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_26	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_27	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_28	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_29	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_30	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_31	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_32	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_33	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_34	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_35	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_36	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day
cTypeOfDay_37	TDWF	char	NONE	NONE
A code that specifies whether the day of the week is a working day, holiday, vacation day, and so on. The value that you enter must exist in UDC 00/TD. Examples of values include: A Absent B Billable E Weekend H Holiday W Work Day

Related Functions

None

Related Tables

F1303 Billing Exception Days