Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Multi Bins
Previous pageReturn to chapter overviewNext page

The Multi Bins table contains the Stock Bin Records.

Relational Links

Multi Bin records can be relationally linked to the Stock record via stStockFolio through brStockFolio. The In Transactions via thOurRef through brInDocRefand Out Transactions via thOurRef through brOurDocRef.

 

Field Name

Description

Type

Length

brIdxRecSub

IR

String

2

brSpare

Future Use

String

1

brBinCode

Multi Bin Code

String

10

brIdxCode1

 

String

30

brSpare1

Future Use

String

1

brIdxCode2

 

String

45

brSpare2

Future Use

String

1

brIdxCode3

 

String

31

brInDocRef

In Document OurRef

Lstring

11

brOurDocRef

Out Document OurRef

Lstring

11

brSold

Sold (Y/N)

Logical

1

brInDate

In Date

Date

8

brCostPrice

Cost Price

Float

8

brCapacity

Capacity

Float

8

brSpare3

Future Use

String

1

brStockFolio

Stock Folio

Integer

4

brOutDate

Out Date

Date

8

brOutDocLine

Out Document Line Number

Integer

4

brInDocLine

In Document Line Number

Integer

4

brSpare4

Future Use

String

1

brQty

Quantity

Float

8

brQtyUsed

Quantity Used

Float

8

brUsedRecord

Used Record

Logical

1

brInLocation

In Location

Lstring

4

brSpare5

Future Use

String

7

brOutLocation

Out Location

Lstring

4

brSpare6

Future Use

String

7

brOutOrderRef

Out Order Document OurRef

Lstring

11

brInOrderRef

In Order Document OurRef

Lstring

11

brInOrderLine

In Order Line Number

Integer

4

brOutOrderLine

Out Order Line Number

Integer

4

brCostPriceCurrency

Cost Currency

Integer

1

brPickingPriority

Picking Priority

Lstring

11

brSalesPrice

Sales Price

Float

8

brCompanyRate_1

Company Exchange Rate 1

Integer

2

brCompanyRate_2

Company Exchange Rate 2

Integer

4

brDailyRate_1

Daily Exchange Rate 1

Integer

2

brDailyRate_2

Daily Exchange Rate 2

Integer

4

brUseORate

 

Integer

1

brTriRate

 

Float

8

brTriEuro

 

Integer

1

brTriInvert

 

Logical

1

brTriFloat

 

Logical

1

brTriSpare

 

String

10

brUseByDate

Use By Date

Date

8

brSalesPriceCurrency

Sales Currency

Integer

1

brUnitOfMeasure

Unit of Measurement

Lstring

11

brAutoPickMode

Auto Pick Mode

Integer

1

brTagNo

Tag Number

Integer

1

brReturned

Returned Y/N

Logical

1

brSpare7

Future Use

String

254

brSpare8

Future Use

String

185

brSpare9

Future Use

String

255

brSpare10

Future Use

String

255

brSpare11

Future Use

String

24