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

TABLE: AR.AR_BR_STATUS_REP_ITF

Object Details
Object Name: AR_BR_STATUS_REP_ITF
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_BR_STATUS_REP_ITF
Subobject Name:
Status: VALID


The AR_BR_STATUS_REP_ITF table is an RXi interface table that contains data populated by the Bills Receivable by Status report. Oracle Receivables purges this table only when you submit the Purge Data from RXi Interface Tables concurrent program. Until you submit this concurrent program, Receivables adds records to this table each time that the Bills Receivable by Status report is run.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_BR_STATUS_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STATUS VARCHAR2 (80)
Status of the bills receivable
STATUS_DATE DATE

Date of the bills receivable status
TRANSACTION_NUMBER VARCHAR2 (20)
Transaction number of the bills receivable
DOCUMENT_NUMBER NUMBER

Document sequence number
DOCUMENT_SEQUENCE_NAME VARCHAR2 (30)
Document sequence name
CURRENCY VARCHAR2 (15)
Currency of the bills receivable
MAGNETIC_FORMAT_CODE VARCHAR2 (30)
Magnetic format code for the bills receivable remittance
ENTERED_AMOUNT NUMBER

Original amount
FUNCTIONAL_AMOUNT NUMBER

Original amount in functional currency
BALANCE_DUE NUMBER

Current amount due
FUNCTIONAL_BALANCE_DUE NUMBER

Current amount due in functional currency
ASSIGNED_ENTERED_AMOUNT NUMBER

Transaction amount assigned to the bills receivable
ASSIGNED_FUNCTIONAL_AMOUNT NUMBER

Transaction amount assigned to the bills receivable in functional currency
DRAWEE_NAME VARCHAR2 (255)
Drawee name
DRAWEE_NUMBER VARCHAR2 (30)
Drawee number
JGZZ_FISCAL_CODE VARCHAR2 (20)
Drawee taxpayer ID
DRAWEE_VAT_REG_NUMBER VARCHAR2 (50)
Drawee VAT registration number
DRAWEE_CITY VARCHAR2 (60)
Drawee city
DRAWEE_STATE VARCHAR2 (60)
Drawee state
DRAWEE_COUNTRY VARCHAR2 (60)
Drawee country
DRAWEE_POSTAL_CODE VARCHAR2 (60)
Drawee postal code
DRAWEE_CLASS VARCHAR2 (80)
Drawee class
DRAWEE_CATEGORY VARCHAR2 (80)
Drawee category
DRAWEE_LOCATION VARCHAR2 (40)
Drawee site use identifier
ISSUE_DATE DATE

Issue date of the bills receivable
CREATION_GL_DATE DATE

GL date when the bills receivable reached creation status
STATUS_GL_DATE DATE

GL date of the bills receivable status
MATURITY_DATE DATE

Maturity Date of the bills receivable
ORIGINAL_MATURITY_DATE DATE

