Field Name

Description

Type

Length

stStockCode

Stock Code

Lstring

21

IdxStockCode

Stock Code

String

16

stIdxStockCode

Stock Code

String

20

stDesc1

Description - Line 1

Lstring

36

stIdxDesc1

Description - Line 1

String

35

stDesc2

Description - Line 2

Lstring

36

stDesc3

Description - Line 3

Lstring

36

stDesc4

Description - Line 4

Lstring

36

stDesc5

Description - Line 5

Lstring

36

stDesc6

Description - Line 6

Lstring

36

stAltCode

Alternative Code

Lstring

21

stIdxAltCode

Alternative Code

String

20

stIdxSuppTemp

String

6

stSuppTemp

Lstring

11

stSalesGL

GL Code - Sales

Integer

4

stCOSGL

GL Code - Cost of Sales

Integer

4

stP&LGL

GL Code - Closing Stock/WIP

Integer

4

stBalSheetGL

GL Code - Stock Value

Integer

4

stWIPGL

GL Code - WIP

Integer

4

stReOrderFlag

Logical

1

stMinFlag

Logical

1

idxStockFolio

Stock Folio Number

Integer

4

stStockFolio

Stock Folio Number

Integer

4

stStockCat

Stock Group

String

16

stIdxStockCat

Stock Group

String

20

stStockType

Stock Type

String

1

stUnitOfStock

Unit Stock Qty

Lstring

11

stUnitOfSale

Unit Sales Qty

Lstring

11

stUnitOfPurch

Unit Purch Qty

Lstring

11

stCostPriceCur

Cost Currency

Integer

1

stCostPrice_1

Cost Price 1

Integer

2

stCostPrice_2

Cost Price 2

Integer

4

stSalesBandACur

Sales Band A Currency

Integer

1

stSalesBandAPrice_1

Sales Price - Band A 1

Integer

2

stSalesBandAPrice_2

Sales Price - Band A 2

Integer

4

stSalesBandBCur

Sales Band B Currency

Integer

1

stSalesBandBPrice_1

Sales Price - Band B 1

Integer

2

stSalesBandBPrice_2

Sales Price - Band B 2

Integer

4

stSalesBandCCur

Sales Band C Currency

Integer

1

stSalesBandCPrice_1

Sales Price - Band C 1

Integer

2

stSalesBandCPrice_2

Sales Price - Band C 2

Integer

4

stSalesBandDCur

Sales Band D Currency

Integer

1

stSalesBandDPrice_1

Sales Price - Band D 1

Integer

2

stSalesBandDPrice_2

Sales Price - Band D 2

Integer

4

stSalesBandECur

Sales Band E Currency

Integer

1

stSalesBandEPrice_1

Sales Price - Band E 1

Integer

2

stSalesBandEPrice_2

Sales Price - Band E 2

Integer

4

stSalesBandFCur

Sales Band F Currency

Integer

1

stSalesBandFPrice_1

Sales Price - Band F 1

Integer

2

stSalesBandFPrice_2

Sales Price - Band F 2

Integer

4

stSalesBandGCur

Sales Band G Currency

Integer

1

stSalesBandGPrice_1

Sales Price - Band G 1

Integer

2

stSalesBandGPrice_2

Sales Price - Band G 2

Integer

4

stSalesBandHCur

Sales Band H Currency

Integer

1

stSalesBandHPrice_1

Sales Price - Band H 1

Integer

2

stSalesBandHPrice_2

Sales Price - Band H 2

Integer

4

stSalesUnits_1

Sales Units/Stock 1

Integer

2

stSalesUnits_2

Sales Units/Stock 2

Integer

4

stPurchUnits_1

Purchase Units/Stock 1

Integer

2

stPurchUnits_2

Purchase Units/Stock 2

Integer

4

stVATCode

VAT Code

String

1

stDepartment

Department

String

3

stCostCentre

Cost Centre

String

3

stQtyInStock_1

Stock/Loc - Qty In Stock 1

Integer

2

stQtyInStock_2

Stock/Loc - Qty In Stock 2

Integer

4

stQtyPosted_1

Stock/Loc - Quantity Posted 1

Integer

2

stQtyPosted_2

Stock/Loc - Quantity Posted 2

Integer

4

stQtyAllocated_1

Stock/Loc - Quantity Allocated 1

Integer

2

stQtyAllocated_2

Stock/Loc - Quantity Allocated 2

Integer

4

stQtyOnOrder_1

Stock/Loc - Quantity On Order 1

Integer

2

stQtyOnOrder_2

Stock/Loc - Quantity On Order 2

Integer

4

stQtyMin_1

Stock/Loc - Min Stock Level 1

Integer

2

stQtyMin_2

