FV_TREASURY_CONFIRM_ALL
This table contains payments confirmed in the treasury confirmation.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_TREASURY_CONFIRM_ALL_PK |
TREASURY_CONFIRMATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BU_ID | NUMBER | 18 | Yes | Unique identifier for the business unit associated to the treasury confirmation. | |
| NUMBER_OF_PAYMENTS | NUMBER | 18 | Yes | Number of payments made for the payment instruction. | |
| REVISION_NUM | NUMBER | 18 | Yes | Revision number for the treasury confirmation record. | |
| TREASURY_CONFIRMATION_ID | NUMBER | 18 | Yes | Unique identifier for the treasury confirmation. | |
| PAYMENT_ACCOUNTED_CODE | VARCHAR2 | 30 | Yes | Indicates the accounting status of the payments. Valid values can be Accounted, Unaccounted, and Partially Accounted. | |
| PAYMENT_INSTRUCTION_ID | NUMBER | 18 | Yes | Unique identifier for the Payment Instruction. | |
| TREASURY_CONFIRM_DATE | DATE | The date that Treasury confirmed the payment schedule. | |||
| TREASURY_AMOUNT | NUMBER | Yes | Payment process request amount. | ||
| RANGE_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates whether the range applies to a single paymnet or a range of payments. The value will be one of the look up codes from lookup type ORA_FV_PAYMENT_RANGE_TYPE and valid values are Single, Multiple. | |
| FROM_CHECK_NUM | NUMBER | 18 | The from range number for the single range type. | ||
| TO_CHECK_NUM | NUMBER | 18 | The to range number for the single range type. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status of treasury confirmation. Valid values include Confirmed, Unconfirmed, and Backed Out. | |
| CONFIRMED_EVENT_ID | NUMBER | 18 | Unique identifier for the latest subledger accounting confirmation event. | ||
| BACKOUT_EVENT_ID | NUMBER | 18 | This column is not currently used for Treasury Confirmation. | ||
| CONFIRMED_ACCOUNTED_FLAG | VARCHAR2 | 1 | Indicates whether the latest treasury confirmed accounting is complete. | ||
| BACKOUT_ACCOUNTED_FLAG | VARCHAR2 | 1 | This column is not currently used for Treasury Confirmation. | ||
| CONTROL_NUMBER | VARCHAR2 | 7 | Unique Id assigned by the Treasury. | ||
| SUBMITTED_DATE | TIMESTAMP | Date and time of the summary schedule submission. | |||
| FEDERAL_PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Identifies file type of the payment, PAM or SLS. | ||
| PAYMENT_GROUP_CODE | VARCHAR2 | 30 | Groups a category of suppliers or invoices for single pay run. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates the method of payment, such as check, electronic, or wire. | ||
| AGENCY_LOCATION_CODE | VARCHAR2 | 30 | Identifier for the accounting office within an agency that reports disbursements and collections to Treasury. | ||
| PAYMENT_PROCESS_REQUEST_NAME | VARCHAR2 | 255 | Name of payment process request submitted. | ||
| SCHEDULE_DATE | DATE | Indicates the date of the creation of the row. | |||
| PAYMENT_DATE | DATE | Payment date of payments generated for given check run. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FV_TREASURY_CONFIRM_ALL_N1 | Non Unique | FUSION_TS_TX_DATA | PAYMENT_INSTRUCTION_ID |
| FV_TREASURY_CONFIRM_ALL_N2 | Non Unique | FUSION_TS_TX_IDX | FEDERAL_PAYMENT_TYPE_CODE, STATUS_CODE |
| FV_TREASURY_CONFIRM_ALL_U1 | Unique | FUSION_TS_TX_DATA | TREASURY_CONFIRMATION_ID |