|
|
Line 1: |
Line 1: |
− | '''Billing Data Mart informations:''' | + | '''Billing Datasource informations:''' |
| * invoice issue date; | | * invoice issue date; |
| * company code; | | * company code; |
Latest revision as of 02:33, 5 October 2022
Billing Datasource informations:
- invoice issue date;
- company code;
- branch code;
- invoice and item number;
- type of movement code and description;
- products groups descriptions (Levels 1, 2, 3 and 4);
- product code;
- product description;
- customers fancy name;
- customer city;
- customer state;
- customer's country;
- seller;
- product sales unit;
- sold amount;
- gross value;
- discount;
- total taxes (ICMS, ICMS SUBST, PIS and COFINS);
- commissions;
- total amount deducted from discounts, taxes and commissions;
- product cost;
- profit margin ;
- PIS value;
- Cofins value;
- ICMS value;
- ICMS ST value;
- IPI value;
- profit margin %;
- average Net value;
- average Total value.