Pro_Bill
| Bill ID |
PO ID |
Trx Code |
Vendor ID |
Location ID |
Address |
Memo |
Transaction Date |
Referensi |
Delivery No |
Freight |
Approve Status |
Approve Date |
Approve By |
Pro_Bill_Detail
| Bill Detail ID |
Bill ID |
Qty Bill |
Qty Unit |
Product ID |
Price Bill |
Discount |
Total |
Tax ID |
Tax Rate |
Total Tax Paid |
Inv_Mutasi_Qty
| Mutasi Qty ID |
Transaction Date |
Data Source |
Data Source ID |
Location ID |
Product ID |
Qty |
Position |
Av Price Unit |
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_Avg_Price_Real
| Avg Price Real Id |
Transaction Date |
Data Source |
Data Source Id |
Product ID |
Avg Real |
Current SOH |
Current Avg |
Input Qty |
Input Price |
Fms_Avg_Price_Last
| Avg Price Last Id |
Transaction Date |
Data Source |
Data Source Id |
Product ID |
Avg Last |
Fms_Avg_Price_Use
| Avg Price Use Id |
Transaction Date |
Data Source |
Data Source Id |
Product ID |
Avg Price Use |
Pro_Daily_Bill
| Daily Bill Id |
Transaction Date |
Product |
Location |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Monthly_Bill
| Monthly Bill Id |
Year Month |
Product |
Location |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Quarter_Bill
| Quarter Bill Id |
Quarter Code |
Year |
Product |
Location |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Yearly_Bill
| Yearly Bill Id |
Year |
Product |
Location |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Item_Daily_Bill
| Item Daily Bill Id |
Transaction Date |
Product |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Item_Monthly_Bill
| Item Monthly Bill Id |
Year Month |
Product |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Item_Quarter_Bill
| Item Quarter Bill Id |
Quarter Code |
Year |
Product |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Item_Yearly_Bill
| Item Yearly Bill Id |
Year |
Product |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Total_Daily_Bill
| Total Daily Bill Id |
Transaction Date |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Total_Monthly_Bill
| Total Monthly Bill Id |
Year Month |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Total_Quarter_Bill
| Total Quarter Bill Id |
Quarter Code |
Year |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Total_Yearly_Bill
| Total Yearly Bill Id |
Year |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Loc_Total_Daily_Bill
| Loc Total Daily Bill Id |
Transaction Date |
Location |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Loc_Total_Monthly_Bill
| Loc Total Monthly Bill Id |
Year Month |
Location |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Loc_Total_Quarter_Bill
| Loc Total Quarter Bill Id |
Quarter Code |
Year |
Location |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Pro_Loc_Total_Yearly_Bill
| Loc Total Yearly Bill Id |
Year |
Location |
Freight |
Qty Bill |
Qty Unit |
Total |
Total Tax Paid |
Fms_Journal
| Journal Id |
Transaction Date |
Data Source |
Data Source Id |
Location ID |
Coa ID |
Amount |
Position |
Product ID |
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_Loc_Daily_Balance
| Daily Balance Id |
Location |
Transaction Date |
Coa ID |
Balance |
Fms_Loc_Monthly_Balance
| Monthly Balance Id |
Location |
Year Month |
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_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_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 |
Fms_Loc_Coa_Daily_PNL
| Loc Coa Daily PNL Id |
Location |
COA |
Transaction Date |
Balance |
Fms_Loc_Coa_Monthly_PNL
| Loc Coa Monthly PNL Id |
Location |
COA |
Year Month |
Balance |
Fms_Loc_Coa_Quarter_PNL
| Loc Coa Quarter PNL Id |
Location |
COA |
Quarter Code |
Year |
Balance |
Fms_Loc_Coa_Yearly_PNL
| Loc Coa Yearly PNL Id |
Location |
COA |
Year |
Balance |