crm invoice
| invoice id |
sales order id |
sales order trx code |
trx code |
customer id |
customer name |
location id |
location name |
address |
memo |
transaction date |
referensi |
delivery no |
freight |
approve status |
approve date |
approve by |
company code |
invoice status |
invoice status date |
promise date |
Crm_invoice_detail
| Invoice detail id |
Invoice id |
Quantity invoice |
Quantity unit |
Product id |
Product Name |
Price invoice |
Discount |
Total |
Tax id |
Tax rate |
Total tax collect |
Company code |
Inv_mutasi_qty
| Mutasi Qty ID |
Transaction Date |
Data Source |
Data Source ID |
Location ID |
Product ID |
Qty |
Position |
Av Price Unit |
Company Code |
Inv_daily_soh
| Daily SOH Id |
Transaction Date |
Location ID |
Product ID |
SOH |
Company Code |
Inv_monthly_soh
| Monthly SOH Id |
Year Month |
Location ID |
Product ID |
SOH |
Company Code |
Inv_quarter_soh
| Quarter SOH Id |
Quarter Code |
Year |
Location ID |
Product ID |
SOH |
Company Code |
Inv_yearly_soh
| Yearly SOH Id |
Year |
Location ID |
Product ID |
SOH |
Company Code |
Inv_item_daily_soh
| Item Daily SOH Id |
Transaction Date |
Product ID |
SOH |
Company Code |
Inv_item_monthly_soh
| Item Monthly SOH Id |
Year Month |
Product ID |
SOH |
Company Code |
Inv_item_quarter_soh
| Item Quarter SOH Id |
Quarter Code |
Year |
Product ID |
SOH |
Company Code |
Inv_item_yearly_soh
| Item Yearly SOH Id |
Year |
Product ID |
SOH |
Company Code |
Inv_daily_stockout
| Daily Stockout Id |
Transaction Date |
Product ID |
Location ID |
Quantity Unit |
Company Code |
Inv_monthly_stockout
| Monthly stockout id |
Year Month |
Product ID |
Location ID |
Quantity Unit |
Company Code |
Inv_quarter_stockout
| Quarter stockout id |
Quarter Code |
Year |
Product ID |
Location ID |
Quantity Unit |
Company Code |
Inv_yearly_stockout
| Yearly stockout id |
Year |
Product ID |
Location ID |
Quantity Unit |
Company Code |
Inv_item_daily_stockout
| Item Daily Stockout Id |
Transaction Date |
Product ID |
Quantity Unit |
Company Code |
Inv_item_monthly_stockout
| Item Monthly Stockout Id |
Year Month |
Product ID |
Quantity Unit |
Company Code |
Inv_item_quarter_stockout
| Item quarter stockout id |
Quarter Code |
Year |
Product ID |
Quantity Unit |
Company Code |
Inv_item_yearly_stockout
| Item yearly stockout id |
Year |
Product id |
Product Name |
Quantity unit |
Company code |
Fms_journal
| Journal Id |
Transaction Date |
Data Source |
Data Source Id |
Location ID |
Coa ID |
Amount |
Position |
Product ID |
Company Code |
Fms_daily_balance
| Daily Balance Id |
Transaction Date |
Coa ID |
Balance |
Company Code |
Fms_monthly_balance
| Monthly Balance Id |
Year Month |
Coa ID |
Balance |
Company Code |
Fms_quarter_balance
| Quarter Balance Id |
Quarter Code |
Year |
Coa ID |
Balance |
Company Code |
Fms_yearly_balance
| Yearly Balance Id |
Year |
Coa ID |
Balance |
Company Code |
Fms_coa_daily_pnl
| Coa Daily PNL Id |
Transaction Date |
Coa ID |
Balance |
Company Code |
Fms_coa_monthly_pnl
| Coa Monthly PNL Id |
Year Month |
Coa ID |
Balance |
Company Code |
Fms_coa_quarter_pnl
| Coa Quarter PNL Id |
Quarter Code |
Year |
Coa ID |
Balance |
Company Code |
Fms_coa_yearly_pnl
| Coa Yearly PNL Id |
Year |
Coa ID |
Balance |
Company Code |
Fms_daily_pnl
| Daily PNL Id |
Transaction Date |
Balance |
Company Code |
Fms_monthly_pnl
| Coa Monthly PNL Id |
Year Month |
Balance |
Company Code |
Fms_quarter_pnl
| Quarter PNL Id |
Quarter Code |
Year |
Balance |
Company Code |
Fms_yearly_pnl
| Yearly PNL Id |
Year |
Balance |
Company Code |