TABLE DETAIL REFERENCE: ItemService
(Online VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 100 | True | True | True | True | %s | |
| FullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| Sku | 12 | VARCHAR | 100 | True | True | True | True | %s | |
| Description | 12 | VARCHAR | 4000 | True | True | True | True | %s | |
| IsActive | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| SubItem | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| ParentRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ClassRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
| Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| Taxable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| UnitPrice | 3 | DECIMAL | 18 | True | True | True | False | %10.7f | |
| RatePercent | 3 | DECIMAL | 15 | True | False | True | False | %7.6f | |
| Type | 12 | VARCHAR | 1000 | True | True | True | True | %s | |
| ItemCategoryType | 12 | VARCHAR | 14 | True | False | False | True | Product Service | |
| IncomeAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| IncomeAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| PurchaseDesc | 12 | VARCHAR | 1000 | True | True | True | True | %s | |
| PurchaseTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PurchaseCost | 3 | DECIMAL | 15 | True | True | True | False | %10.6f | |
| ExpenseAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ExpenseAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| AssetAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| AssetAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| TrackQtyOnHand | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| QtyOnHand | 3 | DECIMAL | 16 | True | True | True | False | %10.7f | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| PurchaseTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseTaxCodeRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| InvStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| SalesOrPurchaseDesc | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
| SalesOrPurchasePrice | 3 | DECIMAL | 16 | True | True | True | True | %10.7f | |
| SalesOrPurchasePricePercent | 3 | DECIMAL | 15 | True | True | True | True | %10.7f | |
| AbatementRate | 3 | DECIMAL | 18 | True | True | True | False | %11.7f | |
| ReverseChargeRate | 3 | DECIMAL | 18 | True | True | True | False | %11.7f | |
| ServiceType | 12 | VARCHAR | 32 | True | True | True | True | ADVT 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 | 1 | False | True | False | False | 1 0 true false |