UBoard Data Dictionary - Legal Query
Data Dictionary – Legal Query
VIEW_DATA_AKTA
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Id |
int8 |
64 |
sbx_legalquery.akta_v2 |
Document Id |
23 |
|
Title |
varchar(100) |
100 |
sbx_legalquery.akta_v2 |
Document Title |
AKTA - 14 |
|
TanggalAkta |
timestamp |
sbx_legalquery.akta_v2 |
Document Date |
2004-02-26 17:00:00.000 |
||
Keterangan |
varchar(500) |
500 |
sbx_legalquery.akta_v2 |
Document Description |
<p><br></p> |
|
PesertaHadir |
varchar(500) |
500 |
sbx_legalquery.akta_v2 |
Attendants |
<p>Stefanus Najoan</p><p><br></p> |
|
AgendaRapat |
varchar(500) |
500 |
sbx_legalquery.akta_v2 |
Meeting Agenda |
<p>Pendirian</p> |
|
NoAkta |
int4 |
32 |
sbx_legalquery.akta_v2 |
Deed Number |
14 |
|
PesertaHadirAttendants |
varchar(500) |
500 |
sbx_legalquery.akta_v2 |
Attendants |
<ol><li>Stefanus Najoan</li><li>Amin Supriyadi</li><li>Stefanus Najoan</li><li>Yonggi Tanuwidjaja</li></ol><p><br></p> |
|
Location |
varchar(100) |
100 |
sbx_legalquery.akta_v2 |
Meeting Location |
[NULL] |
|
Judul |
varchar(100) |
100 |
sbx_legalquery.judulakta |
Deed Title |
Akta Pendirian |
|
NotarisName |
varchar(100) |
100 |
sbx_legalquery.notaris |
Notary Name |
Hannywati Gunawan, S.H. |
|
NotarisLocation |
varchar(50) |
50 |
sbx_legalquery.notaris |
Notary Location |
Jakarta |
|
JenisAkta |
varchar(100) |
100 |
sbx_legalquery.jenisakta |
Types of Deeds |
[NULL] |
|
CompanyName |
varchar(100) |
100 |
sbx_legalquery.companylist |
Company Name |
Manggala Alam Lestari |
|
KBLIDesc |
varchar(100) |
100 |
sbx_legalquery.kbli |
KBLI Description |
[NULL] |
|
GroupName |
varchar(100) |
100 |
sbx_legalquery.groupcompany |
Group Name |
Andalan Satria Lestari |
|
Status |
varchar(50) |
50 |
sbx_legalquery.akta_v2 |
Deed Status |
Draft |
|
Created |
timestamp |
sbx_legalquery.akta_v2 |
Created Date |
2023-02-15 02:57:30.000 |
||
Modified |
timestamp |
sbx_legalquery.akta_v2 |
Modified Date |
2023-02-15 02:57:30.000 |
||
GUID |
varchar(500) |
sbx_legalquery.akta_v2 |
GUID |
f4127f56-8145-45f5-9da8-e27b457cc830 |
||
AttachmentId |
int8 |
64 |
sbx_legalquery.aktaattachment |
Attachment Id |
[NULL] |
|
AttachmentName |
varchar(100) |
100 |
sbx_legalquery.aktaattachment |
Attachment Name |
[NULL] |
|
AttachmentUrl |
text |
sbx_legalquery.aktaattachment |
Attachment Url |
<i>No Attachment</i> |
VIEW_DATA_AKTA_ANGGARAN_DASAR
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
AnggaranDasarId |
int8 |
64 |
sbx_legalquery.aktapasal |
Articles of Association Id |
523 |
|
Pasal |
varchar(100) |
100 |
sbx_legalquery.anggarandasar |
Articles |
Waktu |
|
Keterangan |
varchar(10000) |
10000 |
sbx_legalquery.aktapasal |
Articles Decsription |
75 tahun sejak AD disetujui dan disahkan oleh yang berwajib |
|
NoAkta |
int4 |
32 |
sbx_legalquery.akta_v2 |
Deed Number |
79 |
|
Id |
int8 |
64 |
sbx_legalquery.akta_v2 |
Deed Id |
18 |
VIEW_DATA_AKTA_MODAL_SAHAM
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
ModalSahamId |
int8 |
64 |
sbx_legalquery.aktamodalsaham |
Share Capital Id |
133 |
|
ModalDasar |
int8 |
64 |
sbx_legalquery.aktamodalsaham |
Authorized Capital |
800.000.000 |
|
ModalDisetor |
int8 |
64 |
sbx_legalquery.aktamodalsaham |
Paid-up Capital |
800000000 |
|
PemegangSaham |
varchar(100) |
100 |
sbx_legalquery.modalsahamkontributor |
Shareholder |
Melyani Sumargo |
|
JumlahLembar |
int8 |
64 |
sbx_legalquery.modalsahamkontributor |
Number of Shares |
80 |
|
Nilai |
int8 |
64 |
sbx_legalquery.modalsahamkontributor |
Share Value |
80000000 |
|
Persentase |
int8 |
64 |
sbx_legalquery.modalsahamkontributor |
Percentage |
10 |
|
TotalLembar |
int8 |
64 |
sbx_legalquery.modalsahamseries |
Total Shares |
800 |
|
TotalNominal |
int8 |
64 |
sbx_legalquery.modalsahamseries |
Total Nominal |
1000000 |
|
NoAkta |
int4 |
32 |
sbx_legalquery.akta_v2 |
Deed Number |
79 |
|
Id |
int8 |
64 |
sbx_legalquery.akta_v2 |
Deed Id |
18 |
VIEW_DATA_AKTA_PENGURUS
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
PengurusId |
int8 |
64 |
sbx_legalquery.aktapengurus |
Management Id |
757 |
|
Pengurus |
varchar(500) |
500 |
sbx_legalquery.aktapengurus |
Management Information |
GE Haryanto (KTP: 6371050804570001) |
|
NamaPengurus |
varchar(100) |
100 |
sbx_legalquery.libraries |
Management Name |
GE Haryanto |
|
DueDate |
timestamp |
sbx_legalquery.aktapengurus |
Due Date |
1999-06-23 17:00:00.000 |
||
Jabatan |
varchar(100) |
100 |
sbx_legalquery.aktapengurus |
Position |
Direktur Utama |
|
JabatanAlias |
varchar(500) |
500 |
sbx_legalquery.jabatanlist |
Position Alias |
Direktur Utama |
|
NoAkta |
int4 |
32 |
sbx_legalquery.akta_v2 |
Deed Number |
79 |
|
Id |
int8 |
64 |
sbx_legalquery.akta_v2 |
Deed Id |
18 |