The original maturity date of the bills receivable
ISSUED_BY_DRAWEE VARCHAR2 (1)
Y or N indicates if the bills receivable was issued by the drawee
SIGNED_BY_DRAWEE VARCHAR2 (1)
Y or N indicates if the bills receivable was signed by the drawee
TRANSACTION_TYPE VARCHAR2 (20)
Transaction type
TRANSACTION_BATCH_SOURCE VARCHAR2 (50)
Batch source of the bills receivable
REMIT_BANK_NAME VARCHAR2 (60)
Name of the remittance bank
REMIT_BANK_NUMBER VARCHAR2 (30)
Number of the remittance bank
REMIT_BRANCH_NAME VARCHAR2 (60)
Name of the remittance bank branch
REMIT_BRANCH_NUMBER VARCHAR2 (25)
Number of the remittance bank branch
REMIT_BANK_ACC_NAME VARCHAR2 (80)
Name of the remittance bank account
REMIT_BANK_ACC_NUMBER VARCHAR2 (30)
Number of the remittance bank account
REMIT_BRANCH_CITY VARCHAR2 (25)
City of the remittance bank branch
REMIT_BRANCH_STATE VARCHAR2 (25)
State of the remittance bank branch
REMIT_BRANCH_COUNTRY VARCHAR2 (25)
Country of the remittance bank branch
REMIT_BRANCH_POSTAL_CODE VARCHAR2 (20)
Postal Code of the remittance bank branch
REMIT_BRANCH_ADDRESS1 VARCHAR2 (40)
Address Line 1 of the remittance bank branch
REMIT_BRANCH_ADDRESS2 VARCHAR2 (40)
Address Line 2 of the remittance bank branch
REMIT_BRANCH_ADDRESS3 VARCHAR2 (40)
Address Line 3 of the remittance bank branch
REMIT_BANK_ALLOW_OVERRIDE VARCHAR2 (1)
Y or N indicates if the bills receivable remittance bank may be dynamically overridden at remittance time
REMIT_BANK_ACC_CHECK_DIGITS VARCHAR2 (30)
Check digits defined for the remittance bank account
REMIT_BANK_ACC_CURR VARCHAR2 (15)
Currency of the remittance bank account
DRAWEE_BANK_NAME VARCHAR2 (60)
Name of the drawee bank
DRAWEE_BANK_NUMBER VARCHAR2 (30)
Number of the drawee bank
DRAWEE_BRANCH_NAME VARCHAR2 (60)
Name of the drawee bank branch
DRAWEE_BRANCH_NUMBER VARCHAR2 (25)
Number of the drawee bank branch
DRAWEE_BANK_ACC_NAME VARCHAR2 (80)
Name of the drawee bank account
DRAWEE_BANK_ACC_NUMBER VARCHAR2 (30)
Number of the drawee bank account
DRAWEE_BRANCH_CITY VARCHAR2 (25)
City of the drawee bank branch
DRAWEE_BRANCH_STATE VARCHAR2 (25)
State of the drawee bank branch
DRAWEE_BRANCH_COUNTRY VARCHAR2 (25)
Country of the drawee bank branch
DRAWEE_BRANCH_POSTAL_CODE VARCHAR2 (20)
Postal code of the drawee bank branch
DRAWEE_BRANCH_ADDRESS1 VARCHAR2 (40)
Address line 1 of the drawee bank branch
DRAWEE_BRANCH_ADDRESS2 VARCHAR2 (40)
Address line 2 of the drawee bank branch
DRAWEE_BRANCH_ADDRESS3 VARCHAR2 (40)
Address line 3 of the drawee bank branch
DRAWEE_BANK_ACC_CHECK_DIGITS VARCHAR2 (30)
Check digits defined for the drawee bank account
DRAWEE_BANK_ACC_CURR VARCHAR2 (15)
Currency of the drawee bank account
UNPAID_DATE DATE

Date that the bill receivable was marked unpaid
ACCEPTANCE_DATE DATE

Date that the bill receivable was accepted
COMMENTS VARCHAR2 (240)
Comments
DAYS_LATE NUMBER

Number of days past the maturity date
REMITTANCE_BATCH_NAME VARCHAR2 (20)
Name of the remittance batch in which the bills receivable is included
REMITTANCE_METHOD VARCHAR2 (30)
Remittance method of the bill receivable
WITH_RECOURSE VARCHAR2 (1)
Y or N indicates if the bills receivable was remitted with recourse
LAST_PRINTED_DATE DATE

Date that the bills receivable was last printed
UNPAID_RECEIPT_REVERSAL_REASON VARCHAR2 (80)
The reason for receipt reversal if the bills receivable is unpaid
RISK_ELIMINATION_DAYS NUMBER

Number of days after maturity date that the receipt will be applied to the bills receivable
REMITTANCE_DATE DATE

