[Home] [Help] [Dependency Information]
Object Name: | AR_CASH_REMIT_REFS_INTERIM# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REMIT_REFERENCE_ID | NUMBER | (15) | Yes | |
AUTOMATCH_SET_ID | NUMBER | (15) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
REFERENCE_SOURCE | VARCHAR2 | (30) | ||
CUSTOMER_ID | NUMBER | (15) | ||
BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
TRANSIT_ROUTING_NUMBER | VARCHAR2 | (25) | ||
INVOICE_REFERENCE | VARCHAR2 | (50) | ||
MATCHING_REFERENCE_DATE | DATE | |||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_APPLIED_FROM | NUMBER | |||
TRANS_TO_RECEIPT_RATE | NUMBER | |||
TRANSMISSION_ID | NUMBER | (15) | ||
BATCH_ID | NUMBER | (15) | ||
WORKER_NUMBER | NUMBER | |||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_REFERENCE_STATUS | VARCHAR2 | (30) | Yes | |
INSTALLMENT_REFERENCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REMIT_REFERENCE_ID
, AUTOMATCH_SET_ID
, CASH_RECEIPT_ID
, REFERENCE_SOURCE
, CUSTOMER_ID
, BANK_ACCOUNT_NUMBER
, TRANSIT_ROUTING_NUMBER
, INVOICE_REFERENCE
, MATCHING_REFERENCE_DATE
, INVOICE_CURRENCY_CODE
, AMOUNT_APPLIED
, AMOUNT_APPLIED_FROM
, TRANS_TO_RECEIPT_RATE
, TRANSMISSION_ID
, BATCH_ID
, WORKER_NUMBER
, CUSTOMER_NUMBER
, RECEIPT_REFERENCE_STATUS
, INSTALLMENT_REFERENCE
FROM AR.AR_CASH_REMIT_REFS_INTERIM#;
|
|
|