[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_BR_AR_OCCURRENCE_DOCS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_BR_AR_OCCURRENCE_DOCS_ALL
|
| Subobject Name: | |
| Status: | VALID |
JL_BR_AR_OCCURRENCE_DOCS_ALL stores the remittance occurrences for collection Documents and related following up occurrences.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_BR_AR_OCCUR_DOCS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 OCCURRENCE_ID
|
| JL_BR_AR_OCCUR_DOCS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOCUMENT_ID
OCCURRENCE_STATUS
|
| JL_BR_AR_OCCUR_DOCS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SITE_USE_ID
|
| JL_BR_AR_OCCUR_DOCS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ID
|
| JL_BR_AR_OCCUR_DOCS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OCCURRENCE_STATUS
|
| JL_BR_AR_OCCUR_DOCS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OCCURRENCE_STATUS
BANK_OCCURRENCE_TYPE
DOCUMENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OCCURRENCE_ID | NUMBER | Yes | Occurrence identifier | |
| DOCUMENT_ID | NUMBER | Yes | Collection Document identifier | |
| BANK_OCCURRENCE_CODE | NUMBER | (2) | Yes | Bank occurrence code |
| BANK_NUMBER | VARCHAR2 | (30) | Bank Number to identify bank | |
| BANK_OCCURRENCE_TYPE | VARCHAR2 | (30) | Yes | Lookup code for Lookup Type JLBR_AR_BANK_OCCURRENCE_TYPE |
| OCCURRENCE_DATE | DATE | Occurrence Generation Date | ||
| OCCURRENCE_STATUS | VARCHAR2 | (30) | Lookup Code for Lookup Type JLBR_AR_OCCURENCE_STATUS | |
| ORIGINAL_REMITTANCE_MEDIA | VARCHAR2 | (30) | Lookup Code for Lookup Type JLBR_AR_REMITTANCE_MEDIA | |
| REMITTANCE_MEDIA | VARCHAR2 | (30) | Lookup Code for Lookup Type JLBR_AR_REMITTANCE_MEDIA | |
| SELECTION_DATE | DATE | Document Selection Date | ||
| BORDERO_ID | NUMBER | Associated Bank Transfer Batch identifier | ||
| PORTFOLIO_CODE | NUMBER | Portfolio Code | ||
| TRADE_NOTE_NUMBER | VARCHAR2 | (20) | Trade Note Number | |
| DUE_DATE | DATE | Document Due Date | ||
| DOCUMENT_AMOUNT | NUMBER | Document Amount | ||
| BANK_INSTRUCTION_CODE1 | NUMBER | (2) | Bank instruction 1 | |
| BANK_INSTRUCTION_CODE2 | NUMBER | (2) | Bank instruction 2 | |
| NUM_DAYS_INSTRUCTION | NUMBER | Protest or write off number of days | ||
| INTEREST_PERCENT | NUMBER | Interest Percent | ||
| INTEREST_PERIOD | NUMBER | Interest Period | ||
| INTEREST_AMOUNT | NUMBER | Interest Amount | ||
| GRACE_DAYS | NUMBER | Grace Days | ||
| DISCOUNT_LIMIT_DATE | DATE | Discount Limit Date | ||
| DISCOUNT_AMOUNT | NUMBER | Discount Amount | ||
| CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| SITE_USE_ID | NUMBER | (15) | Site Use identifier | |
| ABATEMENT_AMOUNT | NUMBER | Abatement Amount | ||
| FLAG_POST_GL | VARCHAR2 | (1) | Post to General Ledger Flag | |
| GL_DATE | DATE | General Ledger Date | ||
| GL_POSTED_DATE | DATE | General Ledger Posted Date | ||
| ENDORSEMENT_CREDIT_CCID | NUMBER | (15) | Endorsement Credit Account Code Combination | |
| ENDORSEMENT_DEBIT_CCID | NUMBER | (15) | Endorsement Debit Account Code Combination | |
| ENDORSEMENT_DEBIT_AMOUNT | NUMBER | Endorsement Debit Amount | ||
| ENDORSEMENT_CREDIT_AMOUNT | NUMBER | Endorsement Credit Amount | ||
| BANK_CHARGE_AMOUNT | NUMBER | Bank Charge Amount | ||
| BANK_CHARGES_CREDIT_CCID | NUMBER | (15) | Expense Credit Account Code Combination | |
| BANK_CHARGES_DEBIT_CCID | NUMBER | (15) | Expense Debit Account Code Combination | |
| BANK_CHARGES_CREDIT_AMOUNT | NUMBER | Expense Credit Amount | ||
| BANK_CHARGES_DEBIT_AMOUNT | NUMBER | Expense Debit Amount | ||
| DISCOUNT_CRED_ACCT_CCID | NUMBER | (15) | Discount Credit Account Code Combination | |
| FACTORING_DEBIT_CCID | NUMBER | (15) | Discount Debit Account Code Combination | |
| FACTORING_CREDIT_CCID | NUMBER | (15) | Discount Debit Amount | |
| FACTORING_CREDIT_AMOUNT | NUMBER | Discount Credit Amount | ||
| FACTORING_DEBIT_AMOUNT | NUMBER | Factoring Debit Amount | ||
| FACTOR_INTEREST_CREDIT_CCID | NUMBER | (15) | Discount Interest Credit Account Code Combination | |
| FACTOR_INTEREST_DEBIT_CCID | NUMBER | (15) | Discount Interest Debit Account Code Combination | |
| FACTOR_INTEREST_DEBIT_AMOUNT | NUMBER | Discount Interest Debit Amount | ||
| FACTOR_INTEREST_CREDIT_AMOUNT | NUMBER | Discount Interest Credit Amount | ||
| REVERSE_CHARGES_CRED_CCID | NUMBER | (15) | Reverse Expense Credit Account Code Combination | |
| REVERSE_CHARGES_DEB_CCID | NUMBER | (15) | Reverse Expense Debit Account Code Combination | |
| REVERSE_CHARGES_DEB_AMOUNT | NUMBER | Reverse Expense Debit Amount | ||
| REVERSE_CHARGES_CRED_AMOUNT | NUMBER | Reverse Expense Credit Amount | ||
| REQUEST_ID | NUMBER | (15) | Occurrences Bordero Concurrent Request ID | |
| RETURN_INFO | VARCHAR2 | (50) | Return Information Comments | |
| INTEREST_INDICATOR | VARCHAR2 | (30) | Interest Indicator | |
| RETURN_REQUEST_ID | NUMBER | (15) | Return concurrent request identifier | |
| GL_CANCEL_DATE | DATE | General Ledger Cancel Date | ||
| ORG_ID | NUMBER | (15) | Operating Unit identifier | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment defining column | |
| 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 | |
| FACTORING_CHARGES_CREDIT_CCID | NUMBER | (15) | Factoring charges code combination ID | |
| FACTORING_CHARGES_DEBIT_CCID | NUMBER | (15) | Factoring charges debit code combination Id | |
| FACTORING_CHARGES_CRED_AMOUNT | NUMBER | Factoring charges cred amount is stored | ||
| FACTORING_CHARGES_DEB_AMOUNT | NUMBER | Factoring charges deb amount is stored | ||
| DISCOUNTED_BILLS_CREDIT_CCID | NUMBER | (15) | Discounted bills credit code combination id | |
| DISCOUNTED_BILLS_DEBIT_CCID | NUMBER | (15) | Discounted bills credit code combination Id | |
| DISCOUNTED_BILLS_CRED_AMOUNT | NUMBER | Discounted bills credit amount | ||
| DISCOUNTED_BILLS_DEB_AMOUNT | NUMBER | Discounted bills debit amount | ||
| DISCOUNT_CREDIT_CCID | NUMBER | (15) | Discount Credit Ccid | |
| DISCOUNT_DEBIT_CCID | NUMBER | (15) | Discount Credit Ccid | |
| DISCOUNT_CRED_AMOUNT | NUMBER | Discount Credit Amount | ||
| DISCOUNT_DEB_AMOUNT | NUMBER | Discount Debit Amount | ||
| CASH_CREDIT_CCID | NUMBER | (15) | Cash Credit ccid | |
| CASH_DEBIT_CCID | NUMBER | (15) | Cash Debit ccid | |
| CASH_CRED_AMOUNT | NUMBER | Cash Credit Amount | ||
| CASH_DEB_AMOUNT | NUMBER | Cash Debit Amount | ||
| BANK_PARTY_ID | NUMBER | (15) | Yes | Bank's party identifier |
| CANCEL_EVENT_ID | NUMBER | (15) | Cancellation Subledger Event Identifier. For a cancelled remittance occurrence row, it is the EVENT_ID of the cancellation of the remittance bank occurrence | |
| EVENT_ID | NUMBER | (15) | Subledger Event Identifier for the bank occurrence |
Cut, paste (and edit) the following text to query this object:
SELECT OCCURRENCE_ID
, DOCUMENT_ID
, BANK_OCCURRENCE_CODE
, BANK_NUMBER
, BANK_OCCURRENCE_TYPE
, OCCURRENCE_DATE
, OCCURRENCE_STATUS
, ORIGINAL_REMITTANCE_MEDIA
, REMITTANCE_MEDIA
, SELECTION_DATE
, BORDERO_ID
, PORTFOLIO_CODE
, TRADE_NOTE_NUMBER
, DUE_DATE
, DOCUMENT_AMOUNT
, BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2
, NUM_DAYS_INSTRUCTION
, INTEREST_PERCENT
, INTEREST_PERIOD
, INTEREST_AMOUNT
, GRACE_DAYS
, DISCOUNT_LIMIT_DATE
, DISCOUNT_AMOUNT
, CUSTOMER_ID
, SITE_USE_ID
, ABATEMENT_AMOUNT
, FLAG_POST_GL
, GL_DATE
, GL_POSTED_DATE
, ENDORSEMENT_CREDIT_CCID
, ENDORSEMENT_DEBIT_CCID
, ENDORSEMENT_DEBIT_AMOUNT
, ENDORSEMENT_CREDIT_AMOUNT
, BANK_CHARGE_AMOUNT
, BANK_CHARGES_CREDIT_CCID
, BANK_CHARGES_DEBIT_CCID
, BANK_CHARGES_CREDIT_AMOUNT
, BANK_CHARGES_DEBIT_AMOUNT
, DISCOUNT_CRED_ACCT_CCID
, FACTORING_DEBIT_CCID
, FACTORING_CREDIT_CCID
, FACTORING_CREDIT_AMOUNT
, FACTORING_DEBIT_AMOUNT
, FACTOR_INTEREST_CREDIT_CCID
, FACTOR_INTEREST_DEBIT_CCID
, FACTOR_INTEREST_DEBIT_AMOUNT
, FACTOR_INTEREST_CREDIT_AMOUNT
, REVERSE_CHARGES_CRED_CCID
, REVERSE_CHARGES_DEB_CCID
, REVERSE_CHARGES_DEB_AMOUNT
, REVERSE_CHARGES_CRED_AMOUNT
, REQUEST_ID
, RETURN_INFO
, INTEREST_INDICATOR
, RETURN_REQUEST_ID
, GL_CANCEL_DATE
, ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FACTORING_CHARGES_CREDIT_CCID
, FACTORING_CHARGES_DEBIT_CCID
, FACTORING_CHARGES_CRED_AMOUNT
, FACTORING_CHARGES_DEB_AMOUNT
, DISCOUNTED_BILLS_CREDIT_CCID
, DISCOUNTED_BILLS_DEBIT_CCID
, DISCOUNTED_BILLS_CRED_AMOUNT
, DISCOUNTED_BILLS_DEB_AMOUNT
, DISCOUNT_CREDIT_CCID
, DISCOUNT_DEBIT_CCID
, DISCOUNT_CRED_AMOUNT
, DISCOUNT_DEB_AMOUNT
, CASH_CREDIT_CCID
, CASH_DEBIT_CCID
, CASH_CRED_AMOUNT
, CASH_DEB_AMOUNT
, BANK_PARTY_ID
, CANCEL_EVENT_ID
, EVENT_ID
FROM JL.JL_BR_AR_OCCURRENCE_DOCS_ALL;
JL.JL_BR_AR_OCCURRENCE_DOCS_ALL does not reference any database object
JL.JL_BR_AR_OCCURRENCE_DOCS_ALL is referenced by following:
JL
JL_BR_AR_OCCURRENCE_DOCS_ALL#
|
|
|
|