|
  
|
||
|
|
||
The Serial/Batch Number table contains details of the Serial or Batch Number Tracking within Exchequer.
Relational Links
The details can be relationally linked to the Transactions (thOurRef) it represents through the snInOurRef, snOutOurRef, snInOrderRef and snOutOrderRef fields, and to the Lines on those transactions (IdxLineNo) using the snBuyLine, snSoldLine, snInOrderLine and snOutOrderLine fields respectively. It can be linked to its parent Stock item through the IdxStockFolio field. It can also be linked to Locations (IdxLocCode) through the snInLoc and snOutLoc fields.
Field Name |
Description |
Type |
Length |
snIdxRecSub |
FR |
String |
2 |
snRecType |
F |
String |
1 |
snSubType |
R |
String |
1 |
snIdxStkFolio |
Stock Folio No |
String |
26 |
snSerialNo |
Serial Number |
Lstring |
21 |
snIdxSerialNo |
Serial Number |
String |
20 |
snBatchNo |
Batch Number |
Lstring |
11 |
snInOurRef |
In Document |
String |
10 |
snOutOurRef |
Our Document |
String |
10 |
snSold |
Sold (Y/N) |
Logical |
1 |
snSpare |
Future Use |
Lstring |
9 |
snCostPrice |
Cost Price |
Float |
8 |
snSalesPrice |
Sales Price |
Float |
8 |
IdxStockFolio |
Stock Folio No |
Integer |
4 |
snDateOut |
Date Booked Out |
Date |
8 |
snSoldLine |
Sell Doc Line No |
Integer |
4 |
snCostCur |
Cost Currency |
Integer |
1 |
snSalesCur |
Sell Currency |
Integer |
1 |
snBuyLine |
Cost Doc Line No |
Integer |
4 |
snIsBatch |
Batch Record (Y/N) |
Logical |
1 |
snQtyBuy |
Batch Original Qty Bought |
Float |
8 |
snQtyUsed |
Batch Qty Used |
Float |
8 |
snBatchSale
1 = Sell Line 0 = Original Batch Purchased |
Batch Sales Record |
Logical |
1 |
snInLoc |
In Location |
String |
3 |
snOutLoc |
Out Location |
String |
3 |
snCompanyRate_1 |
Company Cost Rate 1 |
Integer |
2 |
snCompanyRate_2 |
Company Cost Rate 2 |
Integer |
4 |
snDailyRate_1 |
Daily Cost Rate 1 |
Integer |
2 |
snDailyRate_2 |
Daily Cost Rate 2 |
Integer |
4 |
snInOrderRef |
In Oder Reference |
String |
10 |
snOutOrderRef |
Out Order Reference |
String |
10 |
snInOrderLine |
In Order Line |
Integer |
4 |
snOutOrderLine |
Out Order Line |
Integer |
4 |
snNoteFolio |
|
Integer |
4 |
snUseBy |
Use By Date |
Date |
8 |
snUseORate |
|
Integer |
1 |
snTriRate |
|
Float |
8 |
snTriEuro |
|
Integer |
1 |
snTriInvert |
|
Logical |
1 |
snTriFloat |
|
Logical |
1 |
snTriSpare |
|
String |
10 |
snChildNoteFolio |
|
Integer |
4 |
snBinCode |
Bin code |
Lstring |
11 |
snReturned |
Returned Y/N |
Logical |
1 |
snBatchReturnedQty |
Batch Returned Quantity |
Float |
8 |
snReturnOurRef |
SRN Our Ref |
Lstring |
11 |
snReturnLineNo |
Returns Line No |
Integer |
4 |
