FS_MC_TSPAN_AET(SQL Table) |
Index Back |
|---|---|
FS MC - timespan state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID_TIMESPANS | Character(5) | VARCHAR2(5) NOT NULL | TimeSpans SetID |
| 3 | TIME_SPAN | Character(10) | VARCHAR2(10) NOT NULL | TimeSpan |
| 4 | SETID_CALENDAR | Character(5) | VARCHAR2(5) NOT NULL | Calendar Setid |
| 5 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 6 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 7 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 8 | SINGLE_YEAR_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Flag for Multi-Currency processing. |
| 9 | START_YEAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Start Year Type
A=Absolute Year R=Relative to Current Year |
| 10 | START_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | Start Year |
| 11 | START_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Start Period Type
A=Absolute Period R=Relative to Current Period |
| 12 | START_PERIOD | Signed Number(4,0) | DECIMAL(3) NOT NULL | Start Period |
| 13 | END_YEAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
End Year Type
A=Absolute Year R=Relative to Current Year |
| 14 | END_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | End Year |
| 15 | END_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
End Period Type
A=Absolute Period R=Relative to Current Period |
| 16 | END_PERIOD | Signed Number(4,0) | DECIMAL(3) NOT NULL | End Period |
| 17 | START_ADJPER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Start Adjustment Period Type
A=Absolute Period R=Relative to Current Period |
| 18 | START_ADJPER | Signed Number(4,0) | DECIMAL(3) NOT NULL | Start Adjustment Period |
| 19 | END_ADJPER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
End Adjustment Period Type
A=Absolute Period R=Relative to Current Period |
| 20 | END_ADJPER | Signed Number(4,0) | DECIMAL(3) NOT NULL | End Adjustment Period |
| 21 | INCLUDE_BAL_FRWD | Character(1) | VARCHAR2(1) NOT NULL | Include Balance Forward |
| 22 | INCLUDE_CLOSE_PER | Character(1) | VARCHAR2(1) NOT NULL |
Include Closing Adjustments
N=No Adjustment Period S=Specify Adjustment Period Y=Adjustment Period 998 |
| 23 | PERIOD_LIST | Character(254) | VARCHAR2(254) NOT NULL | Accounting Period List |
| 24 | DETPER_FROM | Number(3,0) | SMALLINT NOT NULL | Detail Period From |
| 25 | DETPER_TO | Number(3,0) | SMALLINT NOT NULL | Detail Period To |
| 26 | ADJ_PER_FROM | Number(3,0) | SMALLINT NOT NULL | Adjustment Period From |
| 27 | ADJ_PER_TO | Number(3,0) | SMALLINT NOT NULL | Adjustment Period To |
| 28 | PERIOD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Period type
0=Regular and Adjustment Periods 1=Regular Periods 2=Adjustment Periods |