GPMX_NRP_CFO_VW

(SQL View)
 Index Back

CFDI- Other Payment Mapping

CFDI Report - Other Payment Mapping

SELECT COMPANY , EFFDT , ENTRY_TYPE_ELEM , PIN_NUM + 50000000 , GPMX_TP_CAT_CFDI , GPMX_CFDI_OPM_TYPE , GPMX_CFDI_LCD_ADJ , GPMX_SUM_FLAG , GPMX_SUB_EMP_PAID FROM PS_GPMX_CFDI_OPMT

  • Parent record: GPMX_CFDI_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: GPMX_CFDI_TBL.EFFDT

    3 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GPMX_ENT_ED_VW

    4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Default Value: 0

    Prompt Table: %GP_PIN_E_D_VW

    5 GPMX_TP_CAT_CFDI Character(1) VARCHAR2(1) NOT NULL Catalog Type CFD MEX
    D=Deductions
    E=Earnings
    6 GPMX_CFDI_OPM_TYPE Character(3) VARCHAR2(3) NOT NULL Other Payment Type Codes for CFDI
    001=ISR Devolution
    002=Employment Subsidy
    003=Travel Expenses
    004=Positive Balance Application
    005=Refund Prev ISR Over-Withheld
    006=Work Canteen Serv Art 94 LISR
    007=ISR Adjusted by Subsidy
    008=Overpaid Subsidy
    009=INFONAVIT Paid In Excess
    999=Other Payments
    7 GPMX_CFDI_LCD_ADJ Character(3) VARCHAR2(3) NOT NULL CFDI Report - Adjustment Legal Code provided by SAT
    8 GPMX_SUM_FLAG Character(1) VARCHAR2(1) NOT NULL Summarize Flag

    Y/N Table Edit

    Default Value: Y

    9 GPMX_SUB_EMP_PAID Character(1) VARCHAR2(1) NOT NULL Employment Subsidy Effective Paid

    Y/N Table Edit

    Default Value: N