[Home] [Help] [Dependency Information]
Object Name: | AR_RECEIPTS_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) | ||
ORGANIZATION_NAME | VARCHAR2 | (50) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
BATCH_ID | NUMBER | (15) | ||
BATCH_NAME | VARCHAR2 | (20) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_DATE | DATE | |||
EXCHANGE_TYPE | VARCHAR2 | (30) | ||
DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
DOC_SEQUENCE_VALUE | NUMBER | |||
DEPOSIT_DATE | DATE | |||
RECEIPT_DATE | DATE | |||
RECEIPT_TYPE | VARCHAR2 | (30) | ||
RECEIPT_STATUS | VARCHAR2 | (40) | ||
MISC_PAYMENT_SOURCE | VARCHAR2 | (30) | ||
TAX_CODE | VARCHAR2 | (50) | ||
REFERENCE_TYPE | VARCHAR2 | (30) | ||
ANTICIPATED_CLEARING_DATE | DATE | |||
BANK_NAME | VARCHAR2 | (60) | ||
BANK_NAME_ALT | VARCHAR2 | (320) | ||
BANK_BRANCH_NAME | VARCHAR2 | (60) | ||
BANK_BRANCH_NAME_ALT | VARCHAR2 | (320) | ||
BANK_NUMBER | VARCHAR2 | (30) | ||
BANK_BRANCH_NUMBER | VARCHAR2 | (25) | ||
BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
BANK_ACCOUNT_NAME_ALT | VARCHAR2 | (320) | ||
BANK_ACCOUNT_CURRENCY | VARCHAR2 | (15) | ||
RECEIPT_METHOD | VARCHAR2 | (30) | ||
CASH_RECEIPT_HISTORY_ID | NUMBER | (15) | ||
GL_DATE | DATE | |||
RECEIPT_AMOUNT | NUMBER | |||
RECEIPT_HISTORY_STATUS | VARCHAR2 | (40) | ||
ACCTD_RECEIPT_AMOUNT | NUMBER | |||
FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
ACCTD_FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
ACCOUNT_CODE_COMBINATION_ID | NUMBER | (15) | ||
DEBIT_ACCOUNT | VARCHAR2 | (240) | ||
DEBIT_ACCOUNT_DESC | VARCHAR2 | (240) | ||
DEBIT_BALANCING | VARCHAR2 | (240) | ||
DEBIT_BALANCING_DESC | VARCHAR2 | (240) | ||
DEBIT_NATACCT | VARCHAR2 | (240) | ||
DEBIT_NATACCT_DESC | VARCHAR2 | (240) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_NAME | VARCHAR2 | (240) | ||
CUSTOMER_NAME_ALT | VARCHAR2 | (320) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | ||
APPLY_DATE | DATE | |||
APPLICATION_STATUS | VARCHAR2 | (20) | ||
AMOUNT_APPLIED_TO | NUMBER | |||
AMOUNT_APPLIED_FROM | NUMBER | |||
ACCTD_AMOUNT_APPLIED_TO | NUMBER | |||
ACCTD_AMOUNT_APPLIED_FROM | NUMBER | |||
EARNED_DISCOUNT_TAKEN | NUMBER | |||
UNEARNED_DISCOUNT_TAKEN | NUMBER | |||
ACCTD_EARNED_DISCOUNT_TAKEN | NUMBER | |||
ACCTD_UNEARNED_DISCOUNT_TAKEN | NUMBER | |||
APPLIED_CUSTOMER_TRX_ID | NUMBER | (15) | ||
TRX_NUMBER | VARCHAR2 | (30) | ||
TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
TRX_DATE | DATE | |||
TRX_AMOUNT | NUMBER | |||
ACCTD_TRX_AMOUNT | NUMBER | |||
RECEIPT_GAIN_LOSS | NUMBER | |||
MISC_PERCENT | NUMBER | |||
MISC_AMOUNT | NUMBER | |||
BATCH_SOURCE | VARCHAR2 | (50) | ||
RELATED_CUSTOMER | VARCHAR2 | (50) | ||
ON_ACCOUNT_AMOUNT | NUMBER | |||
UNAPP_AMOUNT | NUMBER | |||
CLAIM_AMOUNT | NUMBER | |||
PREPAY_AMOUNT | NUMBER | |||
TOTAL_UNRESOLVED_AMOUNT | NUMBER | |||
FORMAT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACTIVITY_NAME | VARCHAR2 | (50) | ||
ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
ACCOUNTING_FLEXFIELD | VARCHAR2 | (2000) | ||
APPLICATION_REF_TYPE | VARCHAR2 | (80) | ||
APPLICATION_REF_NUMBER | VARCHAR2 | (30) | ||
AMOUNT_APPLIED | NUMBER | |||
REMIT_BATCH_NAME | VARCHAR2 | (20) |
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
, ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE
, BATCH_ID
, BATCH_NAME
, CASH_RECEIPT_ID
, RECEIPT_NUMBER
, RECEIPT_CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_DATE
, EXCHANGE_TYPE
, DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE
, DEPOSIT_DATE
, RECEIPT_DATE
, RECEIPT_TYPE
, RECEIPT_STATUS
, MISC_PAYMENT_SOURCE
, TAX_CODE
, REFERENCE_TYPE
, ANTICIPATED_CLEARING_DATE
, BANK_NAME
, BANK_NAME_ALT
, BANK_BRANCH_NAME
, BANK_BRANCH_NAME_ALT
, BANK_NUMBER
, BANK_BRANCH_NUMBER
, BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NAME_ALT
, BANK_ACCOUNT_CURRENCY
, RECEIPT_METHOD
, CASH_RECEIPT_HISTORY_ID
, GL_DATE
, RECEIPT_AMOUNT
, RECEIPT_HISTORY_STATUS
, ACCTD_RECEIPT_AMOUNT
, FACTOR_DISCOUNT_AMOUNT
, ACCTD_FACTOR_DISCOUNT_AMOUNT
, ACCOUNT_CODE_COMBINATION_ID
, DEBIT_ACCOUNT
, DEBIT_ACCOUNT_DESC
, DEBIT_BALANCING
, DEBIT_BALANCING_DESC
, DEBIT_NATACCT
, DEBIT_NATACCT_DESC
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NAME_ALT
, CUSTOMER_NUMBER
, RECEIVABLE_APPLICATION_ID
, APPLY_DATE
, APPLICATION_STATUS
, AMOUNT_APPLIED_TO
, AMOUNT_APPLIED_FROM
, ACCTD_AMOUNT_APPLIED_TO
, ACCTD_AMOUNT_APPLIED_FROM
, EARNED_DISCOUNT_TAKEN
, UNEARNED_DISCOUNT_TAKEN
, ACCTD_EARNED_DISCOUNT_TAKEN
, ACCTD_UNEARNED_DISCOUNT_TAKEN
, APPLIED_CUSTOMER_TRX_ID
, TRX_NUMBER
, TRX_CURRENCY_CODE
, TRX_DATE
, TRX_AMOUNT
, ACCTD_TRX_AMOUNT
, RECEIPT_GAIN_LOSS
, MISC_PERCENT
, MISC_AMOUNT
, BATCH_SOURCE
, RELATED_CUSTOMER
, ON_ACCOUNT_AMOUNT
, UNAPP_AMOUNT
, CLAIM_AMOUNT
, PREPAY_AMOUNT
, TOTAL_UNRESOLVED_AMOUNT
, FORMAT_CURRENCY_CODE
, ACTIVITY_NAME
, ACCOUNT_NUMBER
, ACCOUNTING_FLEXFIELD
, APPLICATION_REF_TYPE
, APPLICATION_REF_NUMBER
, AMOUNT_APPLIED
, REMIT_BATCH_NAME
FROM AR.AR_RECEIPTS_REP_ITF#;
|
|
|