FMCCRVENDOR_HDR

PSM-FG: CCR Vendor Table | #transactional | Component: Functions for U.S. Federal Government
Column Name Description
MANDT Client
DUNS DUNS Number
DUNS4 DUNS+4
Column Name Description
Column Name Description
Column Name Description
EXPDATE Registration Expiration Date
BUSSTART Business start date
XDATE Last CCR Extract Date
XTIME Last CCR Extract Time
AUTHDATE Authorization Date
DBUPDATE Last Update Date from Dun and Bradstreet
REGDATE Registration date
Column Name Description
REGSTAT Current Registration Status Show values
DELFEDDEBT Obsolete field (do not use) - Delinquent Federal Debt Show values
NOPUBDISPLAY Obsolete field (do not use) - No Public Display Flag Show values
ACCNTYP Account Type Show values
EDIREC820 Receive 820 Show values
DBBUSST Dun and Bradstreet Current Business Status Show values
Column Name Description Domain name
CAGE CAGE Code
BUSNAME Legal Business Name
DBANAME Doing Business As
TAXID CCR TaxID
SSN Social Security Number
DIVNAME Division Name
DIVNUM Division Number
URL Uniform Resource Locator
EMPLNUM Number of employees
LOCEMPLNUM Location Employee Number
FISCEND Fiscal Year End Close Date (MMDD)
REVENUE Revenue
LOCREVENUE Location Revenue
COSECLVL Company Security Level
EMSECLVL Highest Employee Security Level
ORGTYP Organization Type Code
XUSNAM User Name XUBNAME
MPIN Marketing Partner Identification Number
FININST Financial Institution
ABAROUTE American Bankers Association Routing Number
ACCNTNO Account Number
LOCKBOX Lock Box
EDIVAN Value Added Network
EDIISAQ ISA Qualifier
EDIISASQ ISA Sender Qualifier
EDIGS02 GS02 Identifier
DBBUSNAME D&B Monitoring: Legal Business Name
DBDBANAME D&B Monitoring: Doing Business As
DBMONST Dun and Bradstreet Monitoring Status
STATEINC State of Incorporation
COUNTRYINC Country/Region of Incorporation
SAM_UE_ID System for Award Management Unique Entity Identifier