|
  
|
||
|
|
||
The FIFO table contains details of the FIFO Stock Tracking within Exchequer.
Relational Links
The FIFO details can be relationally linked to the transaction it represents through the idxFolio or IdxOurRef field, it can also be linked to the Transaction Line relating to the FIFO item through the IdxFolio and IdxLineNo fields. It can be linked to its stock record through the IdxStockFolio field, and its Customer/Supplier through the IdxAcCode field. It can also be linked to a Location through the fiLocation field.
Field Name |
Description |
Type |
Length |
fiIdxRecSub |
FS |
String |
2 |
fiRecType |
F |
String |
1 |
fiSubType |
S |
String |
1 |
fiIdxStockFolio |
Stock Folio Number |
String |
26 |
fiIdxDoc |
|
String |
20 |
IdxFolio |
|
Integer |
4 |
IdxStockFolio |
Stock Folio Number |
Integer |
4 |
IdxLineNo |
Transation Line No |
Integer |
4 |
fiDate |
Date |
Date |
8 |
fiQtyLeft |
Quantity Left |
Float |
8 |
IdxOurRef |
Document Our Ref |
String |
10 |
fiQty |
Quantity |
Float |
8 |
fiCost |
Cost |
Float |
8 |
fiCostCur |
Cost Currency Code |
Integer |
1 |
IdxAcCode |
Account Code |
String |
6 |
fiLocation |
Location Code |
String |
3 |
fiCompanyRate |
Company Rate |
Float |
2 |
fiDailyRate |
Daily Rate |
Integer |
2 |
fiUseORate |
|
Integer |
1 |
fiTriRate |
|
Float |
8 |
fiTriEuro |
|
Integer |
1 |
fiTriInvert |
|
Logical |
1 |
fiTriFloat |
|
Logical |
1 |
fiTriSpare |
|
String |
10 |
fiSpare |
Future Use |
String |
186 |
fiSpare2 |
Future Use |
String |
176 |
