Crm_payment_invoice
| payment_invoice_id |
transaction_date |
trx_code |
invoice_id |
customer_id |
location_id |
address |
memo |
referensi |
coa_id |
deposit_amount |
payment_amount |
approve_status |
approve_date |
approve_by |
company_code |
Crm_Daily_Customer_Minus
| Daily Customer Minus ID |
Transaction Date |
Customer ID |
Amount |
Crm_Monthly_Customer_Minus
| Monthly Customer Minus ID |
Year Month |
Customer ID |
Amount |
Crm_Quarter_Customer_Minus
| Quarter Customer Minus ID |
Quarter Code |
Year |
Customer ID |
Amount |
Crm_Yearly_Customer_Minus
| Year Customer Minus ID |
Year |
Customer ID |
Amount |
Crm_Daily_Customer_Balance
| Daily Customer Balance ID |
Transaction Date |
Customer ID |
Amount |
Crm_Monthly_Customer_Balance
| Monthly Customer Balance ID |
Year Month |
Customer ID |
Amount |
Crm_Quarter_Customer_Balance
| Quarter Customer Balance ID |
Quarter Code |
Year |
Customer ID |
Amount |
Crm_Yearly_Customer_Balance
| Yearly Customer Balance ID |
Year |
Customer ID |
Amount |
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_loc_daily_balance
| Loc Daily Balance Id |
COA |
Location |
Transaction Date |
Balance |
Company Code |
Fms_loc_monthly_balance
| Loc Monthly Balance Id |
COA |
Location |
Year Month |
Balance |
Company Code |
Fms_loc_quarter_balance
| Loc Quarter Balance Id |
COA |
Location |
Quarter Code |
Year |
Balance |
Company Code |
Fms_loc_yearly_balance
| Loc Yearly Balance Id |
COA |
Location |
Year |
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 |
Fms_loc_daily_pnl
| Daily PNL Id |
Location |
Transaction Date |
Balance |
Company Code |
Fms_loc_monthly_pnl
| Coa Monthly PNL Id |
Location |
Year Month |
Balance |
Company Code |
Fms_loc_quarter_pnl
| Quarter PNL Id |
Location |
Quarter Code |
Year |
Balance |
Company Code |
Fms_loc_yearly_pnl
| Yearly PNL Id |
Location |
Year |
Balance |
Company Code |
Fms_loc_coa_daily_pnl
| Daily PNL Id |
Location |
COA |
Transaction Date |
Balance |
Company Code |
Fms_loc_coa_monthly_pnl
| Coa Monthly PNL Id |
Location |
COA |
Year Month |
Balance |
Company Code |
Fms_loc_coa_quarter_pnl
| Quarter PNL Id |
Location |
COA |
Quarter Code |
Year |
Balance |
Company Code |
Fms_loc_coa_yearly_pnl
| Yearly PNL Id |
Location |
COA |
Year |
Balance |
Company Code |