FMSAMVENDOR_HDR - PSM-FG: CCR Vendor Table (SAM UEI)

PSM-FG: CCR Vendor Table (SAM UEI) information is stored in SAP table FMSAMVENDOR_HDR.
It is part of development package FMFG_CCR_VP_E in software component PSM-FG. This development package consists of objects that can be grouped under "Value Pack Us federal - Interface to CCR".

Fields for table FMSAMVENDOR_HDR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
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
.INCLUDE				IFMSAMENTITYREGISTR	0
DUNS	DUNS Number		FMCCRDUNS	CHAR	18
CAGE	CAGE Code		FMCCRCAGE	CHAR	10
DODAAC	Department of Defense Activity Address Code		FMSAMDODAAC	CHAR	18
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
DBOPENDATAFLG	D&B Open Data Flag		FMSAM_DBOPDATAFLG	CHAR	2
.INCLUDE				IFMSAMFEDHIERARCHY	0
SOURCE	Federal Government Entity		FMSAM_SOURCE	CHAR	14
DEPARTMENT_CODE	Agency/Department Code		FMSAM_DEPT_CODE	NUMC	4
HIER_DEP_CODE	Department ID for the Federal Government Entity		FMSAM_HIER_DEPT_CODE	NUMC	8
HIER_DEP_NAME	Hierarchy Department Name			CHAR	300
HIER_AGCY_CODE	Hiaerarchy Agency Code		FMSAM_HIER_AGCY_CODE	NUMC	8
HIER_AGCY_NAME	Hierarchy Agency Name			CHAR	300
HIER_OFFICE_CODE	Hierarchy Office Code		FMSAM_HIER_OFFICE_CODE	CHAR	12
.INCLUDE				IFMSAMTININFO	0
TAXPAYERNAME	PSM-FG:Taxpayer Name		FMSAM_TAXPAYER_NAME	CHAR	240
TAXIDTYPE	Tax ID Type		FMSAM_TAXID_TYP	CHAR	2
TAXID	CCR TaxID		FMCCRTAXID	NUMC	18
.INCLUDE				IFMSAMENTINFO	0
URL	Uniform Resource Locator		FMCCR_URL	CHAR	400
DIVNAME	Division Name		FMCCR_DIVNAME	CHAR	120
DIVNUM	Division Number		FMCCR_DIVNUM	CHAR	20
BUSSTART	Business start date		FMCCR_BUSSTART	DATS	16
FISCEND	Fiscal Year End Close Date (MMDD)		FMCCR_FISCEND	CHAR	8
.INCLUDE				IFMSAMGENINFO	0
AGCY_BUS_PUR	Agency Business Purpose		FMSAM_AGCY_BUS_PUR	CHAR	2
ENTSTRUCT	SAM Entity Structure		FMSAM_ENT_STRUCT	CHAR	4
STATEINC	State of Incorporation		FMCCR_STATEINC	CHAR	4
COUNTRYINC	Country/Region of Incorporation		FMCCR_COUNTRYINC	CHAR	6
COSECLVL	Company Security Level		FMCCR_COSECLVL	NUMC	4
EMSECLVL	Highest Employee Security Level		FMCCR_EMSECLVL	NUMC	4
PRIMARY_NAICS	SAM Primary NAICS Code		FMSAM_PRIMARY_NAICS	CHAR	12
REVENUE	Revenue		FMSAM_REVENUE	NUMC	50
EMPLNUM	Number of employees		FMSAM_EMPLNUM	NUMC	50
LOCREVENUE	Location Revenue		FMSAM_LOCREVENUE	NUMC	50
LOCEMPLNUM	Location Employee Number		FMSAM_LOCEMPLNUM	NUMC	50
.INCLUDE				IFMSAMEFT	0
FININST	Financial Institution		FMSAM_FININST	CHAR	100
ACCNTNO	Account Number		FMCCR_ACCNTNO	CHAR	60
ABAROUTE	American Bankers Association Routing Number		FMSAM_ABAROUTE	NUMC	100
ACCNTYP	Account Type		FMCCR_ACCNTYP	CHAR	2
LOCKBOX	Lock Box		FMCCR_LOCKBOX	CHAR	40
AUTHDATE	Authorization Date		FMCCR_AUTHDATE	DATS	16
EFTWAIVER	EFT Waiver		FMSAM_EFT_WAIVER	CHAR	2
MERCHANTID1	SAM Merchant Identification 1		FMSAM_MERCH_ID1	CHAR	260
MERCHANTID2	SAM Merchant Identification 2		FMSAM_MERCH_ID2	CHAR	260
ACCNT_STATION	SAM Accounting Station		FMSAM_ACCNT_STATION	CHAR	12
.INCLUDE				IFMSAMEDIEVS	0
EDI	EDI (Y/N)		FMSAM_EDI	CHAR	2
EDIVAN	Value Added Network		FMSAM_EDIVAN	CHAR	40
EDIISAQ	ISA Qualifier		FMCCR_ISAQ	CHAR	4
EDIISASQ	ISA Sender Qualifier		FMCCR_ISASQ	CHAR	30
EDIGS02	GS02 Identifier		FMCCR_EDIGS02	CHAR	30
EDIREC820	Receive 820		FMCCR_EDIREC820	CHAR	2
EVSMLASTUPD	SAM EVS Monitoring Last Update		FMSAM_EVSM_LAST_UPD	DATS	16
EVSMSTATUS	SAM EVS Monitoring Status		FMSAM_EVSM_STATUS	CHAR	2
EVSOUTOFBUS	SAM EVS Out of Business Indicator		FMSAM_EVS_OUT_OF_BUS	CHAR	2
.INCLUDE				IFMSAMSENSINFO	0
CREDCARD	Credit Card Usage		FMSAM_CREDCARD	CHAR	2
CORRFLAG	Correspondence Flag		FMSAM_CORRFLAG	CHAR	2
MPIN	Marketing Partner Identification Number		FMCCR_MPIN	CHAR	18
DEBTOFFSET	Debt Offset Flag		FMSAMDEBTOFFSET	CHAR	2
EXCLSTATFLAG	SAM Exclusion Status Flag		FMSAM_EXCL_STATUS_FLAG	CHAR	2
ANNUAL_IGT_REV	Intra-Government Transaction Revenue		FMSAM_ANNUAL_IGT_REV	NUMC	50
.INCLUDE				IFMSAMADDINFO	0
XUSNAM	User Name		USNAM	CHAR	24	*
XDATE	Last CCR Extract Date		FMCCR_UPDATE	DATS	16
XTIME	Last CCR Extract Time		FMCCR_UPTIME	TIMS	12