[Home] [Help] [Dependency Information]
Object Name: | AR_LATE_CHARGE_TRX_T# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LATE_CHARGE_TRX_ID | NUMBER | (15) | Yes | |
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
CLASS | VARCHAR2 | (30) | ||
AMOUNT_DUE_ORIGINAL | NUMBER | |||
AMOUNT_DUE_REMAINING | NUMBER | |||
FIN_CHARGE_CHARGED | NUMBER | |||
TRX_DATE | DATE | |||
CUST_TRX_TYPE_ID | NUMBER | (15) | ||
LAST_CHARGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | (15) | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
MIN_INTEREST_CHARGE | NUMBER | |||
MAX_INTEREST_CHARGE | NUMBER | |||
OVERDUE_LATE_PAY_AMOUNT | NUMBER | |||
ORIGINAL_BALANCE | NUMBER | |||
DUE_DATE | DATE | |||
RECEIPT_DATE | DATE | |||
FINANCE_CHARGE_DATE | DATE | |||
CHARGE_TYPE | VARCHAR2 | (30) | ||
ACTUAL_DATE_CLOSED | DATE | |||
INTEREST_RATE | NUMBER | |||
INTEREST_DAYS | NUMBER | |||
RATE_START_DATE | DATE | |||
RATE_END_DATE | DATE | |||
SCHEDULE_DAYS_START | NUMBER | |||
SCHEDULE_DAYS_TO | NUMBER | |||
LATE_CHARGE_AMOUNT | NUMBER | |||
LATE_CHARGE_TYPE | VARCHAR2 | (30) | ||
LATE_CHARGE_TERM_ID | NUMBER | (15) | ||
INTEREST_PERIOD_DAYS | NUMBER | |||
INTEREST_CALCULATION_PERIOD | VARCHAR2 | (30) | ||
CHARGE_ON_FINANCE_CHARGE_FLAG | VARCHAR2 | (1) | ||
MESSAGE_TEXT_ID | NUMBER | (15) | ||
INTEREST_TYPE | VARCHAR2 | (30) | ||
MIN_FC_INVOICE_OVERDUE_TYPE | VARCHAR2 | (30) | ||
MIN_FC_INVOICE_AMOUNT | NUMBER | |||
MIN_FC_INVOICE_PERCENT | NUMBER | |||
CHARGE_LINE_TYPE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | Yes | |
DISPLAY_FLAG | VARCHAR2 | (1) | ||
CASH_RECEIPT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT LATE_CHARGE_TRX_ID
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, CURRENCY_CODE
, CUSTOMER_TRX_ID
, LEGAL_ENTITY_ID
, PAYMENT_SCHEDULE_ID
, CLASS
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, FIN_CHARGE_CHARGED
, TRX_DATE
, CUST_TRX_TYPE_ID
, LAST_CHARGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, MIN_INTEREST_CHARGE
, MAX_INTEREST_CHARGE
, OVERDUE_LATE_PAY_AMOUNT
, ORIGINAL_BALANCE
, DUE_DATE
, RECEIPT_DATE
, FINANCE_CHARGE_DATE
, CHARGE_TYPE
, ACTUAL_DATE_CLOSED
, INTEREST_RATE
, INTEREST_DAYS
, RATE_START_DATE
, RATE_END_DATE
, SCHEDULE_DAYS_START
, SCHEDULE_DAYS_TO
, LATE_CHARGE_AMOUNT
, LATE_CHARGE_TYPE
, LATE_CHARGE_TERM_ID
, INTEREST_PERIOD_DAYS
, INTEREST_CALCULATION_PERIOD
, CHARGE_ON_FINANCE_CHARGE_FLAG
, MESSAGE_TEXT_ID
, INTEREST_TYPE
, MIN_FC_INVOICE_OVERDUE_TYPE
, MIN_FC_INVOICE_AMOUNT
, MIN_FC_INVOICE_PERCENT
, CHARGE_LINE_TYPE
, ORG_ID
, REQUEST_ID
, DISPLAY_FLAG
, CASH_RECEIPT_ID
FROM AR.AR_LATE_CHARGE_TRX_T#;
|
|
|