config/ecc/annotations/raw/afvv.yaml (366 lines of code) (raw):

name: "{{ project_id_src }}.{{ dataset_raw_landing }}.afvv" description: "DB structure of the quantities/dates/values in the operation" fields: - name: "abrue" description: "Teardown" - name: "aplzl" description: "Counter" - name: "arbeh" description: "Unit for work" - name: "arbei" description: "Work" - name: "aruze" description: "Teardown unit" - name: "asvrg" description: "Scrap Quantity" - name: "aufkt" description: "Execution factor" - name: "aufpl" description: "Opertn task list no." - name: "bearp" description: "Processing time" - name: "bearz" description: "Processing time" - name: "beaze" description: "Processing time unit" - name: "beazp" description: "Processing time unit" - name: "bmsch" description: "Base Quantity" - name: "bzoffb" description: "Ref. date for start" - name: "bzoffe" description: "Ref. date for finish" - name: "daume" description: "Minimum durat. unit" - name: "daumi" description: "Min. duration" - name: "daune" description: "Normal duration unit" - name: "dauno" description: "Normal duration" - name: "ehoffb" description: "Unit" - name: "ehoffe" description: "Unit" - name: "einsa" description: "Constraint on start" - name: "einse" description: "Constraint on finish" - name: "epanf" description: "Dispatched start" - name: "epanz" description: "Dispatched start" - name: "epend" description: "Dispatched finish" - name: "epenz" description: "Dispatched finish" - name: "ewdam" description: "Forecast min. duratn" - name: "ewdan" description: "Normal duration (F)" - name: "ewdme" description: "Min. duration unit" - name: "ewdne" description: "Unit/normal dur.(F)" - name: "ewend" description: "Forecast finish date" - name: "ewenz" description: "Forecast finish time" - name: "ewsta" description: "Constraint on start" - name: "ewstd" description: "Forecast start date" - name: "ewste" description: "Constraint on finish" - name: "ewstz" description: "Forecast start time" - name: "fpavd" description: "Earliest start date" - name: "fpavz" description: "Earliest start" - name: "fpedd" description: "Earliest scheduled finish (date)" - name: "fpedz" description: "Earliest scheduled finish (time)" - name: "fsavd" description: "Earliest start date" - name: "fsavz" description: "Earliest start time" - name: "fsedd" description: "Earliest finish date" - name: "fsedz" description: "Earliest finish time" - name: "fseld" description: "Earliest finish date" - name: "fselz" description: "Earliest Finish Time" - name: "fssad" description: "Earliest start date" - name: "fssaz" description: "Earliest Start Time" - name: "fssbd" description: "Earliest start date" - name: "fssbz" description: "Earliest Start Time" - name: "fssld" description: "Earliest start date" - name: "fsslz" description: "Earliest Start Time" - name: "gmnga" description: "Confirmed yield" - name: "ieavd" description: "Actual Finish" - name: "iebd" description: "Actual finish (date)" - name: "iebz" description: "Time of act.finish" - name: "iedd" description: "Actual finish (date)" - name: "iedz" description: "Actual finish (time)" - name: "ierd" description: "Setup finish" - name: "ierz" description: "Setup finish" - name: "ile01" description: "Unit/activity" - name: "ile02" description: "Unit/activity" - name: "ile03" description: "Unit/activity" - name: "ile04" description: "Unit/activity" - name: "ile05" description: "Unit/activity" - name: "ile06" description: "Unit/activity" - name: "ipre1" description: "Unit/Process" - name: "iprk1" description: "No Remaining Act." - name: "iprz1" description: "Conf. Process Qty" - name: "isad" description: "Teardown start" - name: "isavd" description: "Operation start" - name: "isaz" description: "Teardown start" - name: "isbd" description: "Processing start" - name: "isbz" description: "Processing start" - name: "isdd" description: "Actual start (date)" - name: "isdz" description: "Actual start (time)" - name: "iserh" description: "Break time" - name: "ism01" description: "Confirmed activity" - name: "ism02" description: "Confirmed activity" - name: "ism03" description: "Confirmed activity" - name: "ism04" description: "Confirmed activity" - name: "ism05" description: "Confirmed activity" - name: "ism06" description: "Confirmed activity" - name: "ismnw" description: "Actual work" - name: "knote" description: "Points" - name: "liegz" description: "Wait time" - name: "ligze" description: "Unit for wait time" - name: "lmnga" description: "Confirmed yield" - name: "mandt" description: "Client (Mandant)" - name: "meinh" description: "Operation unit" - name: "mgvrg" description: "Operation Quantity" - name: "minwe" description: "Min. Send-Ahead Qty" - name: "ntanf" description: "Start constraint" - name: "ntanz" description: "Start time constr." - name: "ntend" description: "Finish Constraint" - name: "ntenz" description: "Fin. time constraint" - name: "offstb" description: "Offset to start" - name: "offste" description: "Offset to finish" - name: "ofm01" description: "Forecast value" - name: "ofm02" description: "Forecast value" - name: "ofm03" description: "Forecast value" - name: "ofm04" description: "Forecast value" - name: "ofm05" description: "Forecast value" - name: "ofm06" description: "Forecast value" - name: "ofmnw" description: "Forecast work" - name: "opre1" description: "UnitForRemainProcess" - name: "oprz1" description: "RemainQtyBusProc." - name: "pdae" description: "Un. forecast duratn" - name: "pdau" description: "Fcst durtn frm conf." - name: "pedd" description: "Forecast finish date" - name: "pedz" description: "Forecast End (Time)" - name: "plifz" description: "Planned Deliv. Time" - name: "pspm_indicator" - name: "puffp" description: "Free float" - name: "puffr" description: "Free float" - name: "pufgp" description: "Total float" - name: "pufgs" description: "Total float" - name: "qrastereh" description: "Grid msmt unit" - name: "qrastmeng" description: "QtyInterval insp." - name: "qrastzeht" description: "Time unit" - name: "qrastzfak" description: "Time factor" - name: "rmnga" description: "Rework qty" - name: "rstze" description: "Unit for setup time" - name: "ruest" description: "Setup time" - name: "rwfak" description: "Not Used" - name: "spavd" description: "Latest scheduled start date" - name: "spavz" description: "Latest start" - name: "spedd" description: "Latest end" - name: "spedz" description: "Latest scheduled finish (time)" - name: "ssavd" description: "Latest start date" - name: "ssavz" description: "Latest start time" - name: "ssedd" description: "Latest finish date" - name: "ssedz" description: "Latest finish time" - name: "sseld" description: "Latest finish date" - name: "sselz" description: "Latest finish time" - name: "sssad" description: "Latest start date" - name: "sssaz" description: "Latest Start Time" - name: "sssbd" description: "Latest Start Date" - name: "sssbz" description: "Latest Start Time" - name: "sssld" description: "Latest Start Date" - name: "ssslz" description: "Latest Start Time" - name: "takt" description: "Takt" - name: "tranz" description: "Move time" - name: "traze" description: "Unit for move time" - name: "umren" description: "Denominator" - name: "umrez" description: "Numerator" - name: "vge01" description: "Standard value unit" - name: "vge02" description: "Standard value unit" - name: "vge03" description: "Standard value unit" - name: "vge04" description: "Standard value unit" - name: "vge05" description: "Standard value unit" - name: "vge06" description: "Standard value unit" - name: "vgw01" description: "Standard Value" - name: "vgw02" description: "Standard Value" - name: "vgw03" description: "Standard Value" - name: "vgw04" description: "Standard Value" - name: "vgw05" description: "Standard Value" - name: "vgw06" description: "Standard Value" - name: "vstga" description: "Deviation reason" - name: "vstzw" description: "Deadline function" - name: "wartz" description: "Queue time" - name: "wrtze" description: "Unit for queue time" - name: "xmnga" description: "Confirmed Scrap" - name: "zeier" description: "Unit for Break Time" - name: "zeilm" description: "Unit for max. wait" - name: "zeilp" description: "Unit for req. wait" - name: "zeimb" description: "Min. processing time" - name: "zeimu" description: "Min. overlap time" - name: "zeitm" description: "Un.for MinMoveTime" - name: "zeitn" description: "Un.for StdMoveTime" - name: "zeiwm" description: "Un. for min. queue" - name: "zeiwn" description: "Un. for std. queue" - name: "zlmax" description: "Maximum wait time" - name: "zlpro" description: "Min. wait time" - name: "zmerh" description: "Break" - name: "zminb" description: "Min. processing time" - name: "zminu" description: "Min. overlap time" - name: "ztmin" description: "Min. move time" - name: "ztnor" description: "Std. move time" - name: "zwmin" description: "Min. queue time" - name: "zwnor" description: "Std. queue time"