[Home] [Help] [Dependency Information]
Object Name: | CE_UPGA_BANK_ACCOUNTS# |
---|---|
Object Type: | VIEW |
Owner: | CE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CE_BANK_ACCOUNT_ID | NUMBER | (15) | ||
CE_UPGRADE_ID | NUMBER | (15) | Yes | |
PARENT_UPGRADE_ID | NUMBER | (15) | Yes | |
UPGRADE_STATUS | VARCHAR2 | (30) | ||
PRIMARY_ACCT_FLAG | VARCHAR2 | (1) | ||
SECONDARY_ACCT_FLAG | VARCHAR2 | (1) | ||
GROUP_ID | NUMBER | (15) | ||
BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
CREATED_BY_MODULE | VARCHAR2 | (150) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
BANK_ACCOUNT_NUM | VARCHAR2 | (30) | ||
BRANCH_PARTY_ID | NUMBER | (15) | ||
BANK_PARTY_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
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 | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
CHECK_DIGITS | VARCHAR2 | (30) | ||
BANK_ACCOUNT_NAME_ALT | VARCHAR2 | (320) | ||
ACCOUNT_HOLDER_NAME | VARCHAR2 | (80) | ||
ACCOUNT_HOLDER_NAME_ALT | VARCHAR2 | (80) | ||
EFT_REQUESTER_IDENTIFIER | VARCHAR2 | (25) | ||
SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | (30) | ||
ACCOUNT_SUFFIX | VARCHAR2 | (30) | ||
DESCRIPTION_CODE1 | VARCHAR2 | (60) | ||
DESCRIPTION_CODE2 | VARCHAR2 | (60) | ||
IBAN_NUM | VARCHAR2 | (50) | ||
SHORT_ACCOUNT_NAME | VARCHAR2 | (30) | ||
ACCOUNT_OWNER_PARTY_ID | NUMBER | (15) | ||
ACCOUNT_OWNER_ORG_ID | NUMBER | (15) | ||
ACCOUNT_CLASSIFICATION | VARCHAR2 | (30) | ||
AP_USE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
AR_USE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
XTR_USE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
PAY_USE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
MULTI_CURRENCY_ALLOWED_FLAG | VARCHAR2 | (1) | ||
PAYMENT_MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | ||
RECEIPT_MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | ||
ZERO_AMOUNT_ALLOWED_FLAG | VARCHAR2 | (1) | ||
MAX_OUTLAY | NUMBER | (15) | ||
MAX_CHECK_AMOUNT | NUMBER | (15) | ||
MIN_CHECK_AMOUNT | NUMBER | (15) | ||
AP_AMOUNT_TOLERANCE | NUMBER | (15) | ||
AP_PERCENT_TOLERANCE | NUMBER | (15) | ||
AR_AMOUNT_TOLERANCE | NUMBER | (15) | ||
AR_PERCENT_TOLERANCE | NUMBER | (15) | ||
XTR_AMOUNT_TOLERANCE | NUMBER | (15) | ||
XTR_PERCENT_TOLERANCE | NUMBER | (15) | ||
PAY_AMOUNT_TOLERANCE | NUMBER | (15) | ||
PAY_PERCENT_TOLERANCE | NUMBER | (15) | ||
BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | ||
AGENCY_LOCATION_CODE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
YEAR_CALC_TYPE | VARCHAR2 | (15) | ||
INTEREST_CALCULATION_BASIS | VARCHAR2 | (4) | ||
DAY_COUNT_TYPE_FLAG | VARCHAR2 | (1) | ||
ROUNDING_TYPE_FLAG | VARCHAR2 | (1) | ||
CASHFLOW_DISPLAY_ORDER | NUMBER | (15) | ||
TARGET_BALANCE | NUMBER | (15) | ||
EFT_USER_NUM | VARCHAR2 | (30) | ||
BANK_CODE | VARCHAR2 | (30) | ||
COMM_AGREEMENT_IDENTIFIER | NUMBER | (15) | ||
LEGAL_ACCOUNT_NAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT CE_BANK_ACCOUNT_ID
, CE_UPGRADE_ID
, PARENT_UPGRADE_ID
, UPGRADE_STATUS
, PRIMARY_ACCT_FLAG
, SECONDARY_ACCT_FLAG
, GROUP_ID
, BANK_ACCOUNT_NAME
, CREATED_BY_MODULE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BANK_ACCOUNT_NUM
, BRANCH_PARTY_ID
, BANK_PARTY_ID
, CURRENCY_CODE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CHECK_DIGITS
, BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_NAME
, ACCOUNT_HOLDER_NAME_ALT
, EFT_REQUESTER_IDENTIFIER
, SECONDARY_ACCOUNT_REFERENCE
, ACCOUNT_SUFFIX
, DESCRIPTION_CODE1
, DESCRIPTION_CODE2
, IBAN_NUM
, SHORT_ACCOUNT_NAME
, ACCOUNT_OWNER_PARTY_ID
, ACCOUNT_OWNER_ORG_ID
, ACCOUNT_CLASSIFICATION
, AP_USE_ALLOWED_FLAG
, AR_USE_ALLOWED_FLAG
, XTR_USE_ALLOWED_FLAG
, PAY_USE_ALLOWED_FLAG
, MULTI_CURRENCY_ALLOWED_FLAG
, PAYMENT_MULTI_CURRENCY_FLAG
, RECEIPT_MULTI_CURRENCY_FLAG
, ZERO_AMOUNT_ALLOWED_FLAG
, MAX_OUTLAY
, MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT
, AP_AMOUNT_TOLERANCE
, AP_PERCENT_TOLERANCE
, AR_AMOUNT_TOLERANCE
, AR_PERCENT_TOLERANCE
, XTR_AMOUNT_TOLERANCE
, XTR_PERCENT_TOLERANCE
, PAY_AMOUNT_TOLERANCE
, PAY_PERCENT_TOLERANCE
, BANK_ACCOUNT_TYPE
, AGENCY_LOCATION_CODE
, START_DATE
, END_DATE
, YEAR_CALC_TYPE
, INTEREST_CALCULATION_BASIS
, DAY_COUNT_TYPE_FLAG
, ROUNDING_TYPE_FLAG
, CASHFLOW_DISPLAY_ORDER
, TARGET_BALANCE
, EFT_USER_NUM
, BANK_CODE
, COMM_AGREEMENT_IDENTIFIER
, LEGAL_ACCOUNT_NAME
FROM CE.CE_UPGA_BANK_ACCOUNTS#;
|
|
|