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

TABLE: JL.JL_BR_AR_PAY_SCHED_AUX

Object Details
Object Name: JL_BR_AR_PAY_SCHED_AUX
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_AR_PAY_SCHED_AUX
Subobject Name:
Status: VALID


JL_BR_AR_PAY_SCHED_AUX is a temporary table. This table is used internally in bank transfer batches.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PAYMENT_SCHEDULE_ID NUMBER
Yes Payment Schedule identifier
AMOUNT_DUE_REMAINING NUMBER

Amount Due Remaining
DUE_DATE DATE

Due Date
SELECT_ACCOUNT_ID NUMBER

Account Selection Control identifier
CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number
BANK_INSTRUCTION_CODE1 NUMBER

Bank Instruction 1
BANK_INSTRUCTION_CODE2 NUMBER

Bank Instruction 2
BANK_NUMBER VARCHAR2 (30)
Bank Number identifier
BANK_ACCOUNT_ID NUMBER

Bank Account identifier
BRANCH_NUMBER VARCHAR2 (25)
Branch Number identifier
PORTFOLIO_CODE NUMBER

Portfolio Code
BATCH_SOURCE_ID NUMBER

Batch Source identifier
RECEIPT_METHOD_ID NUMBER

Receipt Method identifier
CUSTOMER_TRX_TYPE_ID NUMBER (15)
Customer Transaction Type identifier
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank Account Number
CUSTOMER_TRX_ID NUMBER

Customer Transaction identifier
TERMS_SEQUENCE_NUMBER NUMBER

Terms Sequence Number
CUSTOMER_SITE_USE_ID NUMBER

Customer Site Use identifier
BANK_CHARGE_AMOUNT NUMBER

Collection Expense Amount
BANK_PARTY_ID NUMBER (15)
Bank's party identifier
BRANCH_PARTY_ID NUMBER (15)
Collector bank's branch party ID
BANK_ACCT_USE_ID NUMBER (15)
Uniquely identifies the bank account uses
Query Text

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;

Dependencies

[top of page]

JL.JL_BR_AR_PAY_SCHED_AUX does not reference any database object

JL.JL_BR_AR_PAY_SCHED_AUX is referenced by following:

SchemaAPPS
SynonymJL_BR_AR_PAY_SCHED_AUX