[Home] [Help] [Dependency Information]
Object Name: | OKL_PARTY_ROLES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NUMBER_OLD | VARCHAR2 | (30) | Yes | |
LINE_NUMBER | NUMBER | |||
ASSET_VENDOR_NAME | VARCHAR2 | (240) | ||
ASSET_VENDOR_ID | NUMBER | |||
SERVICE_VENDOR_NAME | VARCHAR2 | (240) | ||
SERVICE_VENDOR_ID | NUMBER | |||
FEES_VENDOR_NAME | VARCHAR2 | (240) | ||
FEES_VENDOR_ID | NUMBER | |||
GUARANTOR_NUMBER | VARCHAR2 | (30) | ||
GUARANTOR_ID | NUMBER | |||
GUARANTOR_SITE_NUMBER | VARCHAR2 | (30) | ||
GUARANTOR_SITE_ID | NUMBER | |||
DEALER_NAME | VARCHAR2 | (80) | ||
DEALER_ID | NUMBER | |||
GUARANTOR_TYPE | VARCHAR2 | (30) | ||
GUARANTEE_TYPE | VARCHAR2 | (30) | ||
GUARANTEED_AMOUNT | NUMBER | |||
GUARANTEE_DATE | DATE | |||
GUARANTEE_COMMENT | VARCHAR2 | (50) | ||
BILLABLE_VENDOR_ID | NUMBER | |||
BILLABLE_VENDOR_NAME | VARCHAR2 | (240) | ||
VEND_AS_CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
VEND_AS_CUSTOMER_ID | NUMBER | |||
VEND_AS_CUSTOMER_ACC_NUMBER | VARCHAR2 | (30) | ||
VEND_AS_CUSTOMER_ACC_ID | NUMBER | |||
VEND_BILL_TO_ADDR_ID | NUMBER | |||
VEND_BILL_TO_ADDR | VARCHAR2 | (240) | ||
VEND_PAYMENT_METHOD_ID | NUMBER | |||
VEND_PAYMENT_METHOD | VARCHAR2 | (30) | ||
VEND_BANK_ACC_ID | NUMBER | |||
VEND_BANK_ACC_NUMBER | VARCHAR2 | (30) | ||
VEND_INVOICE_FORMAT_ID | NUMBER | |||
VEND_INVOICE_FORMAT_CODE | VARCHAR2 | (150) | ||
VEND_REVIEW_INVOICE_FLAG | VARCHAR2 | (3) | ||
VEND_REASON_FOR_INV_REVIEW | VARCHAR2 | (50) | ||
VEND_INV_REVIEW_UNTIL_DATE | DATE | |||
PTH_BASE_VENDOR_SITE_CODE | VARCHAR2 | (150) | ||
PTH_BASE_VENDOR_SITE_CODE_1 | VARCHAR2 | (150) | ||
PTH_BASE_VENDOR_SITE_ID | NUMBER | |||
PTH_BASE_PAYGROUP_CODE | VARCHAR2 | (30) | ||
PTH_BASE_PMNT_TERM_CODE | VARCHAR2 | (50) | ||
PTH_BASE_PMNT_TERM_ID | NUMBER | |||
PTH_BASE_PMNT_BASIS | VARCHAR2 | (15) | ||
PTH_BASE_PMNT_START_DATE | DATE | |||
PTH_BASE_PMNT_METHOD_CODE | VARCHAR2 | (30) | ||
PTH_BASE_PMNT_FREQ | VARCHAR2 | (15) | ||
PTH_BASE_PMNT_REMIT_DAYS | NUMBER | |||
PTH_BASE_DISB_BASIS | VARCHAR2 | (10) | ||
PTH_BASE_DISB_FIXED_AMOUNT | NUMBER | |||
PTH_BASE_DISB_PCT | NUMBER | |||
PTH_BASE_PROC_FEE_BASIS | VARCHAR2 | (10) | ||
PTH_BASE_PROC_FEE_FIXED_AMT | NUMBER | |||
PTH_BASE_PROC_PCT | NUMBER | |||
PTH_EVG_VENDOR_SITE_CODE | VARCHAR2 | (150) | ||
PTH_EVG_VENDOR_SITE_ID | NUMBER | |||
PTH_EVG_PAYGROUP_CODE | VARCHAR2 | (30) | ||
PTH_EVG_PMNT_TERM_CODE | VARCHAR2 | (30) | ||
PTH_EVG_PMNT_TERM_ID | NUMBER | |||
PTH_EVG_PMNT_BASIS | VARCHAR2 | (15) | ||
PTH_EVG_PMNT_START_DATE | DATE | |||
PTH_EVG_PMNT_METHOD_CODE | VARCHAR2 | (30) | ||
PTH_EVG_PMNT_FREQ | VARCHAR2 | (30) | ||
PTH_EVG_PMNT_REMIT_DAYS | NUMBER | |||
PTH_EVG_DISB_BASIS | VARCHAR2 | (10) | ||
PTH_EVG_DISB_FIXED_AMOUNT | NUMBER | |||
PTH_EVG_DISB_PCT | NUMBER | |||
PTH_EVG_PROC_FEE_BASIS | VARCHAR2 | (10) | ||
PTH_EVG_PROC_FEE_FIXED_AMT | NUMBER | |||
PTH_EVG_PROC_PCT | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NUMBER_OLD
, LINE_NUMBER
, ASSET_VENDOR_NAME
, ASSET_VENDOR_ID
, SERVICE_VENDOR_NAME
, SERVICE_VENDOR_ID
, FEES_VENDOR_NAME
, FEES_VENDOR_ID
, GUARANTOR_NUMBER
, GUARANTOR_ID
, GUARANTOR_SITE_NUMBER
, GUARANTOR_SITE_ID
, DEALER_NAME
, DEALER_ID
, GUARANTOR_TYPE
, GUARANTEE_TYPE
, GUARANTEED_AMOUNT
, GUARANTEE_DATE
, GUARANTEE_COMMENT
, BILLABLE_VENDOR_ID
, BILLABLE_VENDOR_NAME
, VEND_AS_CUSTOMER_NUMBER
, VEND_AS_CUSTOMER_ID
, VEND_AS_CUSTOMER_ACC_NUMBER
, VEND_AS_CUSTOMER_ACC_ID
, VEND_BILL_TO_ADDR_ID
, VEND_BILL_TO_ADDR
, VEND_PAYMENT_METHOD_ID
, VEND_PAYMENT_METHOD
, VEND_BANK_ACC_ID
, VEND_BANK_ACC_NUMBER
, VEND_INVOICE_FORMAT_ID
, VEND_INVOICE_FORMAT_CODE
, VEND_REVIEW_INVOICE_FLAG
, VEND_REASON_FOR_INV_REVIEW
, VEND_INV_REVIEW_UNTIL_DATE
, PTH_BASE_VENDOR_SITE_CODE
, PTH_BASE_VENDOR_SITE_CODE_1
, PTH_BASE_VENDOR_SITE_ID
, PTH_BASE_PAYGROUP_CODE
, PTH_BASE_PMNT_TERM_CODE
, PTH_BASE_PMNT_TERM_ID
, PTH_BASE_PMNT_BASIS
, PTH_BASE_PMNT_START_DATE
, PTH_BASE_PMNT_METHOD_CODE
, PTH_BASE_PMNT_FREQ
, PTH_BASE_PMNT_REMIT_DAYS
, PTH_BASE_DISB_BASIS
, PTH_BASE_DISB_FIXED_AMOUNT
, PTH_BASE_DISB_PCT
, PTH_BASE_PROC_FEE_BASIS
, PTH_BASE_PROC_FEE_FIXED_AMT
, PTH_BASE_PROC_PCT
, PTH_EVG_VENDOR_SITE_CODE
, PTH_EVG_VENDOR_SITE_ID
, PTH_EVG_PAYGROUP_CODE
, PTH_EVG_PMNT_TERM_CODE
, PTH_EVG_PMNT_TERM_ID
, PTH_EVG_PMNT_BASIS
, PTH_EVG_PMNT_START_DATE
, PTH_EVG_PMNT_METHOD_CODE
, PTH_EVG_PMNT_FREQ
, PTH_EVG_PMNT_REMIT_DAYS
, PTH_EVG_DISB_BASIS
, PTH_EVG_DISB_FIXED_AMOUNT
, PTH_EVG_DISB_PCT
, PTH_EVG_PROC_FEE_BASIS
, PTH_EVG_PROC_FEE_FIXED_AMT
, PTH_EVG_PROC_PCT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM OKL.OKL_PARTY_ROLES_INTERFACE#;
|
|
|