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(250) VARCHAR2(250) NOT NULL Tax Treatment MEX
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 PTP_CHAR01 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
21 PTP_CHAR02 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
22 PTP_CHAR03 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
23 PTP_CHAR04 Character(1) VARCHAR2(1) NOT NULL PTP Character Field
24 PTP_CHAR05 Character(1) VARCHAR2(1) NOT NULL PTP Character Field