PeopleSoft 9 Account Payables |
Table Name | CCR_VNDR_HDR |
Table Description |
CCR_VNDR_HDR |
Columns |
Name | Datatype | Is PK | Is FK |
DUNS_NUMBER | VARCHAR(9) | Yes | No |
CCR_DUNS_PLUS4 | VARCHAR(4) | Yes | No |
CCR_CAGE_CD | VARCHAR(5) | No | No |
CCR_EXTRACT_CD | VARCHAR(1) | No | No |
REGISTRATION_DT | datetime | No | No |
RENEWAL_DATE | datetime | No | No |
LEGAL_BUS_NAME | VARCHAR(120) | No | No |
FULLNAME | VARCHAR(60) | No | No |
OPERATIONNAME | VARCHAR(60) | No | No |
DIVISION_AREA_CD | VARCHAR(10) | No | No |
ADDRESS1 | VARCHAR(55) | No | No |
ADDRESS2 | VARCHAR(55) | No | No |
ADDRESS5 | VARCHAR(35) | No | No |
STATE | VARCHAR(6) | No | No |
ADDRESS6 | VARCHAR(35) | No | No |
COUNTRY | VARCHAR(3) | No | No |
START_DT | datetime | No | No |
TRANS_FY | SMALLINT | No | No |
CCR_SECURITY_LEVEL | VARCHAR(15) | No | No |
CCR_EMPL_SEC_LVL | VARCHAR(15) | No | No |
URL | VARCHAR(254) | No | No |
CCR_ORG_TYPE | VARCHAR(2) | No | No |
STATE_OF_INCORP | VARCHAR(2) | No | No |
COUNTRY_OF_INC | VARCHAR(3) | No | No |
CCR_BUS_TYPE | VARCHAR(2) | No | No |
SIC_CODE | VARCHAR(10) | No | No |
NAICS_CODE | VARCHAR(6) | No | No |
CCR_FSC_CODE | VARCHAR(4) | No | No |
CCR_PSC_CODE | VARCHAR(40) | No | No |
CREDIT_CARD_SELECT | VARCHAR(1) | No | No |
CCR_CORRESP_FLG | VARCHAR(1) | No | No |
EDI_OPTION | VARCHAR(1) | No | No |
EIN_NUMBER | VARCHAR(9) | No | No |
EOTP_EMPLCOUNT | DECIMAL(15) | No | No |
ANNUAL_REVENUE | DECIMAL(14,2) | No | No |
SSN | VARCHAR(9) | No | No |
BANK_NAME | VARCHAR(30) | No | No |
BANK_CD_TEXT | VARCHAR(20) | No | No |
DFI_ID_NUM | VARCHAR(12) | No | No |
BANK_ACCT_TYPE | VARCHAR(2) | No | No |
LOCKBOX_NBR | VARCHAR(20) | No | No |
AUTHORIZATION_DT | datetime | No | No |
EFT_WAIVER | VARCHAR(1) | No | No |
EMAIL_TO | VARCHAR(254) | No | No |
PROCESS_INSTANCE | DECIMAL(10) | No | No |
FILE_PATH_NAME | VARCHAR(254) | No | No |
Index |
Name | Type | Unique | Member |
PS_CCR_VNDR_HDR | PK | Yes |
![]() |
PS0CCR_VNDR_HDR | IE1 | No |
![]() |
PS1CCR_VNDR_HDR | IE2 | No |
![]() |
PS2CCR_VNDR_HDR | IE3 | No |
![]() |
PS3CCR_VNDR_HDR | IE4 | No |
![]() |
Member(s) of "PS_CCR_VNDR_HDR" Index |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
Member(s) of "PS0CCR_VNDR_HDR" Index |
LEGAL_BUS_NAME |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
Member(s) of "PS1CCR_VNDR_HDR" Index |
FULLNAME |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
Member(s) of "PS2CCR_VNDR_HDR" Index |
EIN_NUMBER |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
Member(s) of "PS3CCR_VNDR_HDR" Index |
SSN |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
Published June 06, 2007 |