GPMX_CFDI_TBL (SQL Table)	Index Back
CFDI Report CFDI Report

GPMX_CFDI_TBL

(SQL Table)

CFDI Report

Parent Record Of GPMX_CFDI2_DTL GPMX_CFDI3_DTL GPMX_CFDI4_DTL GPMX_CFDI_DTL

# 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(1) VARCHAR2(1) NOT NULL Company Settings
1=Class I
2=Class II
3=Class III
4=Class IV
5=Class V

5 GPMX_TAX_TREATMENT Character(250) VARCHAR2(250) NOT NULL Tax Treatment MEX

#	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(1)	VARCHAR2(1) NOT NULL	Company Settings 1=Class I 2=Class II 3=Class III 4=Class IV 5=Class V
5	GPMX_TAX_TREATMENT	Character(250)	VARCHAR2(250) NOT NULL	Tax Treatment MEX