AR_CUSTOMER_BALANCE_ITF
Customers selected for the Customer Open Balance letter report
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_NOLOGGING
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| AS_OF_DATE | DATE | Yes | As of date | ||
| ORGANIZATION_NAME | VARCHAR2 | 60 | Yes | Business unit name. | |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Code used for the ledger currency. | |
| CUSTOMER_NAME | VARCHAR2 | 360 | Yes | Customer name | |
| CUSTOMER_NUMBER | VARCHAR2 | 30 | Yes | Customer number | |
| TAX_REFERENCE_NUM | VARCHAR2 | 50 | Customer tax reference number | ||
| ADDRESS_LINE1 | VARCHAR2 | 240 | Customer bill-to address line1 | ||
| ADDRESS_LINE2 | VARCHAR2 | 240 | Customer bill-to address line2 | ||
| ADDRESS_LINE3 | VARCHAR2 | 240 | Customer bill-to address line3 | ||
| ADDRESS_LINE4 | VARCHAR2 | 240 | Customer bill-to address line4 | ||
| CITY | VARCHAR2 | 60 | Customer bill-to city | ||
| STATE | VARCHAR2 | 60 | Customer state | ||
| ZIP | VARCHAR2 | 60 | Customer zip code. | ||
| COUNTRY | VARCHAR2 | 60 | Customer country | ||
| TRANS_TYPE | VARCHAR2 | 20 | Yes | Transaction type. | |
| TRX_NUMBER | VARCHAR2 | 30 | Yes | Transaction number. | |
| TRANSACTION_DATE | DATE | Yes | Transaction date. | ||
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Transaction currency code. | |
| TRANS_AMOUNT | NUMBER | Total transaction amount. | |||
| TRANS_AMOUNT_REMAINING | NUMBER | Amount remaining on invoice/open balance | |||
| RECEIPT_AMOUNT | NUMBER | Transaction receipt amount | |||
| ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount | |||
| EARNED_DISCOUNT_AMOUNT | NUMBER | Total discount amount | |||
| UNEARNED_DISCOUNT_AMOUNT | NUMBER | Accounted unearned total | |||
| INVOICE_CREDIT_AMOUNT | NUMBER | Total invoice credit amount | |||
| BANK_CHARGE | NUMBER | Not currently used. | |||
| ON_ACCOUNT_CREDIT_AMOUNT | NUMBER | Total on-account credit amount | |||
| ON_ACCOUNT_RECEIPTS | NUMBER | Total on-account receipts | |||
| UNAPPLIED_RECEIPTS | NUMBER | Total unapplied receipts |