Date that the bills receivable is remitted
REMITTANCE_PAYMENT_METHOD VARCHAR2 (30)
Payment method of the remittance batch in which the bills receivable is included
CREATION_BATCH_NAME VARCHAR2 (50)
Name of the bills receivable creation batch
DRAWEE_ADDRESS1 VARCHAR2 (240)
Address line 1 of the drawee
DRAWEE_ADDRESS2 VARCHAR2 (240)
Address line 2 of the drawee
DRAWEE_ADDRESS3 VARCHAR2 (240)
Address line 3 of the drawee
DRAWEE_CONTACT VARCHAR2 (320)
Drawee contact
SPECIAL_INSTRUCTIONS VARCHAR2 (240)
Special instructions
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (30)
Functional currency code
ORGANIZATION_NAME VARCHAR2 (30)
Organization name
Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STATUS
,      STATUS_DATE
,      TRANSACTION_NUMBER
,      DOCUMENT_NUMBER
,      DOCUMENT_SEQUENCE_NAME
,      CURRENCY
,      MAGNETIC_FORMAT_CODE
,      ENTERED_AMOUNT
,      FUNCTIONAL_AMOUNT
,      BALANCE_DUE
,      FUNCTIONAL_BALANCE_DUE
,      ASSIGNED_ENTERED_AMOUNT
,      ASSIGNED_FUNCTIONAL_AMOUNT
,      DRAWEE_NAME
,      DRAWEE_NUMBER
,      JGZZ_FISCAL_CODE
,      DRAWEE_VAT_REG_NUMBER
,      DRAWEE_CITY
,      DRAWEE_STATE
,      DRAWEE_COUNTRY
,      DRAWEE_POSTAL_CODE
,      DRAWEE_CLASS
,      DRAWEE_CATEGORY
,      DRAWEE_LOCATION
,      ISSUE_DATE
,      CREATION_GL_DATE
,      STATUS_GL_DATE
,      MATURITY_DATE
,      ORIGINAL_MATURITY_DATE
,      ISSUED_BY_DRAWEE
,      SIGNED_BY_DRAWEE
,      TRANSACTION_TYPE
,      TRANSACTION_BATCH_SOURCE
,      REMIT_BANK_NAME
,      REMIT_BANK_NUMBER
,      REMIT_BRANCH_NAME
,      REMIT_BRANCH_NUMBER
,      REMIT_BANK_ACC_NAME
,      REMIT_BANK_ACC_NUMBER
,      REMIT_BRANCH_CITY
,      REMIT_BRANCH_STATE
,      REMIT_BRANCH_COUNTRY
,      REMIT_BRANCH_POSTAL_CODE
,      REMIT_BRANCH_ADDRESS1
,      REMIT_BRANCH_ADDRESS2
,      REMIT_BRANCH_ADDRESS3
,      REMIT_BANK_ALLOW_OVERRIDE
,      REMIT_BANK_ACC_CHECK_DIGITS
,      REMIT_BANK_ACC_CURR
,      DRAWEE_BANK_NAME
,      DRAWEE_BANK_NUMBER
,      DRAWEE_BRANCH_NAME
,      DRAWEE_BRANCH_NUMBER
,      DRAWEE_BANK_ACC_NAME
,      DRAWEE_BANK_ACC_NUMBER
,      DRAWEE_BRANCH_CITY
,      DRAWEE_BRANCH_STATE
,      DRAWEE_BRANCH_COUNTRY
,      DRAWEE_BRANCH_POSTAL_CODE
,      DRAWEE_BRANCH_ADDRESS1
,      DRAWEE_BRANCH_ADDRESS2
,      DRAWEE_BRANCH_ADDRESS3
,      DRAWEE_BANK_ACC_CHECK_DIGITS
,      DRAWEE_BANK_ACC_CURR
,      UNPAID_DATE
,      ACCEPTANCE_DATE
,      COMMENTS
,      DAYS_LATE
,      REMITTANCE_BATCH_NAME
,      REMITTANCE_METHOD
,      WITH_RECOURSE
,      LAST_PRINTED_DATE
,      UNPAID_RECEIPT_REVERSAL_REASON
,      RISK_ELIMINATION_DAYS
,      REMITTANCE_DATE
,      REMITTANCE_PAYMENT_METHOD
,      CREATION_BATCH_NAME
,      DRAWEE_ADDRESS1
,      DRAWEE_ADDRESS2
,      DRAWEE_ADDRESS3
,      DRAWEE_CONTACT
,      SPECIAL_INSTRUCTIONS
,      FUNCTIONAL_CURRENCY_CODE
,      ORGANIZATION_NAME
FROM AR.AR_BR_STATUS_REP_ITF;

Dependencies

[top of page]

AR.AR_BR_STATUS_REP_ITF does not reference any database object

AR.AR_BR_STATUS_REP_ITF is referenced by following:

SchemaAR
ViewAR_BR_STATUS_REP_ITF#