Hello,
I have tried to modify a cash drop payout report (works before modification) to add the DropPayout.DropPayoutID, but get invalid column name error. I am looking for the transaction number that appears on the printed receipt for the payout or cash drop, and thought DropPayout.DropPayoutID was the correct column.
Also, is there some place that has all tables and all field names described?
Thanks, Greg Shepherd
Greg, I don't think a drop/payout gets a transaction number; the drop payout id field is just the primary key for the drop/payout record on the droppayout table; you can track it though by the droppayout.batchnumber field - to view tables and views in your db you can run"sp_tables" query (without the quotes)
- to view field properties in a table run "sp_columns item" to view item table columns; (replace item with whatever table you want to view ie droppayout, orderentry, etc)
H> Hello,
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.