transactiondetailviewoffset

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