DBA Data[Home] [Help] [Dependency Information]


TYPE: APPS.POS_AP_SUPPLIER_BO

Object Details
Object Name: POS_AP_SUPPLIER_BO
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
VENDOR_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

VENDOR_NAME VARCHAR2 (240)
VENDOR_NAME_ALT VARCHAR2 (320)
SEGMENT1 VARCHAR2 (30)
SUMMARY_FLAG VARCHAR2 (1)
ENABLED_FLAG VARCHAR2 (1)
SEGMENT2 VARCHAR2 (30)
SEGMENT3 VARCHAR2 (30)
SEGMENT4 VARCHAR2 (30)
SEGMENT5 VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

EMPLOYEE_ID NUMBER

VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
CUSTOMER_NUM VARCHAR2 (25)
ONE_TIME_FLAG VARCHAR2 (1)
PARENT_VENDOR_ID NUMBER

MIN_ORDER_AMOUNT NUMBER

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)
TERMS_ID NUMBER

SET_OF_BOOKS_ID NUMBER

CREDIT_STATUS_LOOKUP_CODE VARCHAR2 (25)
CREDIT_LIMIT NUMBER

ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
PAYMENT_PRIORITY NUMBER

INVOICE_CURRENCY_CODE VARCHAR2 (15)
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
INVOICE_AMOUNT_LIMIT NUMBER

EXCHANGE_DATE_LOOKUP_CODE VARCHAR2 (25)
HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)
HOLD_REASON VARCHAR2 (240)
DISTRIBUTION_SET_ID NUMBER

ACCTS_PAY_CODE_COMBINATION_ID NUMBER

DISC_LOST_CODE_COMBINATION_ID NUMBER

DISC_TAKEN_CODE_COMBINATION_ID NUMBER

EXPENSE_CODE_COMBINATION_ID NUMBER

PREPAY_CODE_COMBINATION_ID NUMBER

NUM_1099 VARCHAR2 (30)
TYPE_1099 VARCHAR2 (10)
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2 (25)
WITHHOLDING_START_DATE DATE

ORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2 (25)
VAT_CODE VARCHAR2 (30)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

MINORITY_GROUP_LOOKUP_CODE VARCHAR2 (25)
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)
WOMEN_OWNED_FLAG VARCHAR2 (1)
SMALL_BUSINESS_FLAG VARCHAR2 (1)
STANDARD_INDUSTRY_CLASS VARCHAR2 (25)
HOLD_FLAG VARCHAR2 (1)
PURCHASING_HOLD_REASON VARCHAR2 (240)
HOLD_BY NUMBER
9
HOLD_DATE DATE

TERMS_DATE_BASIS VARCHAR2 (25)
PRICE_TOLERANCE NUMBER

INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
QTY_RCV_TOLERANCE NUMBER

QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

DAYS_LATE_RECEIPT_ALLOWED NUMBER

RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
RECEIVING_ROUTING_ID NUMBER

ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 (1)
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
EXCLUSIVE_PAYMENT_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)
TAX_VERIFICATION_DATE DATE

NAME_CONTROL VARCHAR2 (4)
STATE_REPORTABLE_FLAG VARCHAR2 (1)
FEDERAL_REPORTABLE_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

OFFSET_VAT_CODE VARCHAR2 (20)
VAT_REGISTRATION_NUM VARCHAR2 (20)
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 (1)
VALIDATION_NUMBER NUMBER

EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
TAX_REPORTING_NAME VARCHAR2 (80)
CHECK_DIGITS VARCHAR2 (30)
BANK_NUMBER 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_PAYMENT_METHOD VARCHAR2 (25)
EDI_PAYMENT_FORMAT VARCHAR2 (25)
EDI_REMITTANCE_METHOD VARCHAR2 (25)
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
BANK_CHARGE_BEARER VARCHAR2 (1)
BANK_BRANCH_TYPE VARCHAR2 (25)
MATCH_OPTION VARCHAR2 (25)
FUTURE_DATED_PAYMENT_CCID NUMBER
15
CREATE_DEBIT_MEMO_FLAG VARCHAR2 (25)
OFFSET_TAX_FLAG VARCHAR2 (1)
PARTY_ID NUMBER

PARENT_PARTY_ID NUMBER

TCA_SYNC_NUM_1099 VARCHAR2 (30)
TCA_SYNC_VENDOR_NAME VARCHAR2 (360)
TCA_SYNC_VAT_REG_NUM VARCHAR2 (50)
INDIVIDUAL_1099 VARCHAR2 (30)
UNIQUE_TAX_REFERENCE_NUM NUMBER
15
PARTNERSHIP_UTR NUMBER
15
PARTNERSHIP_NAME VARCHAR2 (240)
CIS_ENABLED_FLAG VARCHAR2 (1)
FIRST_NAME VARCHAR2 (240)
SECOND_NAME VARCHAR2 (240)
LAST_NAME VARCHAR2 (240)
SALUTATION VARCHAR2 (30)
TRADING_NAME VARCHAR2 (240)
WORK_REFERENCE VARCHAR2 (30)
COMPANY_REGISTRATION_NUMBER VARCHAR2 (30)
NATIONAL_INSURANCE_NUMBER VARCHAR2 (30)
VERIFICATION_NUMBER VARCHAR2 (30)
VERIFICATION_REQUEST_ID NUMBER
15
MATCH_STATUS_FLAG VARCHAR2 (1)
CIS_VERIFICATION_DATE DATE

PAY_AWT_GROUP_ID NUMBER
15
CIS_PARENT_VENDOR_ID NUMBER

P_POS_EXTERNAL_PAYEE_BO TYPEPOS_EXTERNAL_PAYEE_BO

P_POS_SUPP_UDA_OBJ_TBL TYPEPOS_SUPP_UDA_OBJ_TBL

Dependencies

[top of page]

APPS.POS_AP_SUPPLIER_BO references the following:

SchemaAPPS
TYPEPOS_EXTERNAL_PAYEE_BO
TYPEPOS_SUPP_UDA_OBJ_TBL
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.POS_AP_SUPPLIER_BO is referenced by following:

SchemaAPPS
PL/SQL PackagePOS_AP_SUPPLIER_BO_PKG - show dependent code
Package BodyPOS_AP_SUPPLIER_BO_PKG - show dependent code
TYPEPOS_SUPPLIER_BO
Package BodyPOS_SUPPLIER_BO_PKG - show dependent code