GP Tables

JC30201 - JC_Job_Transaction_OPEN_HIST

SQL Query Builder

19 Columns

Column Description Type Length
Cash * 1
Writeoffs * 4
GST * 6
PPS * 7
Other * 8
Sales 9
Trade 10
Freight 11
Miscellaneous 12
Taxes 13
COGS 14
Inventory 15
Returns 17
Service 20
ROUND * 26
RZGain * 27
RZLOSS * 28
URZGain * 29
URZLoss * 30

Related Tables

Tables that share columns with JC30201. Click "Join" to add to your query.

Cash

Writeoffs

GST

PPS

Other

Sales

Trade

Freight

Miscellaneous

Taxes