[Home] [Help] [Dependency Information]
Object Name: | JL_BR_AR_PAY_SCHED_AUX# |
---|---|
Object Type: | VIEW |
Owner: | JL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SCHEDULE_ID | NUMBER | Yes | ||
AMOUNT_DUE_REMAINING | NUMBER | |||
DUE_DATE | DATE | |||
SELECT_ACCOUNT_ID | NUMBER | |||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
BANK_INSTRUCTION_CODE1 | NUMBER | |||
BANK_INSTRUCTION_CODE2 | NUMBER | |||
BANK_NUMBER | VARCHAR2 | (30) | ||
BANK_ACCOUNT_ID | NUMBER | |||
BRANCH_NUMBER | VARCHAR2 | (25) | ||
PORTFOLIO_CODE | NUMBER | |||
BATCH_SOURCE_ID | NUMBER | |||
RECEIPT_METHOD_ID | NUMBER | |||
CUSTOMER_TRX_TYPE_ID | NUMBER | (15) | ||
BANK_ACCOUNT_NUM | VARCHAR2 | (30) | ||
CUSTOMER_TRX_ID | NUMBER | |||
TERMS_SEQUENCE_NUMBER | NUMBER | |||
CUSTOMER_SITE_USE_ID | NUMBER | |||
BANK_CHARGE_AMOUNT | NUMBER | |||
BANK_PARTY_ID | NUMBER | (15) | ||
BRANCH_PARTY_ID | NUMBER | (15) | ||
BANK_ACCT_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SCHEDULE_ID
, AMOUNT_DUE_REMAINING
, DUE_DATE
, SELECT_ACCOUNT_ID
, CUSTOMER_NUMBER
, BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2
, BANK_NUMBER
, BANK_ACCOUNT_ID
, BRANCH_NUMBER
, PORTFOLIO_CODE
, BATCH_SOURCE_ID
, RECEIPT_METHOD_ID
, CUSTOMER_TRX_TYPE_ID
, BANK_ACCOUNT_NUM
, CUSTOMER_TRX_ID
, TERMS_SEQUENCE_NUMBER
, CUSTOMER_SITE_USE_ID
, BANK_CHARGE_AMOUNT
, BANK_PARTY_ID
, BRANCH_PARTY_ID
, BANK_ACCT_USE_ID
FROM JL.JL_BR_AR_PAY_SCHED_AUX#;
|
|
|