FMSAMTVENDOR - CCR Vendor Table (SAM UEI)

CCR Vendor Table (SAM UEI) information is stored in SAP table FMSAMTVENDOR.
It is part of development package FMFG_CCR_E in software component PSM-FG. This development package consists of objects that can be grouped under "Interface to Central Contractor Registry (CCR)".

Fields for table FMSAMTVENDOR

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		IFMSAMKEYS	0
SAM_UE_ID	System for Award Management Unique Entity Identifier	X	FMFG_UNIQUE_ENTITY_ID	CHAR	24
SAM_EFT_IND	System for Award Management Electronic Funds Transfer Ind	X	FMFG_EFT_IND	CHAR	8
DUNS	DUNS Number		FMCCRDUNS	CHAR	18
CAGE	CAGE Code		FMCCRCAGE	CHAR	10
DODAAC	Department of Defense Activity Address Code		FMSAMDODAAC	CHAR	18
EXCODE	Extract Code		FMCCREXCODE	CHAR	2
PUR_REG_CODE	SAM Purpose of Registration Code		FMSAMPUR_REG_CODE	CHAR	4
REGSTAT	Current Registration Status		FMCCR_REGSTAT	CHAR	20
REGDATE	Registration date		FMCCREGDAT	DATS	16
EXPDATE	Registration Expiration Date		FMCCR_EXPDATE	DATS	16
LASTUPDATE	Last Update Date		FMSAM_LASTUPD	DATS	16
ACTDATE	SAM Activation Date		FMSAM_ACTDATE	DATS	16
BUSNAME	Legal Business Name		FMCCR_BUSNAME	CHAR	240
DBANAME	Doing Business As		FMSAM_DBANAME	CHAR	240
COMPDIV	Company Division			CHAR	120
DIVNUM	Division Number			CHAR	20
STADD1	Street Address 1a			CHAR	300
STADD2	Street Address 2			CHAR	300
CITY	City			CHAR	80
STATE_PROVINCE	State or Province			CHAR	110
COUNTRY	Country Code			CHAR	6
DISTRICT	Congressional District			NUMC	20
DBOPENDATAFLG	D&B Open Data Flag			CHAR	2
BUSSTART	Business Start Date			DATS	16
FISCEND	Fiscal Year End Close Date			CHAR	8
COSECLVL	Company Security Level			CHAR	30
EMSECLVL	Employee Security Level			CHAR	30
URL	Corporate URL			CHAR	400
ENTSTRUCT	Entity Structure			CHAR	4
STATEINC	State of Incorporation			CHAR	4
COUNTRYINC	Country of Incorporation			CHAR	6
BUSTYPECNT	Business Type Counter			NUMC	8
BUSTYPES	Business Types			CHAR	440
.INCLUDE				FMCCRBUSTYPES	0
BUSTYP01	Business Type			CHAR	4
BUSTYP02	Business Type			CHAR	4
BUSTYP03	Business Type			CHAR	4
BUSTYP04	Business Type			CHAR	4
BUSTYP05	Business Type			CHAR	4
BUSTYP06	Business Type			CHAR	4
BUSTYP07	Business Type			CHAR	4
BUSTYP08	Business Type			CHAR	4
BUSTYP09	Business Type			CHAR	4
BUSTYP10	Business Type			CHAR	4
AGCY_BUS_PUR	SAM Agency Business Purpose			CHAR	2
PRIMARY_NAICS	SAM Primary NAICS Code			CHAR	12
NAICSCNT	NAICS Code Counter			NUMC	8
NAICS	NAICS codes			CHAR	240
.INCLUDE				FMCCRNAICS	0
NAICS01	NAICS Code			CHAR	12
NAICS02	NAICS Code			CHAR	12
NAICS03	NAICS Code			CHAR	12
NAICS04	NAICS Code			CHAR	12
NAICS05	NAICS Code			CHAR	12
NAICS06	NAICS Code			CHAR	12
NAICS07	NAICS Code			CHAR	12
NAICS08	NAICS Code			CHAR	12
NAICS09	NAICS Code			CHAR	12
NAICS10	NAICS Code			CHAR	12
NAICS11	NAICS Code			CHAR	12
NAICS12	NAICS Code			CHAR	12
NAICS13	NAICS Code			CHAR	12
NAICS14	NAICS Code			CHAR	12
NAICS15	NAICS Code			CHAR	12
NAICS16	NAICS Code			CHAR	12
NAICS17	NAICS Code			CHAR	12
NAICS18	NAICS Code			CHAR	12
NAICS19	NAICS Code			CHAR	12
NAICS20	NAICS Code			CHAR	12
PSCCODECNT	PSC Code Counter			NUMC	8
PSCCODE	PSC Codes			CHAR	80
.INCLUDE				FMCCRPSC	0
PSC01	PSC Code			CHAR	8
PSC02	PSC Code			CHAR	8
PSC03	PSC Code			CHAR	8
PSC04	PSC Code			CHAR	8
PSC05	PSC Code			CHAR	8
PSC06	PSC Code			CHAR	8
PSC07	PSC Code			CHAR	8
PSC08	PSC Code			CHAR	8
PSC09	PSC Code			CHAR	8
PSC10	PSC Code			CHAR	8
CREDCARD	Credit Card			CHAR	2
CORRFLAG	Correspondence Flag			CHAR	2
EVSOUTOFBUS	EVS Out of Business Indicator			CHAR	2
EVSMLASTUPD	EVS Monitoring Last Update			DATS	16
EVSMSTATUS	EVS Monitoring Status			CHAR	2
EDI	EDI Flag			CHAR	2
EDIVAN	Value Added Network			CHAR	40
EDIISAQ	ISA Qualifier			CHAR	4
EDIISASQ	ISA Identifier			CHAR	30
FUNCGRPID	Functional Group Identifier			CHAR	30
EDIREC820	820S Request Flag			CHAR	2
TAXIDTYP	Tax Identifier Type			CHAR	2
TAXID	CCR TaxID		FMCCRTAXID	NUMC	18
AVGNUMEMP	Average Number of Employees			CHAR	50
ANNUALREV	Annual Revenue			CHAR	50
FININST	Financial Institute (EFT)			CHAR	100
ACCNTNO	Account Number (EFT)			CHAR	60
ABAROUTE	ABA Routing ID (EFT)			CHAR	100
ACCNTTYPE	Payment Type (EFT)			CHAR	2
LOCKBOXNO	Lockbox Number (EFT)			CHAR	40
AUTHDATE	Authorization Date (EFT)			DATS	16
EFTWAIVER	EFT Waiver (EFT)			CHAR	2
MPIN	Marketing Partner ID Number			CHAR	18
NAICSEXCCNT	NAICS Exception Counter			NUMC	8
.INCLUDE				FMSAMNAICSEXC	0
NAICSEXC01	NAICS Exception Code			CHAR	20
NAICSEXC02	NAICS Exception Code			CHAR	20
NAICSEXC03	NAICS Exception Code			CHAR	20
NAICSEXC04	NAICS Exception Code			CHAR	20
NAICSEXC05	NAICS Exception Code			CHAR	20
NAICSEXC06	NAICS Exception Code			CHAR	20
NAICSEXC07	NAICS Exception Code			CHAR	20
NAICSEXC08	NAICS Exception Code			CHAR	20
NAICSEXC09	NAICS Exception Code			CHAR	20
NAICSEXC10	NAICS Exception Code			CHAR	20
DEBTOFFSET	Debt Offset Flag			CHAR	2
EXCLSTATFLAG	Exclusion Status Flag			CHAR	2
SBABUSTYPCNT	SBA Business Type Counter			NUMC	8
.INCLUDE				FMSAMSBABUSTYP	0
SBABUSTYP01	SBA Business Type Code			CHAR	20
SBABUSTYP02	SBA Business Type Code			CHAR	20
SBABUSTYP03	SBA Business Type Code			CHAR	20
SBABUSTYP04	SBA Business Type Code			CHAR	20
SBABUSTYP05	SBA Business Type Code			CHAR	20
SBABUSTYP06	SBA Business Type Code			CHAR	20
SBABUSTYP07	SBA Business Type Code			CHAR	20
SBABUSTYP08	SBA Business Type Code			CHAR	20
SBABUSTYP09	SBA Business Type Code			CHAR	20
SBABUSTYP10	SBA Business Type Code			CHAR	20
SAMNUMCNT	Numerics Counter			NUMC	8
.INCLUDE				FMSAMNUMERICS	0
NUMCODE01	SAM Numerics Code			CHAR	76
NUMCODE02	SAM Numerics Code			CHAR	76
NUMCODE03	SAM Numerics Code			CHAR	76
NUMCODE04	SAM Numerics Code			CHAR	76
NUMCODE05	SAM Numerics Code			CHAR	76
NUMCODE06	SAM Numerics Code			CHAR	76
NUMCODE07	SAM Numerics Code			CHAR	76
NUMCODE08	SAM Numerics Code			CHAR	76
NUMCODE09	SAM Numerics Code			CHAR	76
NUMCODE10	SAM Numerics Code			CHAR	76
NOPUBDISPLAY	No Public Display Flag			CHAR	8
DISRESPCNT	Disaster Response Counter			NUMC	8
.INCLUDE				FMSAPDISRESP	0
DISRESP01	Disaster Response Contractor Area			CHAR	20
DISRESP02	Disaster Response Contractor Area			CHAR	20
DISRESP03	Disaster Response Contractor Area			CHAR	20
DISRESP04	Disaster Response Contractor Area			CHAR	20
DISRESP05	Disaster Response Contractor Area			CHAR	20
DISRESP06	Disaster Response Contractor Area			CHAR	20
DISRESP07	Disaster Response Contractor Area			CHAR	20
DISRESP08	Disaster Response Contractor Area			CHAR	20
DISRESP09	Disaster Response Contractor Area			CHAR	20
DISRESP10	Disaster Response Contractor Area			CHAR	20
ANNUAL_IGT_REV	Intra-Government Transaction Revenue			NUMC	50
MERCHANTID1	Merchant Identification 1			CHAR	260
MERCHANTID2	Merchant Identification 2			CHAR	260
ACCNT_STATION	Accounting Station			CHAR	12
SOURCE	Federal Government Entity			CHAR	14
DEPARTMENT_CODE	Agency/Department Code			NUMC	4
HIER_DEP_CODE	Department ID for the Federal Government Entity			NUMC	8
HIER_DEP_NAME	Hierarchy Department Name			CHAR	300
HIER_AGCY_CODE	Hiaerarchy Agency Code			NUMC	8
HIER_AGCY_NAME	Hierarchy Agency Name			CHAR	300
HIER_OFFICE_CODE	Hierarchy Office Code			CHAR	12
TAXPAYERNAME	Taxpayer Name			CHAR	240
PARENTDUNS	Parent DUNS Number			CHAR	26
PARENTUEI	Parent Unique Entity ID Number			CHAR	32
ACH_US_PHONE	ACH US Phone (EFT)			CHAR	60
ACH_NUS_PHONE	ACH Non-US Phone (EFT)			CHAR	60
ACH_FAX	ACH Fax (EFT)			CHAR	60
ACH_EMAIL	ACH e-mail (EFT)			CHAR	160