Field Listing for Table REPORTINGPERIODSDEF
Field: | PERIODCODE | Type: | VARCHAR Length: 20 |
Field: | CODEDESCRIPTION | Type: | VARCHAR Length: 100 |
Field: | PERIOD1STARTDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD1STARTOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD1STARTOFFSET | Type: | INTEGER |
Field: | PERIOD1STARTFIXEDDATE | Type: | DATE |
Field: | PERIOD1ENDDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD1ENDOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD1ENDOFFSET | Type: | INTEGER |
Field: | PERIOD1ENDFIXEDDATE | Type: | DATE |
Field: | PERIOD2STARTDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD2STARTOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD2STARTOFFSET | Type: | INTEGER |
Field: | PERIOD2STARTFIXEDDATE | Type: | DATE |
Field: | PERIOD2ENDDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD2ENDOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD2ENDOFFSET | Type: | INTEGER |
Field: | PERIOD2ENDFIXEDDATE | Type: | DATE |
Field: | PERIOD3STARTDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD3STARTOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD3STARTOFFSET | Type: | INTEGER |
Field: | PERIOD3STARTFIXEDDATE | Type: | DATE |
Field: | PERIOD3ENDDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD3ENDOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD3ENDOFFSET | Type: | INTEGER |
Field: | PERIOD3ENDFIXEDDATE | Type: | DATE |
Field: | PERIOD4STARTDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD4STARTOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD4STARTOFFSET | Type: | INTEGER |
Field: | PERIOD4STARTFIXEDDATE | Type: | DATE |
Field: | PERIOD4ENDDATETYPE | Type: | VARCHAR Length: 20 |
Field: | PERIOD4ENDOFFSETTYPE | Type: | VARCHAR Length: 10 |
Field: | PERIOD4ENDOFFSET | Type: | INTEGER |
Field: | PERIOD4ENDFIXEDDATE | Type: | DATE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |