TABLE DETAIL REFERENCE: ItemService
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
Sku12 VARCHAR 100TrueTrueTrueTrue%s
Description12 VARCHAR 4000TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SubItem-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
Taxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
UnitPrice3 DECIMAL 18TrueTrueTrueFalse%10.7f
RatePercent3 DECIMAL 15TrueFalseTrueFalse%7.6f
Type12 VARCHAR 1000TrueTrueTrueTrue%s
ItemCategoryType12 VARCHAR 14TrueFalseFalseTrue
Product
Service
IncomeAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
IncomeAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PurchaseDesc12 VARCHAR 1000TrueTrueTrueTrue%s
PurchaseTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PurchaseCost3 DECIMAL 15TrueTrueTrueFalse%10.6f
ExpenseAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
AssetAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AssetAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TrackQtyOnHand-7 BIT 1TrueTrueTrueFalse
1
0
true
false
QtyOnHand3 DECIMAL 16TrueTrueTrueFalse%10.7f
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PurchaseTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesOrPurchaseDesc12 VARCHAR 4000TrueTrueTrueFalse%s
SalesOrPurchasePrice3 DECIMAL 16TrueTrueTrueTrue%10.7f
SalesOrPurchasePricePercent3 DECIMAL 15TrueTrueTrueTrue%10.7f
AbatementRate3 DECIMAL 18TrueTrueTrueFalse%11.7f
ReverseChargeRate3 DECIMAL 18TrueTrueTrueFalse%11.7f
ServiceType12 VARCHAR 32TrueTrueTrueTrueADVT
AIRPORTSERVICES
AIRTRANSPORT
AIRTRVLAGNT
ARCHITECT
ASSTMGMT
ATMMAINTENANCE
AUCTIONSERV
AUTHSERST
BANKANDFIN
BEAUTYPARLOR
BROADCAST
BUSINESSAUX
BUSINESSEXHIBITION
BUSINESSSUPPORTSERV
CA
CABLEOPTR
CARGOHAND
CLEANINGSERV
CLEARANDFORW
CLUBSANDASSSERVICE
COMMCOACHORTRAINING
CONSENG
CONSTRCOMMERCIALCOMPLEX
CONTAINERRAILTRANS
CONVSERV
COSTACC
COURIER
CREDITCARD
CREDITRATAGNCY
CRUISESHIPTOUR
CS
CUSHOUSEAG
DESIGNSERV
DEVELOPSUPPLYCONTENT
DREDGING
DRYCLEANING
ERECTIONCOMMORINSTALL
EVENTMGMT
FASHIONDES
FOREXBROKING
FORWARDCONTRACT
FRANCHISESERV
GENERALINSURANCE
GOODSTRANSPORT
HEALTHCLUBANDFITNESS
INFORMATIONSERV
INSURAUX
INTDEC
INTELLECTUALPROPERTY
INTERNATIONALAIRTRAVEL
INTERNETCAFE
INTERNETTELEPHONY
LIFEINS
MAILLISTCOMPILE
MANDAPKEEPER
MANPWRRECRUIT
MGMTCONSUL
MGMTMAINTREPAIR
MININGOIL
MKTRESAGNCY
ONLINEINFORMRETRIEVAL
OPINIONPOLL
OUTDOORCATERING
PACKAGINGSERV
PANDALSHAMIANA
PHOTOGRAPHY
PORT
PORTSER
PROCESSCLEARHOUSE
PUBLICRELATIONMGMT
RAILTRAVELAGNT
REALESTAGT
RECOVERYAGENTS
REGISTRARSERV
RENTACAB
RENTINGIMMOVABLEPROP
RESIDENTIALCOMPLEXCONST
SALEOFSPACEFORADVT
SCANDTECHCONSUL
SECAG
SERVICESPROVIDEDFORTRANSACTION
SHARETRANSFERSERV
SHIPMGMT
SITEPREP
SOUNDRECORD
SPONSORSHIP
STAG
STOCKBROKING
STOCKEXCHGSERV
STORANDWAREHOUSING
SUPPLYTANGIBLEGOODS
SURVEYANDMAPMAKING
SURVEYMINERALS
TECHINSPECTION
TECHTESTING
TELECOMMUNICATIONSERV
TELEVISIONANDRADIO
TOUROP
TRANSPORTPIPELINE
TRAVELAGENT
ULIPMANAGEMENT
UNDERWRITER
VIDEOTAPEPROD
WORKSCONTRACT
DoNotUpdateAccountOnTxns-7 BIT 1FalseTrueFalseFalse
1
0
true
false