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 |