Planning Calendar

Planning Calendars are referenced by Parts and used for replenishment calculations.

Column Name
Type
Max Length
Required
Values

Name

text

50

Yes

Must be unique

Sunday

boolean

Yes

0 or 1, True or False

Monday

boolean

Yes

0 or 1, True or False

Tuesday

boolean

Yes

0 or 1, True or False

Wednesday

boolean

Yes

0 or 1, True or False

Thursday

boolean

Yes

0 or 1, True or False

Friday

boolean

Yes

0 or 1, True or False

Saturday

boolean

Yes

0 or 1, True or False

WeeksOfMonth

text

1024

No

Use text (First, All, Last, etc.) or

numbers (-1, 0, 2) separated by

commas to indicate which weeks.

  • -1 = Last

  • 0 = All

  • 1 = First

  • 2 = Second

  • 3 = Third

  • 4 = Fourth

Last updated