Name |
Datatype |
Length |
Prcn |
PARTY_ID |
NUMBER
|
|
15 |
PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
PARTY_NAME |
VARCHAR2
|
(360)
|
|
PARTY_TYPE |
VARCHAR2
|
(30)
|
|
VALIDATED_FLAG |
VARCHAR2
|
(1)
|
|
LAST_UPDATED_BY |
NUMBER
|
|
15 |
CREATION_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
15 |
REQUEST_ID |
NUMBER
|
|
15 |
PROGRAM_APPLICATION_ID |
NUMBER
|
|
15 |
CREATED_BY |
NUMBER
|
|
15 |
LAST_UPDATE_DATE |
DATE
|
|
|
PROGRAM_ID |
NUMBER
|
|
15 |
PROGRAM_UPDATE_DATE |
DATE
|
|
|
WH_UPDATE_DATE |
DATE
|
|
|
ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE16 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE21 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE22 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE23 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE24 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE16 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE17 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE18 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE19 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE20 |
VARCHAR2
|
(150)
|
|
ORIG_SYSTEM_REFERENCE |
VARCHAR2
|
(240)
|
|
SIC_CODE |
VARCHAR2
|
(30)
|
|
HQ_BRANCH_IND |
VARCHAR2
|
(30)
|
|
CUSTOMER_KEY |
VARCHAR2
|
(500)
|
|
TAX_REFERENCE |
VARCHAR2
|
(50)
|
|
JGZZ_FISCAL_CODE |
VARCHAR2
|
(20)
|
|
DUNS_NUMBER |
NUMBER
|
|
|
TAX_NAME |
VARCHAR2
|
(60)
|
|
PERSON_PRE_NAME_ADJUNCT |
VARCHAR2
|
(30)
|
|
PERSON_FIRST_NAME |
VARCHAR2
|
(150)
|
|
PERSON_MIDDLE_NAME |
VARCHAR2
|
(60)
|
|
PERSON_LAST_NAME |
VARCHAR2
|
(150)
|
|
PERSON_NAME_SUFFIX |
VARCHAR2
|
(30)
|
|
PERSON_TITLE |
VARCHAR2
|
(60)
|
|
PERSON_ACADEMIC_TITLE |
VARCHAR2
|
(30)
|
|
PERSON_PREVIOUS_LAST_NAME |
VARCHAR2
|
(150)
|
|
KNOWN_AS |
VARCHAR2
|
(240)
|
|
PERSON_IDEN_TYPE |
VARCHAR2
|
(30)
|
|
PERSON_IDENTIFIER |
VARCHAR2
|
(60)
|
|
GROUP_TYPE |
VARCHAR2
|
(30)
|
|
COUNTRY |
VARCHAR2
|
(60)
|
|
ADDRESS1 |
VARCHAR2
|
(240)
|
|
ADDRESS2 |
VARCHAR2
|
(240)
|
|
ADDRESS3 |
VARCHAR2
|
(240)
|
|
ADDRESS4 |
VARCHAR2
|
(240)
|
|
CITY |
VARCHAR2
|
(60)
|
|
POSTAL_CODE |
VARCHAR2
|
(60)
|
|
STATE |
VARCHAR2
|
(60)
|
|
PROVINCE |
VARCHAR2
|
(60)
|
|
STATUS |
VARCHAR2
|
(1)
|
|
COUNTY |
VARCHAR2
|
(60)
|
|
SIC_CODE_TYPE |
VARCHAR2
|
(30)
|
|
TOTAL_NUM_OF_ORDERS |
NUMBER
|
|
|
TOTAL_ORDERED_AMOUNT |
NUMBER
|
|
|
LAST_ORDERED_DATE |
DATE
|
|
|
URL |
VARCHAR2
|
(2000)
|
|
EMAIL_ADDRESS |
VARCHAR2
|
(2000)
|
|
DO_NOT_MAIL_FLAG |
VARCHAR2
|
(1)
|
|
ANALYSIS_FY |
VARCHAR2
|
(5)
|
|
FISCAL_YEAREND_MONTH |
VARCHAR2
|
(30)
|
|
EMPLOYEES_TOTAL |
NUMBER
|
|
|
CURR_FY_POTENTIAL_REVENUE |
NUMBER
|
|
|
NEXT_FY_POTENTIAL_REVENUE |
NUMBER
|
|
|
YEAR_ESTABLISHED |
NUMBER
|
|
4 |
GSA_INDICATOR_FLAG |
VARCHAR2
|
(1)
|
|
MISSION_STATEMENT |
VARCHAR2
|
(2000)
|
|
ORGANIZATION_NAME_PHONETIC |
VARCHAR2
|
(320)
|
|
PERSON_FIRST_NAME_PHONETIC |
VARCHAR2
|
(60)
|
|
PERSON_LAST_NAME_PHONETIC |
VARCHAR2
|
(60)
|
|
LANGUAGE_NAME |
VARCHAR2
|
(4)
|
|
CATEGORY_CODE |
VARCHAR2
|
(30)
|
|
REFERENCE_USE_FLAG |
VARCHAR2
|
(1)
|
|
THIRD_PARTY_FLAG |
VARCHAR2
|
(1)
|
|
COMPETITOR_FLAG |
VARCHAR2
|
(1)
|
|
SALUTATION |
VARCHAR2
|
(60)
|
|
KNOWN_AS2 |
VARCHAR2
|
(240)
|
|
KNOWN_AS3 |
VARCHAR2
|
(240)
|
|
KNOWN_AS4 |
VARCHAR2
|
(240)
|
|
KNOWN_AS5 |
VARCHAR2
|
(240)
|
|
DUNS_NUMBER_C |
VARCHAR2
|
(30)
|
|
OBJECT_VERSION_NUMBER |
NUMBER
|
|
|
CREATED_BY_MODULE |
VARCHAR2
|
(150)
|
|
APPLICATION_ID |
NUMBER
|
|
|
PRIMARY_PHONE_CONTACT_PT_ID |
NUMBER
|
|
15 |
PRIMARY_PHONE_PURPOSE |
VARCHAR2
|
(30)
|
|
PRIMARY_PHONE_LINE_TYPE |
VARCHAR2
|
(30)
|
|
PRIMARY_PHONE_COUNTRY_CODE |
VARCHAR2
|
(10)
|
|
PRIMARY_PHONE_AREA_CODE |
VARCHAR2
|
(10)
|
|
PRIMARY_PHONE_NUMBER |
VARCHAR2
|
(40)
|
|
PRIMARY_PHONE_EXTENSION |
VARCHAR2
|
(20)
|
|
CERTIFICATION_LEVEL |
VARCHAR2
|
(30)
|
|
CERT_REASON_CODE |
VARCHAR2
|
(30)
|
|
PREFERRED_CONTACT_METHOD |
VARCHAR2
|
(30)
|
|
HOME_COUNTRY |
VARCHAR2
|
(2)
|
|
PERSON_BO_VERSION |
NUMBER
|
|
15 |
ORG_BO_VERSION |
NUMBER
|
|
15 |
PERSON_CUST_BO_VERSION |
NUMBER
|
|
15 |
ORG_CUST_BO_VERSION |
NUMBER
|
|
15 |