Functional Description
Purpose
Based on a date and date pattern passed in, return the century, fiscal year, period number, and
period end date. Also return the begin fiscal year, 14 period end dates, normal number of periods and
prior period end date. The date must fall within one of the Date Pattern records set up in F0008.
You can also get the period end date for a particular period number, fiscal year and century by
leaving the input date blank and passing a date pattern, period number, fiscal year and century.
Setup Notes and Prerequisites
Special Logic
Normal Number of Periods will be determined to be the last period with a date different than the
preceding period. This can be different from the Normal Number of Periods as set in the Company Constant
file (F0010) when in a short year.
Technical Specification
D0000167 - F0008 Get Date Pattern Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cFiscalDatePattern | DTPN | char | NONE | NONE |
A code that identifies date patterns. You can use one of 15 codes. You must set up special codes (letters A through N) for 4-4-5, 13-period
| ||||
jdDateForGL | DGJ | JDEDATE | NONE | NONE |
Special Input Expected
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
| ||||
mnPeriodNo | PN | MATH_NUMERIC | NONE | NONE |
Special Input Expected
| ||||
jdDate01 | DATE01 | JDEDATE | NONE | NONE |
Special Output Returned
| ||||
szNumberofPeriodsOverride | NNPO | char | NONE | NONE |
Special Output Returned
| ||||
jdDateFiscalYearBegins | DFYJ | JDEDATE | NONE | NONE |
The first day of the fiscal year. | ||||
jdDateEndofPeriod01 | D01J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period, or 52-period accounting. | ||||
jdDateEndofPeriod02 | D02J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod03 | D03J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod04 | D04J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod05 | D05J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod06 | D06J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod07 | D07J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod08 | D08J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod09 | D09J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod10 | D10J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod11 | D11J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod12 | D12J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod13 | D13J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdDateEndofPeriod14 | D14J | JDEDATE | NONE | NONE |
The month end date in 12-period (monthly) accounting. The period end date in 13-period, or 4-4-5 period accounting. | ||||
jdPreviousPeriodEndDate | DATE02 | JDEDATE | NONE | NONE |
Special Output Returned
|
None |
F0008 Date Fiscal Patterns |