invantive documentation
Invantive Support ForumsLog In / Sign Up

StockTransactionTypes: Exact Online Domain StockTransactionTypes

read only

  • Catalog: ExactOnlineREST
  • Schema: CodeValues
  • Label: Domain StockTransactionTypes

Lookup-table that translates code values of the domain 'StockTransactionTypes' into descriptions.

Can only retrieve data.

Example

The code value '10' means 'Opening balance'.

Performance Characteristics

Characteristic Value
Estimated rows 30
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

Table Columns

The columns of the table StockTransactionTypes are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
code varchar2(240) Code fetched only when named Unique code within the domain.
description varchar2(4000) Description fetched only when named Meaning of the unique code within the domain.
domain varchar2(240) Domain fetched only when named Each domain defines a map of codes to values.
resource_code varchar2(240) Resource Code fetched only when named Resource code for internationalization.

Code Values

Code Description
10 itgen_eol_stocktransactiontypes_10
120 itgen_eol_stocktransactiontypes_120
121 itgen_eol_stocktransactiontypes_121
122 itgen_eol_stocktransactiontypes_122
123 itgen_eol_stocktransactiontypes_123
124 itgen_eol_stocktransactiontypes_124
125 itgen_eol_stocktransactiontypes_125
130 itgen_eol_stocktransactiontypes_130
131 itgen_eol_stocktransactiontypes_131
132 itgen_eol_stocktransactiontypes_132
133 itgen_eol_stocktransactiontypes_133
134 itgen_eol_stocktransactiontypes_134
135 itgen_eol_stocktransactiontypes_135
140 itgen_eol_stocktransactiontypes_140
141 itgen_eol_stocktransactiontypes_141
147 itgen_eol_stocktransactiontypes_147
148 itgen_eol_stocktransactiontypes_148
150 itgen_eol_stocktransactiontypes_150
151 itgen_eol_stocktransactiontypes_151
155 itgen_eol_stocktransactiontypes_155
156 itgen_eol_stocktransactiontypes_156
160 itgen_eol_stocktransactiontypes_160
161 itgen_eol_stocktransactiontypes_161
165 itgen_eol_stocktransactiontypes_165
166 itgen_eol_stocktransactiontypes_166
180 itgen_eol_stocktransactiontypes_180
181 itgen_eol_stocktransactiontypes_181
195 itgen_eol_stocktransactiontypes_195
196 itgen_eol_stocktransactiontypes_196
197 itgen_eol_stocktransactiontypes_197

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: