FinancialMonth
The FinancialMonth Data Type will contain numeric characters that represent the month and year of a Financial Month that is defined in the Financial Months table.
Financial Months are always represented as a 4-digit year followed by a 2-digit CALENDAR month. The Financial Month should NOT follow the format of a FISCAL Month. FISCAL months may be represented as periods rather than calendar months. For instance, if your 2017 Fiscal Year begins in October 2016, your FISCAL Month may be represented as 201701, but the FINANCIAL Month would be represented as 201610.
Acceptable Data Formats
- 201607
- 201701
Invalid Formats
- Inverted Year and Month
- 072016
- Month Abbreviations
- 2016JUL
- Less than 6 characters
- 20167
Sample Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
|
|
TaskCode |
String |
Yes |
32 |
|
|
SubTaskCode |
String |
No |
32 |
|
|
FinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
|
AccountCode |
String |
No |
32 |
|
|
Dollars |
Numeric |
Yes |
- |
|
|
PaymentDate |
Date |
Yes |
- |
|
|
SourceTransactionID |
String |
No |
64 |
|
Page ID:2270-1409-5216