| PKID | integer | plain | | | Transaction ID |
| fork | integer | plain | | forks.ID | Fork ID (`null` for base module) |
| ownergroup | integer | plain | | groups.ID | Owner group ID (`null`=PUBLIC) |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| assigneduser | integer | plain | | users.ID | Assigned user ID |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| account | integer | plain | | accounts.ID | Account ID; must be `null` for PRODUCTION |
| item | integer | plain | | items.ID | Item ID; must be `null` for BILLING and PROCUREMENT |
| contract | integer | plain | | contracts.ID | Contract ID |
| transactionnum | text | main | | | Transaction number |
| type | smallint | plain | | | Default: 0Transaction type (`0`=BILLING_QUOTE, `1`=BILLING_ORDER, `2`=BILLING_DELIVERY, `3`=BILLING_INVOICE, `4`=BILLING_CREDIT, `5`=PROCUREMENT_REQUEST, `6`=PROCUREMENT_ORDER, `7`=PROCUREMENT_DELIVERY, `8`=PROCUREMENT_INVOICE, `9`=PROCUREMENT_CREDIT, `10`=PRODUCTION_FABRICATION, `11`=PRODUCTION_DISASSEMBLY) |
| date | bigint | plain | | | Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation) |
| duedate | bigint | plain | | | Due date as a Unix timestamp |
| status | smallint | plain | | | Default: 0Status (`0`=DRAFT, `1`=BOOKED, `2`=HOLD, `3`=CANCELLED, `4`=CLOSED, `5`=PARTLYORDERED, `6`=PARTLYORDERED_CANCELLED, `7`=PARTLYORDERED_CLOSED, `8`=ORDERED, `9`=PARTLYDELIVERED, `10`=PARTLYDELIVERED_CANCELLED, `11`=PARTLYDELIVERED_CLOSED, `12`=DELIVERED, `13`=PARTLYINVOICED, `14`=PARTLYINVOICED_CANCELLED, `15`=PARTLYINVOICED_CLOSED, `16`=INVOICED, `17`=PARTLYPAID, `18`=PARTLYPAID_CANCELLED, `19`=PARTLYPAID_CLOSED, `20`=PAID, `21`=OVERPAID, `22`=PROCESSED, `23`=PROCESSED_CANCELLED) |
| calculation | smallint | plain | | | Default: 0Calculation method (`0`=NET, `1`=GROSS, `2`=EXACT, `3`=LEGACY, `4`=EXTERNAL) |
| productionfactor | integer | plain | | | Production factor; is required for PRODUCTION, otherwise must be `null` |
| currency | character varying(3) | extended | | | Currency code (ISO 4217) |
| exchangerate | double precision | plain | | | Default: 1Exchange rate as a multiple of one monetary unit of the fixed system currency |
| taxid | text | extended | | | Default: ''Buyer Tax ID (e.g. VATIN or SSN) |
| shippingrecipient | text | extended | | | Default: ''Shipping recipient |
| shippingaddress | text | extended | | | Default: ''Shipping address (street and building/suite number) |
| shippingpostalcode | text | extended | | | Default: ''Shipping postal or ZIP code |
| shippingcity | text | extended | | | Default: ''Shipping city or locality |
| shippingregion | text | extended | | | Default: ''Shipping region or state |
| shippingcountry | character varying(2) | extended | | | Default: ''Shipping country code (ISO 3166-1 alpha-2) |
| billingrecipient | text | extended | | | Default: ''Billing recipient |
| billingaddress | text | extended | | | Default: ''Billing address (street and building/suite number) |
| billingpostalcode | text | extended | | | Default: ''Billing postal or ZIP code |
| billingcity | text | extended | | | Default: ''Billing city or locality |
| billingregion | text | extended | | | Default: ''Billing region or state |
| billingcountry | character varying(2) | extended | | | Default: ''Billing country code (ISO 3166-1 alpha-2) |
| sellertaxid | text | extended | | | Default: ''Seller Tax ID (e.g. VATIN or SSN) |
| sellername | text | extended | | | Default: ''Seller Name |
| selleraddress | text | extended | | | Default: ''Seller address (street and building/suite number) |
| sellerpostalcode | text | extended | | | Default: ''Seller postal or ZIP code |
| sellercity | text | extended | | | Default: ''Seller city or locality |
| sellerregion | text | extended | | | Default: ''Seller region or state |
| sellercountry | character varying(2) | extended | | | Default: ''Seller country code (ISO 3166-1 alpha-2) |
| discount | double precision | plain | | | Default: 0Total absolute discount |
| netamount | double precision | plain | | | Default: 0Total net amount |
| tax | double precision | plain | | | Default: 0Total tax amount |
| margin | double precision | plain | | | Default: 0Total absolute margin |
| weight | double precision | plain | | | Default: 0Total shipping weight in kilogram |
| items | json | extended | | | JSON-encoded items (array) |