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

TABLE: JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL

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


JL_BR_AR_REC_MET_ACCTS_EXT_ALL stores additional accounts for your receipt method and bank account. These additional code combinations are used in Bank Transfer and interest.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_AR_REC_MET_ACC_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBANK_ACCT_USE_ID
ColumnRECEIPT_METHOD_ID
Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_ID NUMBER (15)
Bank account identifier
RECEIPT_METHOD_ID NUMBER (15) Yes Receipt method identifier
BANK_CHARGES_CCID NUMBER

Bank charge account code combination
COLL_ENDORSEMENT_CCID NUMBER

Collection endorsement account code combination
BILLS_COLLECTION_CCID NUMBER

Bills under collection account code combination
OTHER_CREDITS_CCID NUMBER

Other credits account code combination
FACTORING_DOCS_CCID NUMBER

Factoring documents account code combination
PORTFOLIO_CODE NUMBER

Portfolio code
MIN_DOCUMENT_AMOUNT NUMBER

Minimum amount for a document in a remittance batch
MAX_DOCUMENT_AMOUNT NUMBER

Maximum amount for a document in a remittance batch
MIN_REMITTANCE_AMOUNT NUMBER

Minimum amount for a remittance batch
MAX_REMITTANCE_AMOUNT NUMBER

Maximum amount for a remittance batch
BANK_INSTRUCTION_CODE1 NUMBER

Bank instruction 1
BANK_INSTRUCTION_CODE2 NUMBER

Bank instruction 2
BANK_CHARGE_AMOUNT NUMBER

Bank charge amount
FACTORING_RATE NUMBER

Factoring rate for period
FACTORING_RATE_PERIOD NUMBER

Number of days in factoring rate period
BATCH_SOURCE_ID NUMBER

Batch source identifier
CALCULATED_INTEREST_CCID NUMBER

Calculated interest account code combination
INTEREST_WRITEOFF_CCID NUMBER

Write off interest difference account code combination
FACTORING_INTEREST_CCID NUMBER

Factoring interest account code combination
ABATEMENT_WRITEOFF_CCID NUMBER (15)
Write off of abatement difference account code combination
ABATEMENT_REVENUE_CCID NUMBER (15)
Revenue of abatement difference account code combination
INTEREST_REVENUE_CCID NUMBER (15)
Revenue of interest difference account code combination
CALCULATED_INTEREST_RECTRX_ID NUMBER (15)
Calculated interest account code combination
INTEREST_WRITEOFF_RECTRX_ID NUMBER (15)
Identifier for activity associated with interest writeoff
INTEREST_REVENUE_RECTRX_ID NUMBER (15)
Identifier for activity associated with interest revenue
ABATEMENT_WRITEOFF_RECTRX_ID NUMBER (15)
Identifier for activity associated with abatement writeoff
ABATEMENT_REVENUE_RECTRX_ID NUMBER (15)
Identifier for activity associated with abatement revenue
WRITEOFF_PERC_TOLERANCE NUMBER

Tolerance limit for automatic interest writeoff in percentage
WRITEOFF_AMOUNT_TOLERANCE NUMBER

Tolerance limit for automatic interest writeoff in amount
GL_DATE_BANK_RETURN VARCHAR2 (15)
Accounting date for receipts generated by bank return ("DEPOSIT DATE" or "RECEIPT DATE")
FLOATING NUMBER (3)
Bank floating days to calculate the accounting date for receipts generated by bank return
ORG_ID NUMBER (15)
Operating unit identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DISC_ENDORSEMENT_CCID NUMBER (15)
DISCOUNT ENDORSEMENT Code combination Id
BILLS_DISCOUNT_CCID NUMBER (15)
Bills discount code combination Id
FACTORING_CHARGES_CCID NUMBER (15)
FACTORING CHARGES Code combination Id
DISCOUNTED_BILLS_CCID NUMBER (15)
DISCOUNTED BILLS Code Combination Id
BANK_ACCT_USE_ID NUMBER (15) Yes Uniquely identifies the bank account uses
COLL_REMITTANCE_MEDIA VARCHAR2 (30)
Collection remittance media
COLL_FORMAT_PGM_ID NUMBER (15)
Collection format program identifier
FACTOR_REMITTANCE_MEDIA VARCHAR2 (30)
Factoring remittance media
FACTOR_FORMAT_PGM_ID NUMBER (15)
Factoring format program Identifier
OCC_REP_FORMAT_PGM_ID NUMBER (15)
Occurrence report format program identifier
OCC_FILE_FORMAT_PGM_ID NUMBER (15)
Occurrence file format program identifier
MAX_COLLECTION_DOCS NUMBER

Maximum number of collection documents
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANK_ACCOUNT_ID
,      RECEIPT_METHOD_ID
,      BANK_CHARGES_CCID
,      COLL_ENDORSEMENT_CCID
,      BILLS_COLLECTION_CCID
,      OTHER_CREDITS_CCID
,      FACTORING_DOCS_CCID
,      PORTFOLIO_CODE
,      MIN_DOCUMENT_AMOUNT
,      MAX_DOCUMENT_AMOUNT
,      MIN_REMITTANCE_AMOUNT
,      MAX_REMITTANCE_AMOUNT
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      BANK_CHARGE_AMOUNT
,      FACTORING_RATE
,      FACTORING_RATE_PERIOD
,      BATCH_SOURCE_ID
,      CALCULATED_INTEREST_CCID
,      INTEREST_WRITEOFF_CCID
,      FACTORING_INTEREST_CCID
,      ABATEMENT_WRITEOFF_CCID
,      ABATEMENT_REVENUE_CCID
,      INTEREST_REVENUE_CCID
,      CALCULATED_INTEREST_RECTRX_ID
,      INTEREST_WRITEOFF_RECTRX_ID
,      INTEREST_REVENUE_RECTRX_ID
,      ABATEMENT_WRITEOFF_RECTRX_ID
,      ABATEMENT_REVENUE_RECTRX_ID
,      WRITEOFF_PERC_TOLERANCE
,      WRITEOFF_AMOUNT_TOLERANCE
,      GL_DATE_BANK_RETURN
,      FLOATING
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISC_ENDORSEMENT_CCID
,      BILLS_DISCOUNT_CCID
,      FACTORING_CHARGES_CCID
,      DISCOUNTED_BILLS_CCID
,      BANK_ACCT_USE_ID
,      COLL_REMITTANCE_MEDIA
,      COLL_FORMAT_PGM_ID
,      FACTOR_REMITTANCE_MEDIA
,      FACTOR_FORMAT_PGM_ID
,      OCC_REP_FORMAT_PGM_ID
,      OCC_FILE_FORMAT_PGM_ID
,      MAX_COLLECTION_DOCS
FROM JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL does not reference any database object

JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL is referenced by following:

SchemaAPPS
SynonymJL_BR_AR_REC_MET_ACCTS_EXT
SynonymJL_BR_AR_REC_MET_ACCTS_EXT_ALL