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 |