|
  
|
||
|
|
||
The Stock Codes table contains the Alternate Stock Codes you have defined for your Stock items.
Relational Links
The Stock Codes can be linked relationally using the idxStockFolio field to the Stock. The idxAcCode, can be linked to IdxAcCode in the Supplier file.
Key Field: scIdxAltCode
Field Name |
Description |
Type |
Length |
scIdxRecSub |
NA |
String |
2 |
scIdxAltCode |
Alternate Stock Code |
String |
30 |
scIdxStkFol |
Stock Folio No |
String |
45 |
scIdxFolio |
|
String |
31 |
IdxStockFolio |
Stock Folio No |
Integer |
4 |
IdxAcCode |
Account Code |
String |
6 |
scReOrderCcy |
Reorder Currency |
Integer |
1 |
scReOrderPrice |
Reorder Price |
Float |
8 |
scLastUsed |
Last Used Date |
Date |
8 |
scOverrideRO |
Override Reorder Y/N |
Logical |
1 |
scDescription |
Description |
Lstring |
36 |
scLastTime |
|
Lstring |
7 |
