| 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
|
|
|
[Home] [Help]
[Dependency Information]
APPS
STANDARD
- show dependent code
POS_AP_SUPPLIER_SITE_BO_PKG
- show dependent code