Data Opening Stock
| Opening Stock ID |
Transaction Date |
Location ID |
Product ID |
AV Price Unit |
SOH |
Approve Status |
Approve Date |
Approve By |
Inv_Daily_Soh
| Daily SOH Id |
Transaction Date |
Location ID |
Product ID |
SOH |
Inv_Monthly_Soh
| Monthly SOH Id |
Year Month |
Location ID |
Product ID |
SOH |
Inv_Quarter_Soh
| Quarter SOH Id |
Quarter Code |
Year |
Location ID |
Product ID |
SOH |
Inv_Yearly_Soh
| Yearly SOH Id |
Year |
Location ID |
Product ID |
SOH |
Inv_Item_Daily_Soh
| Item Daily SOH Id |
Transaction Date |
Product ID |
SOH |
Inv_Item_Monthly_Soh
| Item Monthly SOH Id |
Year Month |
Product ID |
SOH |
Inv_Item_Quarter_Soh
| Item Quarter SOH Id |
Quarter Code |
Year |
Product ID |
SOH |
Inv_Item_Yearly_Soh
| Item Yearly SOH Id |
Year |
Product ID |
SOH |
Inv_Daily_Stockin
| Daily Stockin Id |
Transaction Date |
Product ID |
Location ID |
Quantity Unit |
Inv_Month_Stockin
| Monthly Stockin Id |
Year Month |
Product ID |
Location ID |
Quantity Unit |
Inv_Quarter_Stockin
| Quarter Stockin Id |
Quarter Code |
Year |
Product ID |
Location ID |
Quantity Unit |
Inv_Yearly_Stockin
| Yearly Stockin Id |
Year |
Product ID |
Location ID |
Quantity Unit |
Inv_Item_Daily_Stockin
| Item Daily Stockin Id |
Transaction Date |
Product ID |
Quantity Unit |
Inv_Item_Monthly_Stockin
| Item Monthly Stockin Id |
Year Month |
Product ID |
Quantity Unit |
Inv_Item_Quarter_Stockin
| Item Quarter Stockin Id |
Quarter Code |
Year |
Product ID |
Quantity Unit |
Inv_Item_Yearly_Stockin
| Item Yearly Stockin Id |
Year |
Product ID |
Quantity Unit |
Fms_Journal
| Journal Id |
Transaction Date |
Data Source |
Data Source Id |
Location ID |
Coa ID |
Amount |
Position |
Fms_Daily_Balance
| Daily Balance Id |
Transaction Date |
Coa ID |
Balance |
Fms_Monthly_Balance
| Monthly Balance Id |
Year Month |
Coa ID |
Balance |
Fms_Quarter_Balance
| Quarter Balance Id |
Quarter Code |
Year |
Coa ID |
Balance |
Fms_Yearly_Balance
| Yearly Balance Id |
Year |
Coa ID |
Balance |
Fms_Coa_Daily_PNL
| Coa Daily PNL Id |
Transaction Date |
Coa ID |
Balance |
Fms_Coa_Monthly_PNL
| Coa Monthly PNL Id |
Year Month |
Coa ID |
Balance |
Fms_Coa_Quarter_PNL
| Coa Quarter PNL Id |
Quarter Code |
Year |
Coa ID |
Balance |
Fms_Coa_Yearly_PNL
| Coa Yearly PNL Id |
Year |
Coa ID |
Balance |
Fms_Daily_PNL
| Daily PNL Id |
Transaction Date |
Balance |
Fms_Monthly_PNL
| Coa Monthly PNL Id |
Year Month |
Balance |
Fms_Quarter_PNL
| Quarter PNL Id |
Quarter Code |
Year |
Balance |
Fms_Yearly_PNL
| Yearly PNL Id |
Year |
Balance |
Fms_Loc_Daily_Balance
| Daily Balance Id |
Location |
Transaction Date |
Coa ID |
Balance |
Fms_Loc_Quarter_Balance
| Loc Quarter Balance Id |
Location |
Quarter Code |
Year |
Coa ID |
Balance |
Fms_Loc_Yearly_Balance
| Loc Yearly Balance Id |
Location |
Year |
Coa ID |
Balance |
Fms_Loc_Daily_PNL
| Loc Daily PNL Id |
Location |
Transaction Date |
Balance |
Fms_Loc_Monthly_PNL
| Loc Monthly PNL Id |
Location |
Year Month |
Balance |
Fms_Loc_Quarter_PNL
| Loc Quarter PNL Id |
Location |
Quarter Code |
Year |
Balance |
Fms_loc_Yearly_PNL
| Loc Yearly PNL Id |
Location |
Year |
Balance |