Financial Months
Import Specification: Financial Months
Table Name: LookupsFinancialMonths
Table Type: Lookups
Current Import Version: 1.0
Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
Precision |
|
|
FinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
|
|
FinancialMonthStartDate |
Date |
Yes |
- |
|
|
|
FinancialMonthEndDate |
Date |
Yes |
- |
|
|
|
ContractYear |
Numeric |
Yes |
Min: 0 Max: 30 |
|
0 |
|
ContractorFiscalYear |
Numeric |
Yes |
Min: 2000 Max: 2099 |
|
|
|
ContractorFinancialMonthCode |
FinancialMonth |
Yes |
6 |
|
|
|
AgencyFiscalYear |
Numeric |
Yes |
Min: 2000 Max: 2099 |
|
0 |
|
WorkingDays |
Numeric |
Yes |
Min: 0 Max: 60 |
|
0 |
|
WorkingHours |
Numeric |
Yes |
Min: 0 Max: 999 |
|
0 |
|
ProductiveDays |
Numeric |
Yes |
Min: 0 Max: 60 |
|
0 |
|
ProductiveHours |
Numeric |
Yes |
Min: 0 Max: 999 |
|
0 |
|
FinancialMonthGroup1 |
String |
No |
50 |
|
|
|
FinancialMonthGroup2 |
String |
No |
50 |
|
|
|
FinancialMonthGroup3 |
String |
No |
50 |
|
|
|
FinancialMonthGroup4 |
String |
No |
50 |
|
|
|
FinancialMonthGroup5 |
String |
No |
50 |
|
|
|
IsClosed |
Boolean |
Yes |
- |
|
|
Available Import Header Commands
* This is the default behavior for file import processing of this table.
Page ID:9757-9352-2103