AP_STATEMENT_HEADERS
This table contains information about the statement headers. test
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: ap_statement_headers
Primary Key
| Name | Columns |
|---|---|
|
ap_statement_headers_PK |
STATEMENT_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STATEMENT_HEADER_ID | NUMBER | Yes | Identifier of the statement header. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | Yes | Statement status after program completion. Values based on the lookup type ORA_AP_STATEMENT_PROCESS_STATUS. | |
| APPLICATION_ID | NUMBER | Application that processes the statement. | |||
| LOAD_REQUEST_ID | NUMBER | Enterprise Scheduler: request identifier of the interface load job that created the row. | |||
| SOURCE_FILE_NAME | VARCHAR2 | 255 | Name of the file ingested in the table. | ||
| SOURCE_SYS_DOC_REF_NUMBER | VARCHAR2 | 240 | Reference number of file from source system. | ||
| STATEMENT_ACCOUNT_NUMBER | VARCHAR2 | 150 | Account on the issued statement. | ||
| STATEMENT_DATE | DATE | Date when the statement is issued. | |||
| STATEMENT_FROM_DATE | DATE | Start date or time of the statement billing cycle. | |||
| STATEMENT_TO_DATE | DATE | End date or time of the statement billing cycle. | |||
| PAYMENT_DUE_DATE | DATE | Indicates the payment due date. | |||
| CREDIT_BALANCE_AMOUNT | NUMBER | Credit balance amount in statement currency. | |||
| AVAILABLE_CREDIT_AMOUNT | NUMBER | Available credit amount in statement currency. | |||
| MINIMUM_PAYMENT_DUE_AMT | NUMBER | Minimum payment amount in statement currency. | |||
| PAST_DUE_AMOUNT | NUMBER | Past due amount in statement currency. | |||
| PREVIOUS_STATEMENT_BLANCE_AMT | NUMBER | Previous statement balance amount in statement currency. | |||
| TOTAL_NEW_BALANCE_AMOUNT | NUMBER | Total new balance amount in statement currency. | |||
| TOTAL_CHARGES_AMOUNT | NUMBER | Total charges amount in statement currency. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Previous statement balance amount in statement currency. | ||
| AMOUNT1 | NUMBER | Indicates amount in statement currency. | |||
| AMOUNT2 | NUMBER | Indicates amount in statement currency. | |||
| AMOUNT3 | NUMBER | Indicates amount in statement currency. | |||
| AMOUNT4 | NUMBER | Indicates amount in statement currency. | |||
| AMOUNT5 | NUMBER | Indicates amount in statement currency. | |||
| STATEMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE6 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE7 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE8 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE9 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE10 | VARCHAR2 | 150 | Additional alphanumeric field for referred statement. | ||
| STATEMENT_ATTRIBUTE_DATE1 | DATE | Additional date field for referred statement. | |||
| STATEMENT_ATTRIBUTE_DATE2 | DATE | Additional date field for referred statement. | |||
| STATEMENT_ATTRIBUTE_DATE3 | DATE | Additional date field for referred statement. | |||
| STATEMENT_ATTRIBUTE_DATE4 | DATE | Additional date field for referred statement. | |||
| STATEMENT_ATTRIBUTE_DATE5 | DATE | Additional date field for referred statement. | |||
| STATEMENT_ATTRIBUTE_NUMBER1 | NUMBER | 18 | Additional number field for referred statement. | ||
| STATEMENT_ATTRIBUTE_NUMBER2 | NUMBER | 18 | Additional number field for referred statement. | ||
| STATEMENT_ATTRIBUTE_NUMBER3 | NUMBER | 18 | Additional number field for referred statement. | ||
| STATEMENT_ATTRIBUTE_NUMBER4 | NUMBER | 18 | Additional number field for referred statement. | ||
| STATEMENT_ATTRIBUTE_NUMBER5 | NUMBER | 18 | Additional number field for referred statement. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ap_statement_lines | ap_statement_headers | STATEMENT_HEADER_ID |
| ap_statement_import_errors | ap_statement_headers | STATEMENT_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ap_statement_headers_N1 | Non Unique | default | LOAD_REQUEST_ID |
| ap_statement_headers_N2 | Non Unique | default | PROCESS_STATUS_CODE, APPLICATION_ID |
| ap_statement_headers_U1 | Unique | ap_statement_headers_U1 | STATEMENT_HEADER_ID |