FMSAMVENDOR_HDR

PSM-FG: CCR Vendor Table (SAM UEI) | #transactional | Component: Functions for U.S. Federal Government
Column Name Description
MANDT Client
SAM_UE_ID System for Award Management Unique Entity Identifier
SAM_EFT_IND System for Award Management Electronic Funds Transfer Ind
Column Name Description
Column Name Description
Column Name Description
REGDATE Registration date
EXPDATE Registration Expiration Date
LASTUPDATE Last Update Date
ACTDATE SAM Activation Date
BUSSTART Business start date
AUTHDATE Authorization Date
EVSMLASTUPD SAM EVS Monitoring Last Update
XDATE Last CCR Extract Date
XTIME Last CCR Extract Time
Column Name Description
PUR_REG_CODE SAM Purpose of Registration Code Show values
REGSTAT Current Registration Status Show values
DBOPENDATAFLG D&B Open Data Flag Show values
SOURCE Federal Government Entity Show values
TAXIDTYPE Tax ID Type Show values
AGCY_BUS_PUR Agency Business Purpose Show values
ACCNTYP Account Type Show values
EFTWAIVER EFT Waiver Show values
EDI EDI (Y/N) Show values
EDIREC820 Receive 820 Show values
EVSMSTATUS SAM EVS Monitoring Status Show values
EVSOUTOFBUS SAM EVS Out of Business Indicator Show values
CORRFLAG Correspondence Flag Show values
DEBTOFFSET Debt Offset Flag Show values
EXCLSTATFLAG SAM Exclusion Status Flag Show values
Column Name Description Domain name
DUNS DUNS Number
CAGE CAGE Code
DODAAC Department of Defense Activity Address Code
BUSNAME Legal Business Name
DBANAME Doing Business As
DEPARTMENT_CODE Agency/Department Code
HIER_DEP_CODE Department ID for the Federal Government Entity
HIER_DEP_NAME null
HIER_AGCY_CODE Hiaerarchy Agency Code
HIER_AGCY_NAME null
HIER_OFFICE_CODE Hierarchy Office Code
TAXPAYERNAME PSM-FG:Taxpayer Name
TAXID CCR TaxID
URL Uniform Resource Locator
DIVNAME Division Name
DIVNUM Division Number
FISCEND Fiscal Year End Close Date (MMDD)
ENTSTRUCT SAM Entity Structure
STATEINC State of Incorporation
COUNTRYINC Country/Region of Incorporation
COSECLVL Company Security Level
EMSECLVL Highest Employee Security Level
PRIMARY_NAICS SAM Primary NAICS Code
REVENUE Revenue
EMPLNUM Number of employees
LOCREVENUE Location Revenue
LOCEMPLNUM Location Employee Number
FININST Financial Institution
ACCNTNO Account Number
ABAROUTE American Bankers Association Routing Number
LOCKBOX Lock Box
MERCHANTID1 SAM Merchant Identification 1 FMSAM_MERCH_ID
MERCHANTID2 SAM Merchant Identification 2 FMSAM_MERCH_ID
ACCNT_STATION SAM Accounting Station
EDIVAN Value Added Network
EDIISAQ ISA Qualifier
EDIISASQ ISA Sender Qualifier
EDIGS02 GS02 Identifier
CREDCARD Credit Card Usage
MPIN Marketing Partner Identification Number
ANNUAL_IGT_REV Intra-Government Transaction Revenue
XUSNAM User Name XUBNAME