Financial Data Available Table
This table stores header information about each transaction and contains source entity and database data.
Table 4. The Financial Data Available Table
Attribute | Data Type | Definition |
|---|
Transaction Id | bigint | Identifies the transaction |
Checked In User Id | varchar | The last user to check the entity in to the server |
Data Available Dt | datetime | The data that is available |
Alcar Db | varchar | The source Strategic Finance database |
Entity Id | int | Identifies the entity |
Entity Name | varchar | The entity name |
Records Expected | int | The records that should be present |
Transaction State Cd | char | The transaction state |
Transaction Error Cd | int | Errors |
Transaction Type | char | The transaction type |
Parent Transaction Id | varchar | The transaction ID related to the parent entity |