Stock/Loc - Min Stock Level 2

Integer

4

stQtyMax_1

Stock/Loc - Max Stock Level 1

Integer

2

stQtyMax_2

Stock/Loc - Max Stock Level 2

Integer

4

stReOrderQty_1

Reorder Quantity 1

Integer

2

stReOrderQty_2

Reorder Quantity 2

Integer

4

stShowAsKit

Logical

1

stCommodCode

Commodity Code

Lstring

11

stSaleUnWeight_1

Weight - Sales 1

Integer

2

stSaleUnWeight_2

Weight - Sales 2

Integer

4

stPurchUnWeight_1

Weight - Purchase 1

Integer

2

stPurchUnWeight_2

Weight - Purchase 2

Integer

4

stSSDUnit

Intrastat Sales Unit

Lstring

11

stSSDSalesUnit_1

Integer

2

stSSDSalesUnit_2

Integer

4

stBinLocation

Bin Location

Lstring

11

stIdxBinLocation

Bin Location

String

10

stStkFlag

Logical

1

stCovPr

Integer

2

stCovPrunit

String

1

stCovMinPr

Minimum Cover Price

Integer

2

stCovMinUnit

Minimum Cover Unit

String

1

stSupplier

Preferred Supplier

String

6

IdxSupplier

Preferred Supplier

String

6

stQtyFreeze

Frozen Stock Level

Float

8

stCovSold

Covers Sold

Float

8

stUseCover

Use Covers

Logical

1

stCovMaxPr

Maximum Cover Price

Integer

2

stCovMaxUnit

Maximum Cover Unit

String

1

stReOrderCur

Reorder List Reorder Currency

Integer

1

stReOrderPrice

Reorder Cost Price

Float

8

stRODate

Reorder Date

Date

8

stQtyTake

Stock Take Count

Float

8

stStkValType

Valuation Method

String

1

stHasSerNo

Logical

1

stQtyPicked

Stock/Loc - Quantity Picked

Float

8

stLastUsed

Last Used Date

Date

8

stCalcPack

Logical

1

stJobAnal

Analysis Code

String

10

stUser1

User Defined Field 1

Lstring

21

stUser2

User Defined Field 2

Lstring

21

stIdxBarCode

Bar Code

String

20

stBarCode

Bar Code

Lstring

21

stRODepartment

Reorder Department

String

3

stROCostCentre

Reorder Cost Centre

String

3

stLocation

Default Location

String

3

stPricePack

Logical

1

stDPackQty

Logical

1

stKitPrice

Logical

1

stKitOnPurch

Logical

1

stDefLineType

Default Line Type

Integer

1

stQtyReturn

Sales Return Quantity

Float

8

stQtyAllocWOR

Quantity Allocated to WOR

Float

8

stQtyIssueWOR

Quantity Issued to WOR

Float

8

stUseForEBus

Include on Web flag

Integer

1

stWebLiveCatalog

Web Catalogue

Lstring

21

stWebPrevCatalog

Lstring

21

stUser3

User Defined Field 3

Lstring

31

stUser4

User Defined Field 4

Lstring

31

stValSerialAvgCost

Use Average Cost Serial No's

Integer

1

stSSDDespatchUplift

Intrastat Uplift Despatch Def%

Float

8

stSSDCountry

Intrastat Country Of Origin

Lstring

6

stTimeChange

Lstring

7

stInclusiveVATCode

Inclusive VAT Code

String

1

stSSDArrivalsUplift

Intrastat Uplift Arrivals Def%

Float

8

stOperator

Lstring

11

stImageFile

Image Filename

Lstring

31

stTempBinLocation

Lstring

11

stQtyPickedWOR

Quantity Picked on WOR

Float

8

stWOPWIPGL

WOP - WIP GL Code

Integer

4

stWOPAssemblyTime

Integer

4

stWOPROLeadTime

WOP Reorder Lead Time

Integer

4

stWOPAutoCalcTime

Logical

1

stBOMAssemblyTime

Integer

4

stWOPMinEconBuild

WOP Minimum Economic Build

Float

8

stUsesBins

Use Multi Bins

Logical

1

stSalesWarrantyLengt

Sales Warranty Period

Integer

1

stManWarrantyLength

Manufacturer Warranty Period

Integer

1

stSalesWarrantyUnits

Sales Warranty Units

Integer

1

stManWarrantyUnits

Manufacturer Warranty Units

Integer

1

stPurchaseReturnQty

Purchase Return Quantity

Float

8

stSalesReturnGL

Sales Returns GL Code

Integer

4

stRestockCharge

Recharge Value/%

Float

8

stPurchaseReturnGL

Purchase Returns GL Code

Integer

4

stRestockFlag

Recharge Flag ' '/'%'

String

1