GPMX_CFDI_TBL

(SQL Table)
 Index Back

CFDI Report

CFDI Report

  • Parent Record Of GPMX_CFDI2_DTL GPMX_CFDI3_DTL GPMX_CFDI4_DTL GPMX_CFDI_DTL GPMX_CFDI_OPMT GPMX_CFDI_SNCF GPMX_NRP_CFO_AD GPMX_NRP_CFO_VW

    • # 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: %date

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

    Default Value: A

    4 GPMX_COMP_ACTIVITY Character(2) VARCHAR2(2) NOT NULL Company Settings
    1=Class I
    2=Class II
    3=Class III
    4=Class IV
    5=Class V
    99=Not Applicable
    5 GPMX_TAX_TREATMENT Character(3) VARCHAR2(3) NOT NULL Tax Treatment MEX
    601=General of Law Moral Persons
    603=Non-Profit Moral Persons
    605=Wages & Salaries & Assimilated
    606=Lease
    607=Disposal/Acquisition of Goods
    608=Other income
    609=Consolidation
    610=Residents Abroad w/o Permanent
    611=Income from Dividends
    612=Physical Persons w/Business
    614=Interest income
    615=Income for getting prizes
    616=Without tax obligations
    620=Cooperative Production Comp
    621=Tax Incorporation
    622=Agricultural, Livestock, Fores
    623=Optional for Groups of Comp
    624=Coordinated
    6 GPMX_EMP_TAX_TREAT Character(3) VARCHAR2(3) NOT NULL Employee Tax Treatment MEX
    605=Wages & Salaries & Assimilated