Resource

Group

b_htr_stat

Name

BI_ORDER_BILLING_V

Description

View für PowerBI mit Auftragsverrrechnung-Information der LEVA+ Aufträge

Entity

Name Type DBType Nullable
Order_Billing_id Int64 NUMBER (10) False
Rec_Vers Int64 NUMBER (10) False
Modify_User String VARCHAR2 (30) False
Modify_Date DateTime DATE (7) False
Company_No Int32 NUMBER (6) False
Order_Header_Id Int64 NUMBER (10) False
C4571_Billing_Status Int32 NUMBER (8) False
Billing_Status String VARCHAR2 (100) False
Reference_Date DateTime DATE (7) False
C26_Inv_Curr Int32 NUMBER (8) False
Exchange_Rate Decimal NUMBER (14, 6) False
C17_Language Int32 NUMBER (8) False
Language String VARCHAR2 (100) False
Service_Date DateTime DATE (7) True
Accounting_Period Int32 NUMBER (6) True
Invoice_Date DateTime DATE (7) True
Value_Date DateTime DATE (7) True
Entry_Date DateTime DATE (7) True
Billing_bool Int32 NUMBER (1) False
Billing_Header_id Int64 NUMBER (10) True
Invoice_id Int64 NUMBER (10) True
Invoice_No Int64 NUMBER (10) True
Amount_Exkl_Inv_Curr Decimal NUMBER (16, 2) False
Comment String VARCHAR2 (500) True
C27_Payment_Terms Int32 NUMBER (8) False
Payment_Terms String VARCHAR2 (100) False
Order_Modified_bool Int32 NUMBER (1) False
Invoice_Header_Text String VARCHAR2 (4000) True
Invoice_Footer_Text String VARCHAR2 (4000) True
Customer_Mandant_id Int64 NUMBER (10) False
Reference_Purchaser_Bp_id Int64 NUMBER (10) True
Reference_Purchaser String VARCHAR2 (100) True
Invoice_Address_Bp_Addr_id Int64 NUMBER (10) False
Invoice_Shipping_Bp_Addr_id Int64 NUMBER (10) False
Project_Customer_Id Int64 NUMBER (10) True
Billing_Type String VARCHAR2 (6) False
Your_Reference String VARCHAR2 (200) True
C124_Vat_System Int32 NUMBER (8) False
Vat_System String VARCHAR2 (100) False
C126_Export_Indicator Int32 NUMBER (8) True
Export_Indicator String VARCHAR2 (100) True
Vat_Order_Indicator_id Int64 NUMBER (10) True
C6964_Collective_Invoicing_Status Int32 NUMBER (8) True
Collective_Invoicing_Status String VARCHAR2 (100) True