[Home] [Help] [Dependency Information]
Object Name: | AR_BR_STATUS_REP_ITF# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|