transactiondetailview

Type: view

Columns

Column	Type	Attributes	Description
acconttypenormalbalance	varchar
acconttypereconciled	smallint
acconttypesortorder	smallint
acconttypestatement	varchar
acconttypetrialbalancesection	varchar
accountcategoryrowid	int
accountformatted	varchar
accountid	varchar
accountname	varchar
accountrowid	int
accounttypedescription	varchar
accounttypeid	varchar
accounttyperowid	int
amount	decimal
amountdue	decimal
amountduecurrency	decimal
amountreceived	decimal
amountreceivedcurrency	decimal
box1099id	varchar
box1099rowid	int
classid	varchar
classrowid	int
companyrowid	int
creditamount	decimal
creditamountcurrency	decimal
debitamount	decimal
debitamountcurrency	decimal
discountamount	decimal
discountamountcurrency	decimal
displayorder	smallint
iscleared	tinyint
isdiscount	tinyint
ismemoline	tinyint
issalestax	tinyint
istaxable	tinyint
istransactionoffset	tinyint
itemid	varchar
itemrowid	int
itemtypeid	varchar
itemtypeuid	varchar
jobid	varchar
jobrowid	int
lotserialnbr	varchar
memo	varchar
paymentmethodlistitemrowid	int
quantity	decimal
quantityinvoiced	decimal
quantityreceived	decimal
quantityreturned	decimal
quantityshipped	decimal
referencedate	datetime
referencenbr	varchar
relationshipid	varchar
relationshiprowid	int
retrievetimestamp	date
rowid	int
transactioncategory	varchar
transactiondate	date
transactiondescription	varchar
transactiondetaillinkrowid	int
transactiondiscountdate	datetime
transactionduedate	datetime
transactionid	varchar
transactionisactive	tinyint
transactionisbillreceived	tinyint
transactioniscredithold	tinyint
transactioniscreditholdoverride	tinyint
transactionisholdpayment	tinyint
transactionisinvoicepaid	tinyint
transactionisopeningbalance	tinyint
transactionisreverse	tinyint
transactionlinkrowid	int
transactionreferencenbr	varchar
transactionrelationshiprowid	int
transactionrowid	int
transactiontermrowid	int
transactiontotalamount	decimal
transactiontypeid	varchar
transactiontypeisposting	tinyint
unitcost	decimal
unitid	varchar
unitrate	decimal
unitrowid	int

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