CC_MC_TBL5001

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MC_ACQUIRINGICA	Character(11)	VARCHAR2(11) NOT NULL	Acquiring ICA
2	MC_CARDACCEPTORID	Character(15)	VARCHAR2(15) NOT NULL	Card Acceptor ID
3	MC_CA_NAME	Character(50)	VARCHAR2(50) NOT NULL	Card Acceptor Name
4	MC_CA_ADDRESS	Character(50)	VARCHAR2(50) NOT NULL	Street Address
5	MC_CA_CITY	Character(20)	VARCHAR2(20) NOT NULL	City
6	MC_CA_STATE	Character(10)	VARCHAR2(10) NOT NULL	State/Province Code
7	MC_CA_LOCPOSTAL	Character(13)	VARCHAR2(13) NOT NULL	Location Postal Code
8	MC_CA_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Country Code
9	MC_CA_SERVICEPHONE	Character(25)	VARCHAR2(25) NOT NULL	Customer Service Telephone
10	MC_CA_PHONE	Character(25)	VARCHAR2(25) NOT NULL	Telephone
11	MC_CA_ADDCONTACT	Character(25)	VARCHAR2(25) NOT NULL	Additional Contact Information
12	MC_SOLEPROPRIETOR	Character(30)	VARCHAR2(30) NOT NULL	Sole Proprietor Name
13	MC_LEGALNAME	Character(30)	VARCHAR2(30) NOT NULL	Legal Corporation Name
14	MC_CA_BUSINESSCODE	Character(4)	VARCHAR2(4) NOT NULL	Business Code
15	MC_CA_TYPEIND	Character(4)	VARCHAR2(4) NOT NULL	Type Indicator
16	MC_CA_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Type
17	MC_DUNNUM	Character(15)	VARCHAR2(15) NOT NULL	DUN Num
18	MC_AUSTINTETRANUM	Character(15)	VARCHAR2(15) NOT NULL	Austin Tetra Num
19	MC_CA_NAICSNUM	Character(15)	VARCHAR2(15) NOT NULL	NAICS Num
20	MC_TAXIDINDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Tax Id Indicator N=No R=Refused Y=Yes
21	MC_CA_TAXID	Character(20)	VARCHAR2(20) NOT NULL	Tax Id
22	MC_CA_VATNUM	Character(20)	VARCHAR2(20) NOT NULL	VAT Num
23	MC_CA_DESCR	Character(201)	VARCHAR2(201) NOT NULL	Alternate Description