Sage 100

Sage 100 ERP V4.30 --- question : What table stores credit card authorization numbers and transaction numbers

in v430, for Sales order, that data is stored directly in the SO_SalesOrderHeader.

I believe this is likely the closest answer as to where transactional data is stored. It seems that authorization numbers may be stored in the invoice history as opposed to one common table?

Perhaps - though I'm still looking for fields such as ""SettlementNumber"", ""TransNumber"",""Ticket"". These are all in the AR_CreditCardSettlementWrk and I presume are pulled from some data table.

I suspect maybe it's pulling data from AR_CashReceiptsHistory, AR_InvoiceHistoryPayment.

For current sales orders/invoices, AR_invoicepayment.

I believe they are in AR_DepositHistory (or something similar, cant look at the moment)

Sorry Wayne, didn't read the V4.30, disregard my comment.