Resource

Group

b_htr_stat

Name

BI_ACCRUAL_POS_V

Description

View für PowerBI mit Abgrenzungspositionen der LEVA+ Aufträge

Entity

Name Type DBType Nullable
Accrual_Pos_Id Int64 NUMBER (10) False
Rec_Vers 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
Company_No Int32 NUMBER (6) False
Accrual_Header_Id Int64 NUMBER (10) False
Origin String VARCHAR2 (10) False
Origin_Id Int64 NUMBER (10) False
Cost_Unit String VARCHAR2 (20) True
Flat_Rate_bool String VARCHAR2 (1) False
Currency String VARCHAR2 (3) False
Accrual_Amount Decimal NUMBER (16, 2) True
Ordered_Liable Decimal NUMBER (16, 2) True
Invoiced_Paid Decimal NUMBER (16, 2) True
Rendered Decimal NUMBER (16, 2) True
Proposal Decimal NUMBER (16, 2) True
Previous_Period Decimal NUMBER (16, 2) True
Buyer_Bp_Id Int64 NUMBER (10) True