Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Customer-Stock-Hist
Previous pageReturn to chapter overviewNext page

The Customer-Stock-Hist table contains the Customers Stock History generated by the Telesales module. This history also contains details of any orders currently in progress.

Relational Links

The Customer-Stock-Hist can be relationally linked to the Customers table using the IdxAcCode field in both tables. It can be linked to the Stock table using the idxStockFolio field in both tables. It can be linked to the Telesales-Header table using the idxAcCode field.

 

Field Name

Description

Type

Length

csIdxRecSub

 

String

2

csIdxCode1

 

String

30

csIdxCode2

 

String

45

csIdxCode3

 

String

31

idxAcCode

Account Code

String

6

idxStockCode

Stcok Code

String

20

idxStockFolio

Stock Folio Number

Integer

4

csSOQty

 

Float

8

csLastDate

Last Date

Date

8

csLineNo

Document Line No

Integer

4

csLastPrice

Last Price

Float

8

csLPCurr

Last Price Currency

Integer

1

IdxJobCode

Job Code

String

10

IdxAnalCode

Job Analysis Code

String

10

csLocCode

Location Code

Lstring

6

csNomCode

General Ledger Code

Integer

4

csDepartment

Department

Lstring

4

csCostCentre

Cost Centre

Lstring

4

csQty

Quantity

Float

8

csNetValue

Net Value

Float

8

csDiscount

Discount

Float

8

csVATCode

VAT Code

String

1

csCost

Cost Price

Float

8

csDesc1

Stock Description Line 1

Lstring

36

csDesc2

Stock Description Line 2

Lstring

36

csDesc3

Stock Description Line 3

Lstring

36

csDesc4

Stock Description Line 4

Lstring

36

csDesc5

Stock Description Line 5

Lstring

36

csDesc6

Stock Description Line 6

Lstring

36

csVAT

VAT Amount

Float

8

csPrxPack

 

Logical

1

csQtyPack

 

Float

8

csQtyMul

 

Float

8

csDiscCh

 

String

1

csEntered

 

Logical

1

csUsePack

 

Logical

1

csShowCase

 

Logical

1

csLineType

 

Integer

1

csPriceMultiplier

 

Float

8

csInclusiveVATCode

 

String

1

csSpare1

Future Use

String

255

csSpare2

Future Use

String

8

csSpare3

Future Use

String

255

csSpare4

Future Use

String

255

csSpare5

Future Use

String

24