DBA Data[Home] [Help] [Dependency Information]

VIEW: AR.AR_STATEMENT_HEADERS#

Object Details
Object Name: AR_STATEMENT_HEADERS#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_CLUSTER_ID NUMBER (15) Yes
SEND_TO_ADDRESS_ID NUMBER (15) Yes
CUSTOMER_ID NUMBER (15) Yes
REMIT_TO_ADDRESS_ID NUMBER (15) Yes
STATEMENT_DATE DATE
Yes
CURRENCY_CODE VARCHAR2 (15)
BUCKET1_HEADING VARCHAR2 (30)
BUCKET2_HEADING VARCHAR2 (30)
BUCKET3_HEADING VARCHAR2 (30)
BUCKET4_HEADING VARCHAR2 (30)
BUCKET5_HEADING VARCHAR2 (30)
BUCKET1 NUMBER
Yes
BUCKET2 NUMBER
Yes
BUCKET3 NUMBER
Yes
BUCKET4 NUMBER
Yes
BUCKET5 NUMBER
Yes
FINANCE_CHARGES NUMBER
Yes
TOTAL_AMOUNT_DUE NUMBER
Yes
ERROR_AMOUNT_DIFFERENT VARCHAR2 (1) Yes
ERROR_NO_SEND_TO VARCHAR2 (1) Yes
ERROR_NO_REMIT_TO VARCHAR2 (1) Yes
ERROR_NO_LINES VARCHAR2 (1) Yes
MESSAGE1 NUMBER

MESSAGE2 NUMBER

MESSAGE3 NUMBER

MESSAGE4 NUMBER

MESSAGE5 NUMBER

MESSAGE6 NUMBER

MESSAGE7 NUMBER

MESSAGE8 NUMBER

MESSAGE1_LINE_COUNT NUMBER

MESSAGE2_LINE_COUNT NUMBER

MESSAGE3_LINE_COUNT NUMBER

MESSAGE4_LINE_COUNT NUMBER

MESSAGE5_LINE_COUNT NUMBER

MESSAGE6_LINE_COUNT NUMBER

MESSAGE7_LINE_COUNT NUMBER

MESSAGE8_LINE_COUNT NUMBER

REQUEST_ID NUMBER (15) Yes
SITE_USE_ID NUMBER (15) Yes
STATEMENT_TYPE VARCHAR2 (30) Yes
BILL_TO_LOCATION VARCHAR2 (40)
CREDIT_BALANCE_STATEMENTS VARCHAR2 (1)
CUST_CUSTOMER_PROFILE_ID NUMBER (15)
MIN_STATEMENT_AMOUNT NUMBER

MONTHLY_INTEREST_RATE NUMBER

SITE_CUSTOMER_PROFILE_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_CLUSTER_ID
,      SEND_TO_ADDRESS_ID
,      CUSTOMER_ID
,      REMIT_TO_ADDRESS_ID
,      STATEMENT_DATE
,      CURRENCY_CODE
,      BUCKET1_HEADING
,      BUCKET2_HEADING
,      BUCKET3_HEADING
,      BUCKET4_HEADING
,      BUCKET5_HEADING
,      BUCKET1
,      BUCKET2
,      BUCKET3
,      BUCKET4
,      BUCKET5
,      FINANCE_CHARGES
,      TOTAL_AMOUNT_DUE
,      ERROR_AMOUNT_DIFFERENT
,      ERROR_NO_SEND_TO
,      ERROR_NO_REMIT_TO
,      ERROR_NO_LINES
,      MESSAGE1
,      MESSAGE2
,      MESSAGE3
,      MESSAGE4
,      MESSAGE5
,      MESSAGE6
,      MESSAGE7
,      MESSAGE8
,      MESSAGE1_LINE_COUNT
,      MESSAGE2_LINE_COUNT
,      MESSAGE3_LINE_COUNT
,      MESSAGE4_LINE_COUNT
,      MESSAGE5_LINE_COUNT
,      MESSAGE6_LINE_COUNT
,      MESSAGE7_LINE_COUNT
,      MESSAGE8_LINE_COUNT
,      REQUEST_ID
,      SITE_USE_ID
,      STATEMENT_TYPE
,      BILL_TO_LOCATION
,      CREDIT_BALANCE_STATEMENTS
,      CUST_CUSTOMER_PROFILE_ID
,      MIN_STATEMENT_AMOUNT
,      MONTHLY_INTEREST_RATE
,      SITE_CUSTOMER_PROFILE_ID
FROM AR.AR_STATEMENT_HEADERS#;

Dependencies

[top of page]

AR.AR_STATEMENT_HEADERS# references the following:

SchemaAR
TableAR_STATEMENT_HEADERS
AR.AR_STATEMENT_HEADERS# is referenced by following:

SchemaAPPS
SynonymAR_STATEMENT_HEADERS