PeopleSoft 9 Account Payables |
Table Name | CCR_VNDR_ADDR |
Table Description |
CCR_VNDR_ADDR |
Columns |
Name | Datatype | Is PK | Is FK |
DUNS_NUMBER | VARCHAR(9) | Yes | Yes |
CCR_DUNS_PLUS4 | VARCHAR(4) | Yes | Yes |
CCR_ADDR_TYPE | VARCHAR(3) | Yes | No |
OPERATIONNAME | VARCHAR(60) | No | No |
ADDRESS1 | VARCHAR(55) | No | No |
ADDRESS2 | VARCHAR(55) | No | No |
ADDRESS5 | VARCHAR(35) | No | No |
ADDRESS6 | VARCHAR(35) | No | No |
COUNTRY | VARCHAR(3) | No | No |
STATE | VARCHAR(6) | No | No |
CPARTY_PHONE_NBR | VARCHAR(30) | No | No |
EXT_REF_NBR | DECIMAL(10) | No | No |
PHONE_SUFFIX | VARCHAR(40) | No | No |
CPARTY_FAX_NBR | VARCHAR(30) | No | No |
EMAIL_TO | VARCHAR(254) | No | No |
CC_PARENT_DUNS | VARCHAR(13) | No | No |
Index |
Name | Type | Unique | Member |
PS_CCR_VNDR_ADDR | PK | Yes |
![]() |
Member(s) of "PS_CCR_VNDR_ADDR" Index |
DUNS_NUMBER |
CCR_DUNS_PLUS4 |
CCR_ADDR_TYPE |
Published June 06, 2007 |