GPIT_DM10_CODES

(SQL Table)
Index Back

Main Record: Row Codes DM10

Main Record for the report DM10; Global Payroll Italy.

  • Related Language Record: GPIT_CODES_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPIT_DM10_ID Character(6) VARCHAR2(6) NOT NULL Dm10 Code ID... Naming convention: X_YYYY
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 GPIT_DM10_DESCR Character(30) VARCHAR2(30) NOT NULL Dm10 Code Description
    5 GPIT_DM10_TABLE Character(1) VARCHAR2(1) NOT NULL The square name on the report. There are 2 values possibilities: B/C or D.
    A=Square A on the DM10 Report
    B=Square B on the DM10 report
    D=Square D on the DM10 report

    Default Value: B

    6 GPIT_DM10_POSITION Character(5) VARCHAR2(5) NOT NULL DM10 square position... This is the position on the appropriate Square on the DM10 report. Where the row data should be written... This field can be left blank in this case the there is no pre-printed data on the report. So this is a not required field.
    7 GPIT_DM10_CODICE Character(4) VARCHAR2(4) NOT NULL This DM10 Code corresponding to the Code line on the report. It's one-to-one relationship between this code and the Italian law predefined codes.... There is a strong relationship with the position on the DM10 report. When position firled is blank this field should reflect the code value on the report.
    8 GPIT_DM10_COD_DESC Character(30) VARCHAR2(30) NOT NULL DM10 Code Description.
    9 GPIT_DM10_GROUP Character(4) VARCHAR2(4) NOT NULL DM10 Group Code.

    Prompt Table: GPIT_DM10_GROUP

    10 GPIT_DM10_EE_FLAG Character(1) VARCHAR2(1) NOT NULL Payee Counter Flag. 'Y'es: payee counted for the DM10. 'N'o: Payee not counted for the DM10.

    Y/N Table Edit

    Default Value: N

    11 GPIT_DM10_CAT_FROM Character(1) VARCHAR2(1) NOT NULL Inps Category From value.
    12 GPIT_DM10_CAT_TO Character(1) VARCHAR2(1) NOT NULL Inps Category To: Illigibilty Value....
    13 GPIT_DM10_TIM_FROM Number(8,4) DECIMAL(7,4) NOT NULL DM10 % Part time
    14 GPIT_DM10_TIME_TO Number(8,4) DECIMAL(7,4) NOT NULL DM10 % Part time To
    15 GPIT_DM10_COD_FROM Character(2) VARCHAR2(2) NOT NULL Contributive Codice From....
    16 GPIT_DM10_CODCE_TO Character(2) VARCHAR2(2) NOT NULL DM10 Codice To Value
    17 GPIT_DM10_EE_FROM Character(1) VARCHAR2(1) NOT NULL Pay Reduction by Employee
    18 GPIT_DM10_PAYEE_TO Character(1) VARCHAR2(1) NOT NULL Pay reduction By EE
    19 GPIT_DM10_KY5_FROM Character(2) VARCHAR2(2) NOT NULL Argument 5 DM10: Value From
    20 GPIT_DM10_KEY5_TO Character(2) VARCHAR2(2) NOT NULL DM10 Key5: Value To
    21 GPIT_DM10_COMMENTS Long Character CLOB DM10 Row Comments