title: "Receipt (table)" category: reference tags: [table, receipt, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Receipt
Schema: dba
Aantal kolommen: 33
Zie ook de entity-pagina: ../entities/Receipt
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
RcpId |
nvarchar(9) | Nee | — | — |
RcpDescr |
nvarchar(200) | Ja | — | — |
RcpContext |
bigint | Nee | ((1)) | — |
RcpRecStatus |
int | Nee | ((0)) | — |
RcpApprvDate |
datetimeoffset(7) | Ja | — | — |
RcpApprvEmpId |
nvarchar(9) | Ja | — | — |
RcpCompId |
nvarchar(6) | Nee | — | — |
RcpCurConvFactor |
smallint | Nee | ((0)) | — |
RcpCurId |
nvarchar(5) | Nee | — | — |
RcpCurRate |
decimal(21,5) | Nee | ((0)) | — |
RcpDataProvider |
nvarchar(50) | Ja | — | — |
RcpDate |
datetimeoffset(7) | Ja | — | — |
RcpExported |
smallint | Nee | ((0)) | — |
RcpExternalId |
nvarchar(50) | Ja | — | — |
RcpExternalStatus |
nvarchar(50) | Ja | — | — |
RcpExtra1 |
smallint | Nee | ((0)) | — |
RcpExtra2 |
smallint | Nee | ((0)) | — |
RcpExtra3 |
int | Nee | ((0)) | — |
RcpExtra4 |
int | Nee | ((0)) | — |
RcpExtra5 |
nvarchar(15) | Ja | — | — |
RcpExtra6 |
nvarchar(15) | Ja | — | — |
RcpExtra7 |
nvarchar(15) | Ja | — | — |
RcpPackingSlip |
nvarchar(20) | Ja | — | — |
RcpPchId |
nvarchar(10) | Ja | — | — |
RcpPreApprvDate |
datetimeoffset(7) | Ja | — | — |
RcpPreApprvEmpId |
nvarchar(9) | Ja | — | — |
RcpProviderMutDate |
datetimeoffset(7) | Ja | — | — |
RcpRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
RcpSitId |
nvarchar(8) | Ja | — | — |
RcpText |
nvarchar(max) | Ja | — | — |
RcpTransferNextTime |
smallint | Nee | ((0)) | — |
RcpVdrId |
nvarchar(6) | Ja | — | — |
RcpWhsId |
nvarchar(10) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("Receipt")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Receipt")· ../entities/Receipt Properties, contexts, statussen. Bron:Entities.xml.