Description
types of revenue and expenses that the sporting goods company has
Table properties
| name | value |
|---|
| name | GROUPO.FinancialCodes |
| row count | 7 |
| Maximum size of a single row | 62 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| Code | char(2) | 2 | | no
| yes
| |
| |
| Type | char(10) | 10 | | no
|
| |
| |
| Description | char(50) | 50 | | yes
|
| |
| |
Referenced by
Foreign key graph
Triggers
Dependency graph
Objects that depend on GROUPO.FinancialCodes
| name | object type | level |
|---|
| 2931 | trigger | 1 |
| 2938 | trigger | 1 |
Sample rows
| Code | Type | Description |
|---|
| e1
| expense
| Fees
|
| e2
| expense
| Services
|
| e3
| expense
| Sales & Marketing
|
| e4
| expense
| R & D
|
| e5
| expense
| Administration
|
| r1
| revenue
| Fees
|
| r2
| revenue
| Services
|
Code
CREATE TABLE "GROUPO"."FinancialCodes" (
"Code" char(2) NOT NULL
,"Type" char(10) NOT NULL
,"Description" char(50) NULL
,CONSTRAINT "FinancialCodesKey" PRIMARY KEY ("Code")
)