Resource

Group

b_htr_stat

Name

BI_CUSTOMER_COMPANY_V

Description

View für PowerBI mit Kunde-Mandant

Entity

Name Type DBType Nullable
Customer_Company_Id Int64 NUMBER (10) False
Create_user String VARCHAR2 (30) False
Create_Date DateTime DATE (7) False
Modify_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Customer_Id Int64 NUMBER (10) False
Company_No Int32 NUMBER (6) False
C26_Currency Int32 NUMBER (8) False
Currency String VARCHAR2 (120) True
Sales_Channel String VARCHAR2 (3) True
Cash_Payer_Bool Int32 NUMBER (1) False
Private_Surcharge_Bool Int32 NUMBER (1) False
C4504_Billing_Type Int32 NUMBER (8) True
Billing_Type String VARCHAR2 (100) True
C1502_Invoice_Periodicity Int32 NUMBER (8) True
Invoice_Periodicity String VARCHAR2 (100) True
Comment String VARCHAR2 (4000) True
No_Of_Copies_Offer Int32 NUMBER (2) False
No_Of_Copies_Order_Confirm Int32 NUMBER (2) False
No_Of_Copies_Proforma_Invoice Int32 NUMBER (2) False
No_Of_Copies_Invoice Int32 NUMBER (2) False
Active_Bool Int32 NUMBER (1) False
C4570_Price_Category Int32 NUMBER (8) True
Price_Category String VARCHAR2 (100) True
Email_Delivery_Note_Bool Int32 NUMBER (1) False
C27_Payment_Terms Int32 NUMBER (8) True
Payment_Terms String VARCHAR2 (100) True
Cost_Unit_No String VARCHAR2 (20) True
Invoice_Bp_Addr_Id Int64 NUMBER (10) False
Output_Vat_Id String VARCHAR2 (20) True
C126_Export_Indicator Int32 NUMBER (8) True
Export_Indicator String VARCHAR2 (100) True
C3305_Sales_Area Int32 NUMBER (8) True
Sales_Area String VARCHAR2 (100) True
Invoice_Shipping_Bp_Addr_Id Int64 NUMBER (10) True
Allocation_Type String VARCHAR2 (6) False
Your_Reference String VARCHAR2 (200) True
Customer_Asvid Int64 NUMBER (10) True
c3343_Report_Interval Int32 NUMBER (8) False
Report_Interval String VARCHAR2 (100) True
Vat_Order_Indicator_Id Int64 NUMBER (10) True
Surcharge_Model_Id Int64 NUMBER (10) True
Vat_Order_Ind_Overridable_Bool Int32 NUMBER (1) False
Cost_Center_No String VARCHAR2 (20) True
Collective_Invoicing_Bool Int32 NUMBER (1) False
C124_Vat_System Int32 NUMBER (8) True
Vat_System String VARCHAR2 (100) True
Inter_Company_No Int32 NUMBER (6) True