Bi_FactPettyCashDetails_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
Amount | NUMERIC(19,4) | The amount associated with the petty cash transaction. | |||
CashRegisterCode | NVARCHAR(256) | The unique code of the cash register associated with the petty cash transaction. | |||
CashRegisterId | VARCHAR(36) | A unique identifier for the cash register associated with the petty cash transaction. | Bi_DimCashRegister_s3 CashRegisterId | ||
CashRegisterName | NVARCHAR(2048) | The name of the cash register associated with the petty cash transaction. | |||
CategoryDescription | NVARCHAR(1600) | The description of the category associated with the petty cash transaction. | |||
CategoryId | VARCHAR(36) | A unique identifier for the category associated with the petty cash transaction. | |||
CategoryName | NVARCHAR(400) | The category associated with the petty cash transaction. | |||
CenterId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 CenterId | ||
ClosingBalance | NUMERIC(19,4) | The closing balance of the petty cash register after the corresponding transaction. | |||
EnteredOn | TIMESTAMP | The timestamp at which the petty cash transaction occurred. | |||
EntryId | VARCHAR(36) | A unique identifier for the petty cash transaction. | |||
EntryType | NVARCHAR(200) | An indicator of whether the transaction is a receipt or an expense. | |||
EntryTypeID | BOOLEAN | An identifier for the entry type. | |||
EtlCreatedBy | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
EtlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FactSegmentID | INT | A unique identifier(integer value) for each record generated in the fact table. | Yes | ||
LastUpdated | TIMESTAMP | The timestamp at which the petty cash transaction is last updated. Transactions may get updated for various reasons such as to change description details or to void entries or to backdate entries. | |||
OpeningBalance | NUMERIC(19,4) | The opening balance of the petty cash register prior to the corresponding transaction. | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
PettyCashDescription | NVARCHAR(1600) | The description of the petty cash transaction. | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
ReportingDate | DATE | It is possible to enter petty cash transactions for previous days. For example, a transaction occurred on March 1st. But the employee forgot to enter it on March 1st and instead entered it on March 5th. On March 5th, the employee can choose to set the reporting date for the transaction as March 1st. In this case: reporting date = March 1 entered on = March 1 10:55:14 last updated = March 5 10:55:24 | |||
ReversalAmount | NUMERIC(19,4) | The amount which is reversed from petty cash. This is populated for voided transactions. | |||
ReversalEnteredOn | TIMESTAMP | The timestamp at which the reversal entry occurred. This is populated for voided transactions. | |||
salebyid | VARCHAR(36) | A unique identifier of the employee who made the sale(bi_dimuser). | Bi_Dimuser_s3 userid | ||
Source | NVARCHAR(200) | This field indicates the source of a Petty Cash Receipt. Possible Values: - Business Cash: Indicates that the receipt was due to a transfer of cash from Business Cash to the Petty Cash Register. - Other: Indicates that the receipt was from a source other than Business Cash. For Petty Cash Expenses, this field as populated as 'Other' by default. | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
Void_Custom | INT | Indicates whether a petty cash transaction is voided or not. When an existing transaction is voided, this field gets updated for that transaction along with 'reversal amount' to negate the original transaction. - 1: Void transaction - 0: Valid transaction | |||
VoucherNo | NVARCHAR(160) | A voucher number associated with the petty cash transaction. This is unique within receipts and unique within expenses, but it may not be unique across both together. | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||