[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AR_RECEIPTS_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
snapshot log for master table FII.FII_AR_RECEIPTS_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_APPLIED_RCT | NUMBER | |||
AMOUNT_APPLIED_RCT_FUNC | NUMBER | |||
AMOUNT_APPLIED_RCT_PRIM | NUMBER | |||
AMOUNT_APPLIED_RCT_SEC | NUMBER | |||
AMOUNT_APPLIED_TRX | NUMBER | |||
AMOUNT_APPLIED_TRX_FUNC | NUMBER | |||
AMOUNT_APPLIED_TRX_PRIM | NUMBER | |||
AMOUNT_APPLIED_TRX_SEC | NUMBER | |||
APPLICATION_STATUS | VARCHAR2 | (30) | ||
APPLICATION_TYPE | VARCHAR2 | (20) | ||
APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
APPLY_DATE | DATE | |||
AR_CREATION_DATE | DATE | |||
BILL_TO_CUSTOMER_ID | NUMBER | (15) | ||
BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
CM_PREVIOUS_CUSTOMER_TRX_ID | NUMBER | |||
COLLECTOR_BILL_TO_CUSTOMER_ID | NUMBER | (15) | ||
COLLECTOR_BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
DUE_DATE | DATE | |||
EARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_SEC | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_TRX | NUMBER | |||
FILTER_DATE | DATE | |||
GL_DATE | DATE | |||
HEADER_FILTER_DATE | DATE | |||
HEADER_STATUS | VARCHAR2 | (30) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
RCT_ACTUAL_DATE_CLOSED | DATE | |||
RECEIPT_DATE | DATE | |||
RECEIPT_METHOD_ID | NUMBER | (15) | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_TYPE | VARCHAR2 | (20) | ||
RECEIVABLE_APPLICATION_ID | NUMBER | (15) | ||
TIME_ID | NUMBER | (15) | ||
TOTAL_RECEIPT_COUNT | NUMBER | |||
TRX_DATE | DATE | |||
UNEARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_SEC | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_TRX | NUMBER | |||
USER_ID | NUMBER | (15) | ||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_APPLIED_RCT
, AMOUNT_APPLIED_RCT_FUNC
, AMOUNT_APPLIED_RCT_PRIM
, AMOUNT_APPLIED_RCT_SEC
, AMOUNT_APPLIED_TRX
, AMOUNT_APPLIED_TRX_FUNC
, AMOUNT_APPLIED_TRX_PRIM
, AMOUNT_APPLIED_TRX_SEC
, APPLICATION_STATUS
, APPLICATION_TYPE
, APPLIED_PAYMENT_SCHEDULE_ID
, APPLY_DATE
, AR_CREATION_DATE
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, CASH_RECEIPT_ID
, CM_PREVIOUS_CUSTOMER_TRX_ID
, COLLECTOR_BILL_TO_CUSTOMER_ID
, COLLECTOR_BILL_TO_SITE_USE_ID
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, CUSTOMER_TRX_ID
, DUE_DATE
, EARNED_DISCOUNT_AMOUNT_FUNC
, EARNED_DISCOUNT_AMOUNT_PRIM
, EARNED_DISCOUNT_AMOUNT_SEC
, EARNED_DISCOUNT_AMOUNT_TRX
, FILTER_DATE
, GL_DATE
, HEADER_FILTER_DATE
, HEADER_STATUS
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, PAYMENT_SCHEDULE_ID
, RCT_ACTUAL_DATE_CLOSED
, RECEIPT_DATE
, RECEIPT_METHOD_ID
, RECEIPT_NUMBER
, RECEIPT_TYPE
, RECEIVABLE_APPLICATION_ID
, TIME_ID
, TOTAL_RECEIPT_COUNT
, TRX_DATE
, UNEARNED_DISCOUNT_AMOUNT_FUNC
, UNEARNED_DISCOUNT_AMOUNT_PRIM
, UNEARNED_DISCOUNT_AMOUNT_SEC
, UNEARNED_DISCOUNT_AMOUNT_TRX
, USER_ID
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM FII.MLOG$_FII_AR_RECEIPTS_F;
FII.MLOG$_FII_AR_RECEIPTS_F does not reference any database object
FII.MLOG$_FII_AR_RECEIPTS_F is referenced by following:
|
|
|