Skip to content

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

VIEW: AR.AR_BR_STATUS_REP_ITF#

Object Details
Object Name: AR_BR_STATUS_REP_ITF#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
STATUS VARCHAR2 (80)
STATUS_DATE DATE

TRANSACTION_NUMBER VARCHAR2 (20)
DOCUMENT_NUMBER NUMBER

DOCUMENT_SEQUENCE_NAME VARCHAR2 (30)
CURRENCY VARCHAR2 (15)
MAGNETIC_FORMAT_CODE VARCHAR2 (30)
ENTERED_AMOUNT NUMBER

FUNCTIONAL_AMOUNT NUMBER

BALANCE_DUE NUMBER

FUNCTIONAL_BALANCE_DUE NUMBER

ASSIGNED_ENTERED_AMOUNT NUMBER

ASSIGNED_FUNCTIONAL_AMOUNT NUMBER

DRAWEE_NAME VARCHAR2 (255)
DRAWEE_NUMBER VARCHAR2 (30)
JGZZ_FISCAL_CODE VARCHAR2 (20)
DRAWEE_VAT_REG_NUMBER VARCHAR2 (50)
DRAWEE_CITY VARCHAR2 (60)
DRAWEE_STATE VARCHAR2 (60)
DRAWEE_COUNTRY VARCHAR2 (60)
DRAWEE_POSTAL_CODE VARCHAR2 (60)
DRAWEE_CLASS VARCHAR2 (80)
DRAWEE_CATEGORY VARCHAR2 (80)
DRAWEE_LOCATION VARCHAR2 (40)
ISSUE_DATE DATE

CREATION_GL_DATE DATE

STATUS_GL_DATE DATE

MATURITY_DATE DATE

ORIGINAL_MATURITY_DATE DATE

ISSUED_BY_DRAWEE VARCHAR2 (1)
SIGNED_BY_DRAWEE VARCHAR2 (1)
TRANSACTION_TYPE VARCHAR2 (20)
TRANSACTION_BATCH_SOURCE VARCHAR2 (50)
REMIT_BANK_NAME VARCHAR2 (60)
REMIT_BANK_NUMBER VARCHAR2 (30)
REMIT_BRANCH_NAME VARCHAR2 (60)
REMIT_BRANCH_NUMBER VARCHAR2 (25)
REMIT_BANK_ACC_NAME VARCHAR2 (80)
REMIT_BANK_ACC_NUMBER VARCHAR2 (30)
REMIT_BRANCH_CITY VARCHAR2 (25)
REMIT_BRANCH_STATE VARCHAR2 (25)
REMIT_BRANCH_COUNTRY VARCHAR2 (25)
REMIT_BRANCH_POSTAL_CODE VARCHAR2 (20)
REMIT_BRANCH_ADDRESS1 VARCHAR2 (40)
REMIT_BRANCH_ADDRESS2 VARCHAR2 (40)
REMIT_BRANCH_ADDRESS3 VARCHAR2 (40)
REMIT_BANK_ALLOW_OVERRIDE VARCHAR2 (1)
REMIT_BANK_ACC_CHECK_DIGITS VARCHAR2 (30)
REMIT_BANK_ACC_CURR VARCHAR2 (15)
DRAWEE_BANK_NAME VARCHAR2 (60)
DRAWEE_BANK_NUMBER VARCHAR2 (30)
DRAWEE_BRANCH_NAME VARCHAR2 (60)
DRAWEE_BRANCH_NUMBER VARCHAR2 (25)
DRAWEE_BANK_ACC_NAME VARCHAR2 (80)
DRAWEE_BANK_ACC_NUMBER VARCHAR2 (30)
DRAWEE_BRANCH_CITY VARCHAR2 (25)
DRAWEE_BRANCH_STATE VARCHAR2 (25)
DRAWEE_BRANCH_COUNTRY VARCHAR2 (25)
DRAWEE_BRANCH_POSTAL_CODE VARCHAR2 (20)
DRAWEE_BRANCH_ADDRESS1 VARCHAR2 (40)
DRAWEE_BRANCH_ADDRESS2 VARCHAR2 (40)
DRAWEE_BRANCH_ADDRESS3 VARCHAR2 (40)
DRAWEE_BANK_ACC_CHECK_DIGITS VARCHAR2 (30)
DRAWEE_BANK_ACC_CURR VARCHAR2 (15)
UNPAID_DATE DATE

ACCEPTANCE_DATE DATE

COMMENTS VARCHAR2 (240)
DAYS_LATE NUMBER

REMITTANCE_BATCH_NAME VARCHAR2 (20)
REMITTANCE_METHOD VARCHAR2 (30)
WITH_RECOURSE VARCHAR2 (1)
LAST_PRINTED_DATE DATE

UNPAID_RECEIPT_REVERSAL_REASON VARCHAR2 (80)
RISK_ELIMINATION_DAYS NUMBER

REMITTANCE_DATE DATE

REMITTANCE_PAYMENT_METHOD VARCHAR2 (30)
CREATION_BATCH_NAME VARCHAR2 (50)
DRAWEE_ADDRESS1 VARCHAR2 (240)
DRAWEE_ADDRESS2 VARCHAR2 (240)
DRAWEE_ADDRESS3 VARCHAR2 (240)
DRAWEE_CONTACT VARCHAR2 (320)
SPECIAL_INSTRUCTIONS VARCHAR2 (240)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (30)
ORGANIZATION_NAME VARCHAR2 (30)
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# references the following:

SchemaAR
TableAR_BR_STATUS_REP_ITF
AR.AR_BR_STATUS_REP_ITF# is referenced by following:

SchemaAPPS
SynonymAR_BR_STATUS_REP_ITF