transaction

Type: table

Columns

Column	Type	Attributes	Description
accountrowid	int
acknowledgementdate	datetime
acknowledgementprintscriptrowid	int
address1rowid	int
address2rowid	int
address3rowid	int
allowbackorder	tinyint
approvalstatus	varchar
approverusersrowid	int
auditnbr	int
auxiliarytransactionid	varchar
basecurrencyrowid	int
batchnbr	varchar
budgetmethod	varchar
budgetperiod	varchar
budgettyperowid	int
cancelleddate	datetime
checkforduplicatepurchaseorder	tinyint
classrowid	int
closelineitemswhentransactionisclosed	tinyint
companyrowid	int
contactrowid	int
contracttyperowid	int
currencyraterowid	int
currencyratetyperowid	int
currencyrowid	int
customermessagelistitemrowid	int
defaultsiterowid	int
description	varchar
discountdate	datetime
downpaymentamount	decimal
downpaymentamountcurrency	decimal
downpaymentduedate	datetime
duedate	datetime
effectivedate	datetime
emailmessagelistitemrowid	int
entereddate	datetime
estimateclosedate	datetime
estimatedrevenueamount	decimal
expirationdate	datetime
firstpaymentduedate	datetime
fiscalyear	varchar
fobrowid	int
instoredate	datetime
isactive	tinyint
isbillreceived	tinyint
isbudgetadjustment	tinyint
iscommitment	tinyint
iscredithold	tinyint
iscreditholdoverride	tinyint
isencumbrance	tinyint
isholdpayment	tinyint
isinvoicepaid	tinyint
isopeningbalance	tinyint
isoptout	tinyint
isprint	tinyint
ispurchaseorderissuerequired	tinyint
isrevenuerecognitioncompleted	tinyint
isreverse	tinyint
isundeposited	tinyint
jobrowid	int
maintenanceexpirationdate	datetime
monthlypaymentamount	decimal
monthlypaymentamountcurrency	decimal
orderdate	datetime
orderstatus	varchar
parentcurrencyraterowid	int
parentcurrencyratetyperowid	int
parentcurrencyrowid	int
parenteffectivedate	datetime
paymentmethodlistitemrowid	int
paymentmethodreference1	varchar
paymentmethodreference2	varchar
paymentmethodreference3	varchar
paymentselectionstatus	varchar
ponbr	varchar
portalstatus	tinyint
pricelevelrowid	int
printbatchnbr	varchar
printdate	datetime
printscriptrowid	int
printstatus	varchar
prioritylistitemrowid	int
probabilitypercent	decimal
productskuitemrowid	int
promiseddate	datetime
purchaseproductlinerowid	int
reasoncoderowid	int
receiptdate	datetime
receiptnbr	varchar
reconciliationaccountrowid	int
referencenbr	varchar
referralfee	decimal
referralfeecurrency	decimal
relationshiprowid	int
rowid	int	auto_increment
salecloseddate	datetime
saleissueddate	datetime
salesourcelistitemrowid	int
salespersonrelationshiprowid	int
salesproductlinerowid	int
salestagelistitemrowid	int
salestatuslistitemrowid	int
salestaxgrouprowid	int
saletypelistitemrowid	int
schedulerowid	int
shipbydate	datetime
shippingmethodlistitemrowid	int
spreadsheetrowid	int
status	varchar
subscriptionenddate	datetime
subscriptionstartdate	datetime
taskrowid	int
terminmonths	int
termrowid	int
totalamount	decimal
totalamountcurrency	decimal
totalcreditamount	decimal
totaldebitamount	decimal
transactioncategory	varchar
transactiondate	date
transactiondetaillinkrowid	int
transactiongroupid	varchar
transactionid	varchar
transactionlinkrowid	int
transactiontyperowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
userrowid	int
voiddate	datetime

v.ismain -- Wed, Feb 28, 2018 2:58 PM