1. Tables and Views for Financials
  2. AR_STATEMENT_HEADERS

AR_STATEMENT_HEADERS

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.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

AR_STATEMENT_HEADERS_PK

SEND_TO_ADDRESS_ID, CUSTOMER_ID

Columns

Name Datatype Length Precision Not-null Comments
LINE_CLUSTER_ID NUMBER 18 Yes Identifier for the line cluster
SEND_TO_ADDRESS_ID NUMBER 18 Yes Identifier for the send-to address
CUSTOMER_ID NUMBER 18 Yes Customer identifier.
REMIT_TO_ADDRESS_ID NUMBER 18 Yes Identifier for the remit-to address
STATEMENT_DATE DATE Yes Date when the statement is generated.
CURRENCY_CODE VARCHAR2 15 Currency of transactions on statement.
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 in aging bucket 1.
BUCKET2 NUMBER Yes Total amount in aging bucket 2.
BUCKET3 NUMBER Yes Total amount in aging bucket 3.
BUCKET4 NUMBER Yes Total amount in aging bucket 4.
BUCKET5 NUMBER Yes Total amount in aging 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. Used for internal processing.
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 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SITE_USE_ID NUMBER 18 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 150 Bill to location that appears on statement.
CREDIT_BALANCE_STATEMENTS VARCHAR2 1 Y if credit-balance statements are sent to this site, otherwise N
CUST_CUSTOMER_PROFILE_ID NUMBER 18 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 Interest rate defined for the customer at the statement site. When there is no statement site, the rate comes from the bill to site.
SITE_CUSTOMER_PROFILE_ID NUMBER 18 Site level profile identifier, foreign key to the AR_CUSTOMER_PROFILES table
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
REMIT_TO_ADDRESS_SEQ_ID NUMBER 18 Yes Remit-to address sequence identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_STATEMENT_HEADERS hz_cust_acct_sites_all SEND_TO_ADDRESS_ID
AR_STATEMENT_HEADERS hz_cust_site_uses_all SITE_USE_ID
AR_STATEMENT_HEADERS hz_cust_accounts CUSTOMER_ID
AR_STATEMENT_HEADERS ra_remit_tos_all REMIT_TO_ADDRESS_ID

Indexes

Index Uniqueness Tablespace Columns
AR_STATEMENT_HEADERS_N1 Non Unique Default LINE_CLUSTER_ID