CCR_VNDR_HDR

(SQL Table)
 Index Back

CCR Supplier Header Info

CCR Supplier Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
2 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix
3 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer

Default Value: CCR

4 CCR_CAGE_CD Character(5) VARCHAR2(5) NOT NULL CCR CAGE Code
5 CCR_EXTRACT_CD Character(1) VARCHAR2(1) NOT NULL CCR Extract Code
6 REGISTRATION_DT Date(10) DATE Registration Date
7 RENEWAL_DATE Date(10) DATE Renewal Date
8 LEGAL_BUS_NAME Character(120) VARCHAR2(120) NOT NULL Legal Business Name
9 FULLNAME Character(60) VARCHAR2(60) NOT NULL Full name
10 PARENT_DUNS Character(9) VARCHAR2(9) NOT NULL Parent DUNS
11 CC_PARENT_NAME Character(120) VARCHAR2(120) NOT NULL Parent Name
12 CC_HQ_DUNS Character(9) VARCHAR2(9) NOT NULL Headquarters DUNS
13 CC_HQ_NAME Character(120) VARCHAR2(120) NOT NULL Headquarters Name
14 CC_AGENCY_DUNS Character(120) VARCHAR2(120) NOT NULL Agency Duns Number
15 CC_AGENCY_NAME Character(120) VARCHAR2(120) NOT NULL Agency Name
16 CC_HIERARCHY Character(2) VARCHAR2(2) NOT NULL Hierarchy Code
17 CC_STATUS_CODE Character(1) VARCHAR2(1) NOT NULL Registry Status Code
0=Single Location
1=Headquarters/Parent
2=Branch
4=Division
18 CC_SUBSIDARY Character(1) VARCHAR2(1) NOT NULL Subsidiary Indicator
0=Not A Subsidiary
3=Subsidiary
19 CC_TREASURY_INDEX Character(2) VARCHAR2(2) NOT NULL Treasury Index
20 OPERATIONNAME Character(60) VARCHAR2(60) NOT NULL Operation
21 DIVISION_AREA_CD Character(10) VARCHAR2(10) NOT NULL Division/Area Code
22 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
23 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
24 ADDRESS5 Character(35) VARCHAR2(35) NOT NULL ADDRESS5
25 STATE Character(6) VARCHAR2(6) NOT NULL State
26 ADDRESS6 Character(35) VARCHAR2(35) NOT NULL ADDRESS6
27 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
28 START_DT Date(10) DATE Start Date
29 TRANS_FY Number(4,0) SMALLINT NOT NULL TRANS FISCAL YEAR
30 CCR_SECURITY_LEVEL Character(15) VARCHAR2(15) NOT NULL Security Level
31 CCR_EMPL_SEC_LVL Character(15) VARCHAR2(15) NOT NULL Employee Security Level
32 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
33 CCR_ORG_TYPE Character(2) VARCHAR2(2) NOT NULL CCR Organization Type
34 STATE_OF_INCORP Character(2) VARCHAR2(2) NOT NULL State of Incorporation
35 COUNTRY_OF_INC Character(3) VARCHAR2(3) NOT NULL Country of Incorporation
36 CCR_BUS_TYPE Character(2) VARCHAR2(2) NOT NULL CCR Business Type
37 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code
38 NAICS_CODE Character(6) VARCHAR2(6) NOT NULL North American Industrial Classification System
39 CCR_FSC_CODE Character(4) VARCHAR2(4) NOT NULL Federal Supply Class
40 CCR_PSC_CODE Character(40) VARCHAR2(40) NOT NULL Product Service Code
41 CREDIT_CARD_SELECT Character(1) VARCHAR2(1) NOT NULL Credit Card Selection
42 CCR_CORRESP_FLG Character(1) VARCHAR2(1) NOT NULL CCR Correspondence
43 EDI_OPTION Character(1) VARCHAR2(1) NOT NULL EDI Invoice Options
1=EDI Only
2=EDI and Print
3=Print Only
44 EIN_NUMBER Character(9) VARCHAR2(9) NOT NULL Exporter's EIN Number
45 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
46 DISBURSING_OFFICE Character(5) VARCHAR2(5) NOT NULL Field used by Payables
47 FR_BUS_TYPE Character(1) VARCHAR2(1) NOT NULL Business Type
0=To be Selected
1=Seller
2=Buyer
3=Buyer and Seller
48 CCR_MERCHANTID1 Character(120) VARCHAR2(120) NOT NULL Merchant ID1
49 CCR_MERCHANTID2 Character(120) VARCHAR2(120) NOT NULL Merchant ID2
50 FEDREG_STATUS Character(1) VARCHAR2(1) NOT NULL Registration Status
0=Pending
1=Registered
2=Reference Only
51 LAST_UPDATE_DATE Date(10) DATE Date of last update
52 DB_DATE_OF_DATA Date(10) DATE Date of Data
53 EXPIRATION_DATE Date(10) DATE Expiration Date
54 EOTP_EMPLCOUNT Number(15,0) DECIMAL(15) NOT NULL Employee Count
55 ANNUAL_REVENUE Number(27,3) DECIMAL(26,3) NOT NULL Annual Revenue
56 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
57 BANK_NAME Character(30) VARCHAR2(30) NOT NULL Bank Name
58 BANK_CD_TEXT Character(20) VARCHAR2(20) NOT NULL Dynamic text label for field.
59 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
60 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
61 LOCKBOX_NBR Character(20) VARCHAR2(20) NOT NULL LockBox Number
62 AUTHORIZATION_DT Date(10) DATE Date Authorized
63 EFT_WAIVER Character(1) VARCHAR2(1) NOT NULL EFT Waiver
F=Foriegn
N=No
Y=Yes
64 EMAIL_TO Character(254) VARCHAR2(254) NOT NULL EMAIL_TO
65 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
66 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
67 AP_COMPLETE Character(1) VARCHAR2(1) NOT NULL AP Processing Flag
68 OM_COMPLETE Character(1) VARCHAR2(1) NOT NULL OM Processing Flag