title: "Package (table)" category: reference tags: [table, package, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Package
Schema: dba
Aantal kolommen: 21
Zie ook de entity-pagina: ../entities/Package
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
PacId |
nvarchar(36) | Nee | — | — |
PacContext |
bigint | Nee | ((0)) | — |
PacRecStatus |
int | Nee | ((0)) | — |
PacCreateDate |
datetimeoffset(7) | Ja | — | — |
PacCurrentUserId |
nvarchar(50) | Ja | — | — |
PacCustomer |
nvarchar(200) | Ja | — | — |
PacEmpDescr |
nvarchar(200) | Ja | — | — |
PacExported |
smallint | Nee | ((0)) | — |
PacFileName |
nvarchar(34) | Ja | — | — |
PACKIND |
smallint | Nee | ((0)) | — |
PacModifyDate |
datetimeoffset(7) | Ja | — | — |
PacOriginDTAP |
nvarchar(50) | Ja | — | — |
PacOriginLocation |
nvarchar(200) | Ja | — | — |
PacOwner |
nvarchar(100) | Ja | — | — |
PacRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
PacRefCodeA |
nvarchar(50) | Ja | — | — |
PacRefCodeB |
nvarchar(50) | Ja | — | — |
PacRemarks |
nvarchar(max) | Ja | — | — |
PacState |
smallint | Nee | ((0)) | — |
PacTitle |
nvarchar(200) | Ja | — | — |
PacUserId |
nvarchar(50) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("Package")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Package")· ../entities/Package Properties, contexts, statussen. Bron:Entities.xml.