Alias: DGV#
Unique Keys: _Child Table: _
Parent Table: _
Government Registration Number and Type.
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| DEN_ID | Number(10) | ID | Y | link to P2K_CM_ENTITIES |
| GOVT_REGIST_TYPE | Varchar2(4) | X_GOVT_REGIST_TYPE | Y | |
| DCN_ID | Number(10) | ID | link to P2K_CM_COUNTIES | |
| DSP_ID | Number(10) | ID | link to P2K_CM_STATE_PROVINCES | |
| DSD_ID | Number(10) | ID | link to P2K_CM_SCHOOL_DISTRICTS | |
| DTX_ID | Number(10) | ID | link to P2K_CM_TAX_JURISDICTIONS | |
| DCO_ID | Number(10) | ID | link to P2K_CM_COUNTRIES | |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| GOVT_REGIST_NUMBER | Varchar2(30) | VARCHAR30 | ||
| DISTRIBUTION_DR_MASK | Varchar2(50) | DISTRIBUTION | ||
| DISTRIBUTION_CR_MASK | Varchar2(50) | DISTRIBUTION | ||
| DGVS_ID | Number(10) | ID | Y | link to P2K_CM_GOVT_REGIST_SETS |
| DCI_ID | Number(10) | ID | Y | link to P2K_CM_CITIES |
| DMN_ID | Number(10) | ID | Y | link to P2K_CM_MUNICIPALITIES |
| ADP_TAX_CODE | Varchar2(30) | X_ADP_TAX_CODE |
Derived Fields#
| Column Name |
|---|
| DRV_REGISTRATION_FOR |
User Fields: Allowed
Audit Logging: Allowed
