transactiondetailviewnooffset
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
Last updated