Field Name

Description

Type

Length

slIdxRecSub

SD

String

2

slSubType_D

D

String

1

slIdxStockLoc

String

30

slIdxLocStock

Stock Code

String

45

slIdxSupp

Preferred Supplier

String

31

slStockCode

Stock Code

Lstring

21

idxStockCode

Stock Code

String

20

slStockFolio

Integer

4

IdxLocCode

Location Code

String

3

slLocCode

Location Code

Lstring

4

slQtyInStock

Quantity In Stock

Float

8

slQtyOnOrder

Quantity On Order

Float

8

slQtyAllocated

Quantity Allocated

Float

8

slQtyPicked

Quantity Picked

Float

8

slQtyMin

Minimum Stock Level

Float

8

slQtyMax

Maximum Stock Level

Float

8

slQtyFreeze

Stock Freeze Quantity

Float

8

slReOrderQty

Float

8

slReOrderDate

Lstring

9

slRoDepartment

Lstring

4

slROCostCentre

Lstring

4

slDepartment

Default Department

Lstring

4

slCostCentre

Default Cost Centre

Lstring

4

slBinLocation

Bin Location

Lstring

11

slSalesBandACur

Sales Currency - Band A

Integer

1

slSalesBandAPrice

Sales Price - Band A

Float

slSalesBandBCur

Sales Currency - Band B

Integer

1

slSalesBandBPrice_1

Sales Price - Band B

Float

slSalesBandBPrice_2

Sales Price - Band B 2

Integer

4

slSalesBandCCur

Sales Currency - Band C

Integer

1

slSalesBandCPrice_1

Sales Price - Band C

Float

slSalesBandDCur

Sales Currency - Band D

Integer

1

slSalesBandDPrice_1

Sales Price - Band D

Float

slSalesBandECur

Sales Currency - Band E

Integer

1

slSalesBandEPrice_1

Sales Price - Band E

Float

slSalesBandFCur

Sales Currency - Band F

Integer

1

slSalesBandFPrice_1

Sales Price - Band F

Float

slSalesBandGCur

Sales Currency - Band G

Integer

1

slSalesBandGPrice_1

Sales Price - Band G

Float

slSalesBandHCur

Sales Currency - Band H

Integer

1

slSalesBandHPrice_1

Sales Price - Band H

Float

slReOrderPrice

Re-Order Price

Float

8

slReOrderCur

Re-Order Price Currency

Integer

1

slCostPrice

Cost Price

Float

8

slCostPriceCur

Cost Price Currency

Integer

1

slSalesGL

Sales GL Code

Integer

4

slCOSGL

Cost Of Sales GL Code

Integer

4

slP&LGL

Write Offs/Closing Stock GL Code

Integer

4

slBalSheetGL

Stock Value GL Code

Integer

4

slWIPGL

Work In Progress GL Code

Integer

4

slStkFlag

Logical

1

slMinFlag

Logical

1

slTempSupp

Lstring

7

slSupplier

Preferred Supplier

Lstring

7

slLastUsed

Last Used Date

Date

8

slQtyPosted

Quantity Posted

Float

8

slQtyTake

Stock Take Quantity

Float

8

slROFlag

Logical

1

slTimeChange

Lstring

7

slQtyAllocWOR

Float

8

slQtyIssuedWOR

Float

8

slQtyPickedWOR

Float

8

slWOPIssuedWIPGL

Integer

4

slSalesWarrantyLengt

Integer

1

slSalesWarrantyUnits

Integer

1

slManWarrantyLength

Integer

1

slManWarrantyUnits

Integer

1

slPurchaseReturnQty

Purchase Return Qty

Float

8

slSalesReturnGL

Sales Returns GL

Integer

4

slRestockCharge

Float

8

slRestockGL

Integer

4

slBOMDedComp

Logical

1

slSalesReturnQty

Sales Return Qty

Float

8

slPurchaseReturnGL

Purchase Returns GL

Integer

4