Name |
Datatype |
Length |
Prcn |
VENDOR_SITE_ID |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
VENDOR_ID |
NUMBER
|
|
|
VENDOR_SITE_CODE |
VARCHAR2
|
(15)
|
|
VENDOR_SITE_CODE_ALT |
VARCHAR2
|
(320)
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
CREATED_BY |
NUMBER
|
|
|
PURCHASING_SITE_FLAG |
VARCHAR2
|
(1)
|
|
RFQ_ONLY_SITE_FLAG |
VARCHAR2
|
(1)
|
|
PAY_SITE_FLAG |
VARCHAR2
|
(1)
|
|
ATTENTION_AR_FLAG |
VARCHAR2
|
(1)
|
|
ADDRESS_LINE1 |
VARCHAR2
|
(240)
|
|
ADDRESS_LINES_ALT |
VARCHAR2
|
(560)
|
|
ADDRESS_LINE2 |
VARCHAR2
|
(240)
|
|
ADDRESS_LINE3 |
VARCHAR2
|
(240)
|
|
CITY |
VARCHAR2
|
(60)
|
|
STATE |
VARCHAR2
|
(150)
|
|
ZIP |
VARCHAR2
|
(60)
|
|
PROVINCE |
VARCHAR2
|
(150)
|
|
COUNTRY |
VARCHAR2
|
(60)
|
|
AREA_CODE |
VARCHAR2
|
(10)
|
|
PHONE |
VARCHAR2
|
(15)
|
|
CUSTOMER_NUM |
VARCHAR2
|
(25)
|
|
SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
BILL_TO_LOCATION_ID |
NUMBER
|
|
|
SHIP_VIA_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
FREIGHT_TERMS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
FOB_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
INACTIVE_DATE |
DATE
|
|
|
FAX |
VARCHAR2
|
(15)
|
|
FAX_AREA_CODE |
VARCHAR2
|
(10)
|
|
TELEX |
VARCHAR2
|
(15)
|
|
PAYMENT_METHOD_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
BANK_ACCOUNT_NAME |
VARCHAR2
|
(80)
|
|
BANK_ACCOUNT_NUM |
VARCHAR2
|
(30)
|
|
BANK_NUM |
VARCHAR2
|
(25)
|
|
BANK_ACCOUNT_TYPE |
VARCHAR2
|
(25)
|
|
TERMS_DATE_BASIS |
VARCHAR2
|
(25)
|
|
CURRENT_CATALOG_NUM |
VARCHAR2
|
(20)
|
|
VAT_CODE |
VARCHAR2
|
(30)
|
|
DISTRIBUTION_SET_ID |
NUMBER
|
|
|
ACCTS_PAY_CODE_COMBINATION_ID |
NUMBER
|
|
|
PREPAY_CODE_COMBINATION_ID |
NUMBER
|
|
|
PAY_GROUP_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
PAYMENT_PRIORITY |
NUMBER
|
|
|
TERMS_ID |
NUMBER
|
|
|
INVOICE_AMOUNT_LIMIT |
NUMBER
|
|
|
PAY_DATE_BASIS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
ALWAYS_TAKE_DISC_FLAG |
VARCHAR2
|
(1)
|
|
INVOICE_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
PAYMENT_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
HOLD_ALL_PAYMENTS_FLAG |
VARCHAR2
|
(1)
|
|
HOLD_FUTURE_PAYMENTS_FLAG |
VARCHAR2
|
(1)
|
|
HOLD_REASON |
VARCHAR2
|
(240)
|
|
HOLD_UNMATCHED_INVOICES_FLAG |
VARCHAR2
|
(1)
|
|
AP_TAX_ROUNDING_RULE |
VARCHAR2
|
(1)
|
|
AUTO_TAX_CALC_FLAG |
VARCHAR2
|
(1)
|
|
AUTO_TAX_CALC_OVERRIDE |
VARCHAR2
|
(1)
|
|
AMOUNT_INCLUDES_TAX_FLAG |
VARCHAR2
|
(1)
|
|
EXCLUSIVE_PAYMENT_FLAG |
VARCHAR2
|
(1)
|
|
TAX_REPORTING_SITE_FLAG |
VARCHAR2
|
(1)
|
|
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)
|
|
REQUEST_ID |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
VALIDATION_NUMBER |
NUMBER
|
|
|
EXCLUDE_FREIGHT_FROM_DISCOUNT |
VARCHAR2
|
(1)
|
|
VAT_REGISTRATION_NUM |
VARCHAR2
|
(20)
|
|
OFFSET_VAT_CODE |
VARCHAR2
|
(20)
|
|
ORG_ID |
NUMBER
|
|
|
CHECK_DIGITS |
VARCHAR2
|
(30)
|
|
BANK_NUMBER |
VARCHAR2
|
(30)
|
|
ADDRESS_LINE4 |
VARCHAR2
|
(240)
|
|
COUNTY |
VARCHAR2
|
(150)
|
|
ADDRESS_STYLE |
VARCHAR2
|
(30)
|
|
LANGUAGE |
VARCHAR2
|
(30)
|
|
ALLOW_AWT_FLAG |
VARCHAR2
|
(1)
|
|
AWT_GROUP_ID |
NUMBER
|
|
15 |
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE4 |
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)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
EDI_TRANSACTION_HANDLING |
VARCHAR2
|
(25)
|
|
EDI_ID_NUMBER |
VARCHAR2
|
(30)
|
|
EDI_PAYMENT_METHOD |
VARCHAR2
|
(25)
|
|
EDI_PAYMENT_FORMAT |
VARCHAR2
|
(25)
|
|
EDI_REMITTANCE_METHOD |
VARCHAR2
|
(25)
|
|
BANK_CHARGE_BEARER |
VARCHAR2
|
(1)
|
|
EDI_REMITTANCE_INSTRUCTION |
VARCHAR2
|
(256)
|
|
BANK_BRANCH_TYPE |
VARCHAR2
|
(25)
|
|
PAY_ON_CODE |
VARCHAR2
|
(25)
|
|
DEFAULT_PAY_SITE_ID |
NUMBER
|
|
15 |
PAY_ON_RECEIPT_SUMMARY_CODE |
VARCHAR2
|
(25)
|
|
TP_HEADER_ID |
NUMBER
|
|
|
ECE_TP_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
PCARD_SITE_FLAG |
VARCHAR2
|
(1)
|
|
MATCH_OPTION |
VARCHAR2
|
(25)
|
|
COUNTRY_OF_ORIGIN_CODE |
VARCHAR2
|
(2)
|
|
FUTURE_DATED_PAYMENT_CCID |
NUMBER
|
|
15 |
CREATE_DEBIT_MEMO_FLAG |
VARCHAR2
|
(25)
|
|
OFFSET_TAX_FLAG |
VARCHAR2
|
(1)
|
|
SUPPLIER_NOTIF_METHOD |
VARCHAR2
|
(25)
|
|
EMAIL_ADDRESS |
VARCHAR2
|
(2000)
|
|
REMITTANCE_EMAIL |
VARCHAR2
|
(2000)
|
|
PRIMARY_PAY_SITE_FLAG |
VARCHAR2
|
(1)
|
|
SHIPPING_CONTROL |
VARCHAR2
|
(30)
|
|
SELLING_COMPANY_IDENTIFIER |
VARCHAR2
|
(10)
|
|
GAPLESS_INV_NUM_FLAG |
VARCHAR2
|
(1)
|
|
DUNS_NUMBER |
VARCHAR2
|
(30)
|
|
TOLERANCE_ID |
NUMBER
|
|
15 |
LOCATION_ID |
NUMBER
|
|
15 |
PARTY_SITE_ID |
NUMBER
|
|
15 |
PARTY_SITE_ORIG_SYSTEM |
VARCHAR2
|
(30)
|
|
PARTY_SITE_ORIG_SYS_REF |
VARCHAR2
|
(255)
|
|
SERVICES_TOLERANCE_ID |
NUMBER
|
|
15 |
RETAINAGE_RATE |
NUMBER
|
|
|
TCA_SYNC_STATE |
VARCHAR2
|
(150)
|
|
TCA_SYNC_PROVINCE |
VARCHAR2
|
(150)
|
|
TCA_SYNC_COUNTY |
VARCHAR2
|
(150)
|
|
TCA_SYNC_CITY |
VARCHAR2
|
(60)
|
|
TCA_SYNC_ZIP |
VARCHAR2
|
(60)
|
|
TCA_SYNC_COUNTRY |
VARCHAR2
|
(60)
|
|
PAY_AWT_GROUP_ID |
NUMBER
|
|
15 |
AWT_GROUP_NAME |
VARCHAR2
|
(25)
|
|
DEFAULT_BILL_TO_LOC_ID |
NUMBER
|
|
|
DEFAULT_DIST_SET_ID |
NUMBER
|
|
|
DEFAULT_SHIP_TO_LOC_ID |
NUMBER
|
|
|
DEFAULT_TERMS_ID |
NUMBER
|
|
|
SHIPPING_LOCATION_ID |
NUMBER
|
|
|
VENDOR_INTERFACE_ID |
NUMBER
|
|
|
VENDOR_SITE_INTERFACE_ID |
NUMBER
|
|
|
PAY_AWT_GROUP_NAME |
VARCHAR2
|
(25)
|
|
SHIP_TO_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
BILL_TO_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
DISTRIBUTION_SET_NAME |
VARCHAR2
|
(50)
|
|
ORG_NAME |
VARCHAR2
|
(240)
|
|
PARTY_SITE_NAME |
VARCHAR2
|
(240)
|
|
SERVICES_TOLERANCE_NAME |
VARCHAR2
|
(255)
|
|
TERMS_NAME |
VARCHAR2
|
(50)
|
|
TOLERANCE_NAME |
VARCHAR2
|
(255)
|
|
P_POS_EXTERNAL_PAYEE_BO |
POS_EXTERNAL_PAYEE_BO
|
|
|
P_POS_SUPP_UDA_OBJ_TBL |
POS_SUPP_UDA_OBJ_TBL
|
|
|