AP_STATEMENT_LINES
This table contains information about the statement lines.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: ap_statement_lines
Primary Key
| Name | Columns |
|---|---|
|
ap_statement_lines_PK |
STATMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STATMENT_LINE_ID | NUMBER | 18 | Yes | Identifier of the statement line. | |
| STATEMENT_HEADER_ID | NUMBER | 18 | 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 | 18 | Application that processes the statement. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Scheduler: request identifier of the interface load job that created the row. | ||
| PAYMENT_REFERENCE_NUMBER | VARCHAR2 | 240 | Payment reference number of the original transaction. | ||
| ORIGINAL_CURRENCY_CODE | VARCHAR2 | 30 | Currency code of the amount in statement line. | ||
| ORIGINAL_CURRENCY_AMOUNT | NUMBER | Original amount in the statement. | |||
| TRANSACTION_DATE | DATE | Date when the transaction is processed by supplier. | |||
| POSTED_DATE | DATE | Date when the transaction is posted on the customer account. | |||
| POSTED_CURRENCY_CODE | VARCHAR2 | 30 | Currency code of the transactions posted on the customer account. | ||
| POSTED_AMOUNT | NUMBER | Transaction amount in posted currency. | |||
| POSTED_EXCHANGE_RATE | NUMBER | 18 | Factor used to convert an amount from transaction to posted currency. | ||
| POSTED_EXCHANGE_TYPE | VARCHAR2 | 30 | Rate type for the posted rate in statement line. | ||
| POSTED_EXCHANGE_RATE_DATE | DATE | Date and time when the posted rate is quoted. | |||
| BILLING_DATE | DATE | Date and time when the transaction is billed | |||
| BILLING_CURRENCY_CODE | VARCHAR2 | 30 | Currency code of the transactions billed to the customer account. | ||
| BILLING_AMOUNT | NUMBER | Transaction amount in billed currency. | |||
| BILLING_EXCHANGE_RATE | NUMBER | 18 | Factor used to convert an amount from transaction to billed currency. | ||
| BILLING_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type for the billed rate in statement line. | ||
| BILLING_EXCHANGE_RATE_DATE | DATE | Date and time when the billed rate is quoted. | |||
| TRANSACTION_ID | NUMBER | 18 | Alphanumeric code that identifies transaction. | ||
| DEBIT_CREDIT_INDICATOR | VARCHAR2 | 30 | Indicates whether the line amount is positive or negative. Positive amount implies a credit whereas negative amount indicates a debit. | ||
| TRANSACTION_CODE | VARCHAR2 | 30 | Transaction code given in the statement. | ||
| ADDITIONAL_CURRENCY_CODE | VARCHAR2 | 30 | Currency code of the statement line amount. | ||
| ADDITIONAL_AMOUNT1 | NUMBER | Amount in statement line currency. | |||
| ADDITIONAL_AMOUNT2 | NUMBER | Amount in statement line currency. | |||
| ADDITIONAL_AMOUNT3 | NUMBER | Amount in statement line currency. | |||
| EXCHANGE_RATE | NUMBER | Factor used to convert an amount from one currency to another. | |||
| EXCHANGE_RATE_DATE | DATE | Date and time when the rate is quoted. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 80 | Rate type in the statement line. | ||
| LINE_DATE1 | DATE | Yes | Date field for referred statement line. | ||
| LINE_DATE2 | DATE | Date field for referred statement line. | |||
| LINE_DATE3 | DATE | Date field for referred statement line. | |||
| LINE_DATE4 | DATE | Date field for referred statement line. | |||
| LINE_DATE5 | DATE | Date field for referred statement line. | |||
| LINE_ATTRIBUTE1 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE2 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE3 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE4 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE5 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE6 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE7 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE8 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE9 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE10 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE11 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE12 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE13 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE14 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE15 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE16 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE17 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE18 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE19 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE20 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE21 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE22 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE23 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE24 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE25 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE26 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE27 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE28 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE29 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE30 | VARCHAR2 | 150 | Additional Alphanumeric field for referred statement line. | ||
| LINE_ATTRIBUTE_DATE1 | DATE | Additional date field for referred statement line. | |||
| LINE_ATTRIBUTE_DATE2 | DATE | Additional date field for referred statement line. | |||
| LINE_ATTRIBUTE_DATE3 | DATE | Additional date field for referred statement line. | |||
| LINE_ATTRIBUTE_DATE4 | DATE | Additional date field for referred statement line. | |||
| LINE_ATTRIBUTE_DATE5 | DATE | Additional date field for referred statement line. | |||
| LINE_ATTRIBUTE_NUMBER1 | NUMBER | 18 | Additional number field for referred statement line. | ||
| LINE_ATTRIBUTE_NUMBER2 | NUMBER | 18 | Additional number field for referred statement line. | ||
| LINE_ATTRIBUTE_NUMBER3 | NUMBER | 18 | Additional number field for referred statement line. | ||
| LINE_ATTRIBUTE_NUMBER4 | NUMBER | 18 | Additional number field for referred statement line. | ||
| LINE_ATTRIBUTE_NUMBER5 | NUMBER | 18 | Additional number field for referred statement line. | ||
| LINE_INFO1 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO2 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO3 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO4 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO5 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO6 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO7 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO8 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO9 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO10 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO11 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO12 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO13 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO14 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO15 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO16 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO17 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO18 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO19 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| LINE_INFO20 | VARCHAR2 | 150 | Alphanumeric field for referred statement line. | ||
| 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_lines | STATEMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ap_statement_lines_N1 | Non Unique | default | LOAD_REQUEST_ID |
| ap_statement_lines_N2 | Non Unique | default | STATEMENT_HEADER_ID, PAYMENT_REFERENCE_NUMBER |
| ap_statement_lines_N3 | Non Unique | default | PROCESS_STATUS_CODE, APPLICATION_ID |
| ap_statement_lines_U1 | Unique | ap_statement_lines_U1 | STATMENT_LINE_ID |