[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 |
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 |
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:
|
|
|