config/s4/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: "Planned Scrap" - 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: "Reference Start Date" - name: "bzoffe" description: "Reference Date End" - 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: "Start Offset Unit" - name: "ehoffe" description: "End Offset 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 Scheduled Wait End Date" - name: "fselz" description: "Earliest Scheduled Wait End 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 Scheduled Wait Start Date" - name: "fsslz" description: "Earliest Scheduled Wait Start Time" - name: "gmnga" description: "Confirmed Yield in Order Unit of M." - name: "ieavd" description: "Actual Operation End Date" - name: "iebd" description: "Actual Processing End Date" - name: "iebz" description: "Actual Processing End Time" - name: "iedd" description: "Actual Execution End Date" - name: "iedz" description: "Actual Execution End Time" - name: "ierd" description: "Actual Setup End Date" - name: "ierz" description: "Actual Setup End Time" - 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: "Process Unit" - name: "iprk1" description: "No Remaining Act." - name: "iprz1" description: "Confirmed Process Quantity" - name: "isad" description: "Actual Teardown Start Date" - name: "isavd" description: "Actual Operation Start Date" - name: "isaz" description: "Actual Teardown Start Time" - name: "isbd" description: "Actual Processing Start Date" - name: "isbz" description: "Actual Processing Start Time" - name: "isdd" description: "Actual Execution Start Date" - name: "isdz" description: "Actual Execution Start Time" - name: "iserh" description: "Confirmed 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: "Wait Time Unit" - name: "lmnga" description: "Total 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: "Remain. Process Unit" - name: "oprz1" description: "Remain.QtyBus.Proc." - 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: "Confirmed Rework Quantity" - name: "rstze" description: "Setup Time Unit" - 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 Scheduled Wait End Date" - name: "sselz" description: "Latest Scheduled Wait End Time" - name: "sssad" description: "Latest start date" - name: "sssaz" description: "Lat.start time" - name: "sssbd" description: "Latest start date" - name: "sssbz" description: "Latest start time" - name: "sssld" description: "Latest Scheduled Wait Start Date" - name: "ssslz" description: "Latest Scheduled Wait Start Time" - name: "takt" description: "Takt" - name: "tranz" description: "Move Time" - name: "traze" description: "Move Time Unit" - 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: "Queue Time Unit" - name: "xmnga" description: "Confirmed Scrap" - name: "zeier" description: "Break Time Unit" - name: "zeilm" description: "Max. Wait Time Unit" - name: "zeilp" description: "Req. Wait Time Unit" - name: "zeimb" description: "Processing Time Unit" - name: "zeimu" description: "Min. Overlap Time" - name: "zeitm" description: "Un.for MinMoveTime" - name: "zeitn" description: "Un.for StdMoveTime" - name: "zeiwm" description: "Min. Queue Time Unit" - name: "zeiwn" description: "Std Queue Time Unit" - name: "zlmax" description: "Maximum Wait Time" - name: "zlpro" description: "Minimum Wait Time" - name: "zmerh" description: "Break Time" - name: "zminb" description: "Min. Processing Time" - name: "zminu" description: "Minimum Overlap Time" - name: "ztmin" description: "Minimum Move Time" - name: "ztnor" description: "Standard Move Time" - name: "zwmin" description: "Minimum Queue Time" - name: "zwnor" description: "Standard Queue Time"