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

TABLE: AR.AR_STATEMENT_HEADERS

Object Details
Object Name: AR_STATEMENT_HEADERS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_STATEMENT_HEADERS
Subobject Name:
Status: VALID


The AR_STATEMENT_HEADERS table is an interim table that Oracle Receivables uses when generating statements. The Print Statements program uses this table to store one row for each statement that the program will eventually produce. Each row is distinguished by a bill-to site and currency combination.
.
The primary keys for this table are SEND_TO_ADDRESS_ID and CUSTOMER_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_STATEMENT_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_CLUSTER_ID
AR_STATEMENT_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEND_TO_ADDRESS_ID
ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
LINE_CLUSTER_ID NUMBER (15) Yes Identifier for the line cluster
SEND_TO_ADDRESS_ID NUMBER (15) Yes Identifier for the send-to address
CUSTOMER_ID NUMBER (15) Yes Identifier for the customer
REMIT_TO_ADDRESS_ID NUMBER (15) Yes Identifier for the remit-to address
STATEMENT_DATE DATE
Yes Statement date
CURRENCY_CODE VARCHAR2 (15)
Currency code
BUCKET1_HEADING VARCHAR2 (30)
Heading for the corresponding bucket
BUCKET2_HEADING VARCHAR2 (30)
Heading for the corresponding bucket
BUCKET3_HEADING VARCHAR2 (30)
Heading for the corresponding bucket
BUCKET4_HEADING VARCHAR2 (30)
Heading for the corresponding bucket
BUCKET5_HEADING VARCHAR2 (30)
Heading for the corresponding bucket
BUCKET1 NUMBER
Yes Total amount for bucket 1
BUCKET2 NUMBER
Yes Total amount for bucket 2
BUCKET3 NUMBER
Yes Total amount for bucket 3
BUCKET4 NUMBER
Yes Total amount for bucket 4
BUCKET5 NUMBER
Yes Total amount for bucket 5
FINANCE_CHARGES NUMBER
Yes Total amount of finance charges that the customer owes the company
TOTAL_AMOUNT_DUE NUMBER
Yes Total amount due
ERROR_AMOUNT_DIFFERENT VARCHAR2 (1) Yes Y if the customer has a calculated amount due that is different from the amount due remaining, otherwise N
ERROR_NO_SEND_TO VARCHAR2 (1) Yes Y if the customer does not have a send-to address, otherwise N
ERROR_NO_REMIT_TO VARCHAR2 (1) Yes Y if the customer does not have a remit-to address, otherwise N
ERROR_NO_LINES VARCHAR2 (1) Yes Always set to N
MESSAGE1 NUMBER

Identifier for standard message 1, foreign key to the AR_STANDARD_TEXT table
MESSAGE2 NUMBER

Identifier for standard message 2, foreign key to the AR_STANDARD_TEXT table
MESSAGE3 NUMBER

Identifier for standard message 3, foreign key to the AR_STANDARD_TEXT table
MESSAGE4 NUMBER

Identifier for standard message 4, foreign key to the AR_STANDARD_TEXT table
MESSAGE5 NUMBER

Identifier for standard message 5, foreign key to the AR_STANDARD_TEXT table
MESSAGE6 NUMBER

Identifier for standard message 6, foreign key to the AR_STANDARD_TEXT table
MESSAGE7 NUMBER

Identifier for standard message 7, foreign key to the AR_STANDARD_TEXT table
MESSAGE8 NUMBER

Identifier for standard message 8, foreign key to the AR_STANDARD_TEXT table
MESSAGE1_LINE_COUNT NUMBER

Number of lines that are required to print standard message 1
MESSAGE2_LINE_COUNT NUMBER

Number of lines that are required to print standard message 2
MESSAGE3_LINE_COUNT NUMBER

Number of lines that are required to print standard message 3
MESSAGE4_LINE_COUNT NUMBER

Number of lines that are required to print standard message 4
MESSAGE5_LINE_COUNT NUMBER

Number of lines that are required to print standard message 5
MESSAGE6_LINE_COUNT NUMBER

Number of lines that are required to print standard message 6
MESSAGE7_LINE_COUNT NUMBER

Number of lines that are required to print standard message 7
MESSAGE8_LINE_COUNT NUMBER

Number of lines that are required to print standard message 8
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SITE_USE_ID NUMBER (15) Yes Site use identifier, foreign key to the RA_SITE_USES_ALL table
STATEMENT_TYPE VARCHAR2 (30) Yes Indicates if the statement that is generated is sent to a statement or bill-to site
BILL_TO_LOCATION VARCHAR2 (40)
Bill-to location
CREDIT_BALANCE_STATEMENTS VARCHAR2 (1)
Y if credit-balance statements are sent to this site, otherwise N
CUST_CUSTOMER_PROFILE_ID NUMBER (15)
Customer level profile identifier, foreign key to the AR_CUSTOMER_PROFILES table
MIN_STATEMENT_AMOUNT NUMBER

Minimum statement amount for statements to be printed
MONTHLY_INTEREST_RATE NUMBER

Period interest rate
SITE_CUSTOMER_PROFILE_ID NUMBER (15)
Site level profile identifier, foreign key to the AR_CUSTOMER_PROFILES table
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 does not reference any database object

AR.AR_STATEMENT_HEADERS is referenced by following:

SchemaAPPS
SynonymAR_STATEMENT_HEADERS