GPMX_CF_COM_TMP

(SQL Table)
Index Back

CFDI Company MEX

CFDI Company MEX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
5 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
6 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
7 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 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
14 RFC_ER_ID_MEX Character(16) VARCHAR2(16) NOT NULL RFC ID Number
15 PT_RECFIELDVALUE Character(100) VARCHAR2(100) NOT NULL Parameter Value
16 PT_RECFIELDVALUE1 Character(100) VARCHAR2(100) NOT NULL Parameter Value
17 PT_RECFIELDVALUE2 Character(100) VARCHAR2(100) NOT NULL Parameter Value
18 PT_RECFIELDVALUE3 Character(100) VARCHAR2(100) NOT NULL Parameter Value
19 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
20 PTNODE_DESCR5 Character(50) VARCHAR2(50) NOT NULL Node Description 5
21 PTP_CHAR01 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
22 PTP_CHAR02 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
23 PTP_CHAR03 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
24 PTP_CHAR04 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
25 PTP_CHAR05 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
26 PTP_CHAR06 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
27 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
28 DESCR100_2 Character(100) VARCHAR2(100) NOT NULL Description
29 DESCR100_3 Character(100) VARCHAR2(100) NOT NULL Description
30 DESCR100_4 Character(100) VARCHAR2(100) NOT NULL Description
31 PTP_CHAR07 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
32 PTP_CHAR08 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
33 PTP_CHAR09 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
34 PTP_CHAR10 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
35 DESCR_MEX Character(100) VARCHAR2(100) NOT NULL Description