Your request has been successfully submitted
You will receive a confirmation within 14days time period. If you are
having any query feel free to contact us.
having any query feel free to contact us.
Done
| Field | Value | ||||||
|---|---|---|---|---|---|---|---|
| Data Provenance | 1. The Payment vouchers details are generated from Building Permit System during voucher creation. 2. Reference tables are prmt_chrg_hdr,prmt_chrg_dtls3.This dataset should be combined with 'Payment Vouchers' | ||||||
| Tags / Keywords | |||||||
| Dataset Source | Relational Database | ||||||
| Language | |||||||
| Remarks/Special Business Rules | N/A | ||||||
|
Coverage (Geographic area)
|
|||||||
|
Dataset Temporal Windows
|
INSUPD
|
||||||
|
Rights
|
|||||||
|
Frequency of Update on Source
|
RealTime
|
||||||
|
Frequency of Update to SDP
|
Monthly
|
||||||
|
Expected Volume/Ingestion Cycle(Daily if Real-time)
|
800 records monthly
|
||||||
|
Source Platform Type
|
Oracle DB
|
||||||
|
Already Shared?
|
no
|
||||||
|
If Shared, with which Entities?
|
|||||||
|
Already Published?
|
No
|
||||||
|
If Published, where?
|
|||||||
| Show more | |||||||
| Attribute Name | Attribute Description | Attribute Language | Attribute Classification | Attribute Datatype | Attribute Size | Attribute Range of Values | Attribute Foreign Key |
|---|---|---|---|---|---|---|---|
| voucher_details_id | Primary key of the data set | English | Open | numeric | 22 | No | |
| voucher_no | Payment voucher number | English | Open | nvarchar | 100 | No | |
| voucher_header_id | FK to connect ''Payment Voucher'' dataset | English | Open | numeric | 22 | Yes | |
| charge_type | charge type description | English | Open | nvarchar | 100 | No | |
| ledger_id | financial ledger id | English | Open | nvarchar | 50 | No | |
| ledger_description | financial ledger description | English | Open | nvarchar | 500 | No | |
| line_amount | Voucher line amout | English | Open | numeric | 22 | No | |
| Show more Show less | |||||||